In the last episode (Aug 20), Kayra Otaner said:
> I want to get your opinions on how to increase available/free memory and
> performance on a heavy volume database server.
> I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using
> same MySQL version.
> Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap
> space) started to suffer from memory outages because of heavy load.
> During day available free memory is changing from 200Mb to 5Mb and when
> available memory reaches to 5Mb MySQL starts to give 'Too many
> connections' messages. Db server is working with 45-70 query/second and
I don't think those two are related. After an hour of operation, it's
expected to have zero "Free" memory; unix uses unused memory as disk
cache, so Free memory is wasted memory. More important questions are:
Are you swapping? and What is the current memory usage of mysql?