Forums

Resolved
0 votes
Dear folks,

One of my server with ClearOS 6.7 (Community-edition) has disk-space issue.
The /var/lib/system-mysql directory is occupying almost 6GB + of disk.

The system-database & log has sizes;

-rw-rw---- 1 system-mysql system-mysql 4649385984 Mar 28 13:10 ibdata1
-rw-rw---- 1 system-mysql system-mysql 134217728 Mar 28 13:10 ib_logfile0
-rw-rw---- 1 system-mysql system-mysql 134217728 Jan 13 15:02 ib_logfile1
drwx------ 2 system-mysql system-mysql 4096 Oct 26 11:46 mysql
srwxrwxrwx 1 system-mysql system-mysql 0 Mar 28 13:08 mysql.sock
drwx------ 2 system-mysql system-mysql 4096 Mar 28 12:49 reports

The reports subdirectory has proxy.MYD file of the size 1.6GB

Please suggest better way to reduce sizes of the system database and the proxy report.

Thanks in advance.


- Devendranath.
Monday, March 28 2016, 01:00 PM
Share this post:
Responses (3)
  • Accepted Answer

    Monday, April 11 2016, 04:15 PM - #Permalink
    Resolved
    0 votes
    Yes, that string dropped you into the mysql prompt. From there you can use the commands in the post I linked to.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, April 11 2016, 01:06 PM - #Permalink
    Resolved
    0 votes
    Thanks Nick.
    Unfortunately, the copy-paste drop me to '>' prompt.
    Please suggest.

    The directory /var/lib/system-mysql/reports has these files;

    total 3617824
    drwx------ 2 system-mysql system-mysql 4096 Apr 11 18:02 .
    drwxr-xr-x 4 system-mysql system-mysql 4096 Apr 11 17:57 ..
    -rw-rw---- 1 system-mysql system-mysql 65 Oct 26 11:47 db.opt
    -rw-rw---- 1 system-mysql system-mysql 9012 Oct 26 12:03 network.frm
    -rw-rw---- 1 system-mysql system-mysql 8660 Oct 26 11:47 proxy_domains.frm
    -rw-rw---- 1 system-mysql system-mysql 9382 Jan 15 03:02 proxy.frm
    -rw-rw---- 1 system-mysql system-mysql 2053632000 Apr 11 15:14 proxy.MYD
    -rw-rw---- 1 system-mysql system-mysql 1024 Apr 11 15:14 proxy.MYI
    -rw-rw---- 1 system-mysql system-mysql 1650946048 Apr 11 18:29 proxy.TMD
    -rw-rw---- 1 system-mysql system-mysql 9174 Oct 26 12:03 resource.frm

    This increase in size is the latest; it generated this proxy.TMD today..

    The disk-space is issue now.
    Please suggest solution for this.

    Thanks in advance.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, March 28 2016, 03:13 PM - #Permalink
    Resolved
    0 votes
    If you think it is in the reports section, there is some interesting sql stuff here. You can log onto your system-mysql with this great string (copy and paste):
    /usr/clearos/sandbox/usr/bin/mysql -D reports -u reports -p`cut -f3 -d" " /var/clearos/system_database/reports`
    See how big your tables are. I'd need to dig futher to look outside the reports area, and I'd probably do it from the mysql webconfig tool, but you need to do things to to enable it.
    The reply is currently minimized Show
Your Reply