List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 21 2003 1:48am
Subject:Re: MySQL 4.0.13 Memory problem under heavy load
View as plain text  
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?

-- 
	Dan Nelson
	dnelson@stripped
Thread
Need help optimizing query, awfully slow on only 20000 recordsCarmel Entertainment)19 Aug
  • RE: Need help optimizing query, awfully slow on only 20000 recordsJim Smith20 Aug
RE: Need help optimizing query, awfully slow on only 20000 recordsCarmel Entertainment)20 Aug
  • RE: Need help optimizing query, awfully slow on only 20000 recordsMichael S. Fischer21 Aug
RE: Need help optimizing query, awfully slow on only 20000 recordsCarmel Entertainment)21 Aug
  • RE: Need help optimizing query, awfully slow on only 20000 recordsMichael S. Fischer21 Aug
  • Seeking advice on best table structureScott Haneda21 Aug
    • Re: Seeking advice on best table structurePete McNeil21 Aug
    • Re: Seeking advice on best table structureRoger Baklund21 Aug
      • Re: Seeking advice on best table structureRajesh Kumar21 Aug
        • Re: Seeking advice on best table structureRoger Baklund21 Aug
Re: Need help optimizing query, awfully slow on only 20000 recordsCarmel Entertainment)21 Aug
RE: Need help optimizing query, awfully slow on only 20000 recordsCarmel Entertainment)21 Aug
  • MySQL 4.0.13 Memory problem under heavy loadKayra Otaner21 Aug
    • RE: MySQL 4.0.13 Memory problem under heavy loadMichael S. Fischer21 Aug
    • Re: MySQL 4.0.13 Memory problem under heavy loadDan Nelson21 Aug
  • Re: MySQL 4.0.13 Memory problem under heavy loadMartin Gainty21 Aug