On Tuesday 25 Feb 2003 3:27 pm, Juan Enrique Gómez wrote: > I have a very intensive traffic MySQL server, with a average usage of > cpu of 70%, and i think is time to upgrade this machine, my questions > are about will help adding a second processor to this machine?, or mysql > will not take the advantage of this second processor.
What Operating system are you using? Have you made sure you have indexed all your tables correctly? When I developed my first mysql application it was using 70% of the cpu doing about 10,000 page views a day. Is is now doing about 120,000 a day and is running about 20-30% on the same box. I achevied this by adding proper indexes and also using sessions and cookies to store constantly used data. > Upgrading from 3.23.43 (current version) to 4.x version will help?, any > advice will help. Query caching may help 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
