Sometime recently Henrik Leghissa said: > At 16:21 2003-06-24, gerald_clark wrote: > >Linux shows threads. > >BSD shows processes. > > > >The difference is in the way ps runs, not mysqld. > > *doh* I guess the sun got to me, sorry mate! :-) > > But do you have any good ways to get the database to run any faster? I am > running it on a really beat up piece of junk (p200 with 98MB in ram, don't > tell me to get new hardware - 'cause I will! hehe) and would like some > hands on settings in the cnf-file from you if possible.
Well, in the Managing MySQL course run by MySQL AB; they taught us that upgrading hardware is the *last* thing you do to get the database to run faster, not the first. Before you buy new hardware you should: -Optimize your queries -Make sure you're using the right Indices -Use MyISAM table locking if appropriate -Look at your logical database structure -Look at your physical database structure -Set your MySQL server memory parameters appropriately -Optimize your OS for MySQL Info on all of these is available at: http://www.mysql.com/doc/en/MySQL_Optimisation.html When you've got some more specific questions, we'll be happy to help :) Jan -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.ingentaselect.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
