This problems are making me a bit tired, forgot to give you information about the systems.
MySQL-3.23.52 dual pentium 700, 800MB ram RedHat 6.1 Kernel 2.2.19-6.2.1smp glibc-2.1.3-27 MySQL-3.23.52-Max dual pentium 1.4Ghz, 2 GB ram Redhat 7.3 Kernel 2.4.18-10smp glibc-2.2.5-40 regards /Lars On Wed, 16 Oct 2002, Lars Andersson wrote: > I'm managing two database servers, one 3.23.52 and one 3.23.52-Max > (using innodb tables on that one). > > They are both running along fine until they suddently start to > accumulate a lot of treads (a lot ~= 200-300), the state of these > threads is mostly "closing" and "opening" tables. This drives up the > load to amazing numbers and I'm forced to shut the mysql-server down. > > Since I'm running these servers in a shared environment I got a lot of > users using these servers, and so far I haven't got any grip on whats > causing these problems. I got these problems on both servers (one with > max and one without), both servers got diffrent users. > > I've ruled out hardware problems since I get exactly the same behaviour > on two independent servers. > > It would be great if sombody knows the answer to my questions bellow: > - is there any know problems with mysql on linux? or with 3.23.52 that > should cause this behaviour > > - what should I do to find the error, my logs shows nothing pecuilar. > I'm currently dumping a processlist each five seconds to a file. > > > regards > /Lars > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php