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.
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.
Share this post:
Responses (3)
-
Accepted Answer
-
Accepted Answer
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. -
Accepted Answer
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):
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./usr/clearos/sandbox/usr/bin/mysql -D reports -u reports -p`cut -f3 -d" " /var/clearos/system_database/reports`
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »