| View previous topic :: View next topic |
| Author |
Message |
orange_juice
Guru
Joined: 16 Feb 2006
Posts: 588
Location: Athens - Greece
|
 Posted: Fri Feb 08, 2008 1:17 pm Post subject: mysqld-bin: Multiple instances of great size [solved] |
 |
|
Hallo!
Suddenly my /var partition has no space left!
After a little research, among other things, I have found the following sizes in my mysqld-bin files:
| Code: | du -csh /var/lib/mysql/mysqld-bin*
1,1G /var/lib/mysql/mysqld-bin.000001
1,1G /var/lib/mysql/mysqld-bin.000002
1,1G /var/lib/mysql/mysqld-bin.000003
599M /var/lib/mysql/mysqld-bin.000004
0 /var/lib/mysql/mysqld-bin.000005
0 /var/lib/mysql/mysqld-bin.000006
0 /var/lib/mysql/mysqld-bin.000007
0 /var/lib/mysql/mysqld-bin.000008
1,0K /var/lib/mysql/mysqld-bin.000009
1,0K /var/lib/mysql/mysqld-bin.index
3,6G total
|
Why is that?
I only use mysql for amarok and therefore I have no experience with it. I would appreciate your hints!
*** EDIT ***
I checked my logs and they were fluded with messages stating that certain tables were corrupted.
I tried to check and correct them with | Code: | myisamchk *.MYI
myisamchk -r |
However the mysqld-bin files are still there in occupying 3G!
*************
Kind regards,
orange_juice
Last edited by orange_juice on Sun Feb 10, 2008 10:16 pm; edited 1 time in total |
|
| Back to top |
|
 |
massimo
Veteran
Joined: 22 Jun 2003
Posts: 1226
|
|
| Back to top |
|
|
orange_juice
Guru
Joined: 16 Feb 2006
Posts: 588
Location: Athens - Greece
|
| Posted: Sun Feb 10, 2008 10:15 pm Post subject: |
|
|
Thank you for your help!
Kind regards,
orange_juice |
|
| Back to top |
|
|
magbenji
n00b
Joined: 17 Mar 2004
Posts: 45
Location: I-duh-no, USA
|
| Posted: Wed May 21, 2008 3:38 am Post subject: |
|
|
| Hi, I had this same problem except it was to the tune of 40G! Is there a way to set mysqld to limit the size of these logs? Or do you just have to monitor them and do a RESET MASTER every once in awhile? I didn't see anything in my.cnf that jumped out at me... |
|
| Back to top |
|
|
remix
l33t
Joined: 28 Apr 2004
Posts: 797
Location: hawaii
|
| Posted: Fri Apr 23, 2010 5:18 am Post subject: |
|
|
comment out the log-bin line in my.cnf then restart mysql server
_________________
help the needy |
|
| Back to top |
|
|
|
Other Things Gentoo
