On Tue, Feb 03, 2004 at 11:28:00PM +0000, Mike Williams wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Tuesday 03 February 2004 23:25, Alan wrote: > > Hi guys... still in the middle of getting a server cut over from debian > > to gentoo and I just found some serious performance problems with mysql. > > > > My new hardware is a dual p3 1.13Ghz system with 2G of ECC ram running > > kernel 2.6.1 (gentoo-dev-sources) with preempt compiled. > > I stopped reading here. > Get rid of preempt, it's only useful on a desktop and makes a right mess of a > server.
Hi Mike. I thought of that just after I posted. However, moving to gss-sources (2.4.25_pre6) with no preempt enabled and the same result. Top shows the following while the stat is running: top - 15:57:35 up 12 min, 2 users, load average: 1.97, 0.53, 0.18 Tasks: 96 total, 7 running, 89 sleeping, 0 stopped, 0 zombie Cpu0 : 71.1% user, 28.9% system, 0.0% nice, 0.0% idle Cpu1 : 73.1% user, 26.9% system, 0.0% nice, 0.0% idle Mem: 2069524k total, 582020k used, 1487504k free, 3936k buffers Swap: 1494012k total, 0k used, 1494012k free, 459904k cached And on the debian box: top - 16:01:39 up 13:38, 6 users, load average: 8.69, 3.39, 2.20 Tasks: 320 total, 6 running, 308 sleeping, 2 stopped, 4 zombie Cpu0 : 25.6% user, 8.3% system, 2.5% nice, 63.6% idle Mem: 1033384k total, 1007244k used, 26140k free, 10176k buffers Swap: 999920k total, 126116k used, 873804k free, 613216k cached This is about the same as under 2.6 with prempt, with lots of system resources (not just user). My 2.4 .config is at http://arcterex.net/stuff/kernel24-config if that helps at all. -- Alan <[EMAIL PROTECTED]> - http://arcterex.net -------------------------------------------------------------------- "There are only 3 real sports: bull-fighting, car racing and mountain climbing. All the others are mere games." -- Hemingway -- [EMAIL PROTECTED] mailing list
