On Sat, May 01, 2004 at 09:50:14PM -0700, Max Clark wrote: > 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?
When you say "load" there, what exactly do you mean? How many concurrent threads are running? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]