Loaded MySQL 4.0.18 w/ KSE running nicely
Thomas Hurst
tom.hurst at clara.net
Sun Mar 21 20:53:42 PST 2004
Just thought I'd make a little note to let people know that we're
successfully running MySQL 4.0.18 on 5.2.1-RELEASE-p3 dated Mar 18 using
libkse, after having raised thread limits to 500 per proc/150 per group:
Uptime: 233816
Threads: 45
Questions: 33388272
Slow queries: 597
Opens: 2725
Flush tables: 1
Open tables: 429
Queries per second avg: 142.797
This is running on 2*1266MHz Pentium III's with 4GB of memory, although
MySQL is "only" using about 1GB of it. Main issue we've noticed is top
shows the main process as using 0.00% CPU; ps does too, but setting it
to display threads works as expected.
We did try -CURRENT dated around the same time, but we were plagued with
MySQL lockups and such even using linuxthreads, which we've ran for over
a year fine on 4-STABLE, MySQL bugs notwithstanding.
We're open to suggestions for improving performance and happy to test
things (within reason.. this is a production server ;)
fwiw imho omfg wp gg np gtg k pls tnx lol! Ahem.
--
Thomas 'Freaky' Hurst - newzBin Developer & Admin - freaky at newzbin.com
More information about the freebsd-current
mailing list