Date: Mon, 22 Mar 2004 04:53:40 +0000 From: Thomas Hurst <tom.hurst@clara.net> To: current@freebsd.org Subject: Loaded MySQL 4.0.18 w/ KSE running nicely Message-ID: <20040322045339.GA43881@voi.aagh.net>
next in thread | raw e-mail | index | archive | help
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@newzbin.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040322045339.GA43881>