> So, my questions are these: > --------------------------- > > Can any experienced MySQL-FreeBSD admins out there > give me some pointers for identifying bottlenecks?
I have been running MySQl-FreeBSD for over a year now and we are now doing about 140-150,000 page views a day all dynamic from the database. Running top displayed MySQL running about 40% but we kept getting bottle necks and mysql would hang periodicaly. What we have done is recompiled mysql with linuxthreads which made a difference, but what made the biggest difference was upgrading to MySQL 4 and turning on query caching, that what I would recomend. Cheers John Wards SportNetwork.net --------------------------------------------------------------------- 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