Hi all,
I have a db that is connection heavy running on FreeBSD 4.9. The server was compiled with Linux Threads enabled.
I am searching for performance tuning information. Outside of enabling Linux Threads I haven't been able to find much else. I am under the impression that I should be using innodb tables instead of myisam, and I am sure there are a slew of other things that I could tune. Is there a site/document dedicated to this? My copy of high performany mysql by Jeremy Zawodny is in the mail, so any help in the mean time would be greatly appreciated.
I am getting "cannot create new thread" errors on my system when load gets extremely heavy, are there any additional things I can do to help this? Would FreeBSD 5.1 be any better?
Thanks in advance, -Max
Max,
From my experience MyISAM tables are faster for Selects, and InnoDb is faster for many simultaneous updates/inserts from various users. Single user updates are faster for MyISAM.
For tuning into have you tried:
http://www.google.ca/search?q=mysql+performance+tuning&ie=UTF-8&oe=UTF-8&hl=en&btnG=Google+Search&meta= or
http://dev.mysql.com/doc/mysql/en/InnoDB_tuning.html
http://www.linux-mag.com/2001-06/mysql_01.html
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
