Mysql eats up way too much ram!

jackie46

BANNED
Jul 25, 2005
537
0
166
Whats up with MySQL? We have an optimised my.cnf on the server which has a total of 2gigs of ram.

When i run top the available memory FREE is between 29M and 40M. If i restart MySQL the available ram jumps back to over 1,000M and stays there for a day. Then next day, its back to 29M - 40M. MySQL is hogging too much RAM for no reason. Whats up with this?
 

jackie46

BANNED
Jul 25, 2005
537
0
166
Ye I also wondering why my mysql % has gone up so much in the past couple of weeks. From 3% to 5% then i find all these files in /var/lib/mysql

-rw-rw---- 1 mysql mysql 42001044 Jun 7 02:24 orion-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 7 02:24 orion-bin.000002
-rw-rw---- 1 mysql mysql 12033 Jun 7 02:45 orion-bin.000003
-rw-rw---- 1 mysql mysql 8062184 Jun 8 02:43 orion-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 8 02:48 orion-bin.000005
-rw-rw---- 1 mysql mysql 16014 Jun 8 03:34 orion-bin.000006
-rw-rw---- 1 mysql mysql 1775 Jun 8 03:42 orion-bin.000007
-rw-rw---- 1 mysql mysql 1775 Jun 8 03:53 orion-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 8 03:54 orion-bin.000009
-rw-rw---- 1 mysql mysql 602553 Jun 8 14:20 orion-bin.000010
-rw-rw---- 1 mysql mysql 16231 Jun 8 15:08 orion-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 8 15:09 orion-bin.000012
-rw-rw---- 1 mysql mysql 6207741 Jun 9 01:15 orion-bin.000013
-rw-rw---- 1 mysql mysql 79 Jun 9 01:16 orion-bin.000014
-rw-rw---- 1 mysql mysql 68038 Jun 9 01:54 orion-bin.000015
-rw-rw---- 1 mysql mysql 79 Jun 9 01:58 orion-bin.000016
-rw-rw---- 1 mysql mysql 9877 Jun 9 02:18 orion-bin.000017
-rw-rw---- 1 mysql mysql 79 Jun 9 02:23 orion-bin.000018
-rw-rw---- 1 mysql mysql 9542 Jun 9 02:55 orion-bin.000019
-rw-rw---- 1 mysql mysql 79 Jun 9 02:58 orion-bin.000020
-rw-rw---- 1 mysql mysql 8421494 Jun 9 22:45 orion-bin.000021
-rw-rw---- 1 mysql mysql 13495663 Jun 11 22:42 orion-bin.000022
-rw-rw---- 1 mysql mysql 2997078 Jun 12 12:09 orion-bin.000023
-rw-rw---- 1 mysql mysql 3208 Jun 12 12:15 orion-bin.000024
-rw-rw---- 1 mysql mysql 79 Jun 12 12:15 orion-bin.000025
-rw-rw---- 1 mysql mysql 3208 Jun 12 12:20 orion-bin.000026
-rw-rw---- 1 mysql mysql 18733822 Jun 14 01:03 orion-bin.000027
-rw-rw---- 1 mysql mysql 3208 Jun 14 01:09 orion-bin.000028
-rw-rw---- 1 mysql mysql 79 Jun 14 01:09 orion-bin.000029
-rw-rw---- 1 mysql mysql 3208 Jun 14 01:11 orion-bin.000030
-rw-rw---- 1 mysql mysql 79 Jun 14 01:11 orion-bin.000031
-rw-rw---- 1 mysql mysql 22412640 Jun 15 23:02 orion-bin.000032

GASP!
 

jackie46

BANNED
Jul 25, 2005
537
0
166
On my Freebsd boxes i remove MySQL 4.1.19 due to all the dumps above. Something is not right.

I'v reverted back to 4.1.10a which never exhibited any problems.

Whats a girl to do????
 

chirpy

Well-Known Member
Verifed Vendor
Jun 15, 2002
13,465
30
473
Go on, have a guess
Those files are the binary log files. You should make sure that you comment out log-bin in /etc/my.cnf, restart MySQL and you can then remove them.

The amount of Free memory on a Linux/BDS server isn't particularly relevant. The important figure is the amount of memory available by combining free memory with cached memory.