Matthew, Without any more information, I would put money on this being either a database design issue or a query design issue. I really expect that database optimization would buy you a lot of performance.
But without knowing what kind of database structure you have, what kind of queries you run, what kind of optimization you have done, what you consider to be a LOT of traffic, what kind of server settings you are using and what kind of hardware you run on -- I really can't say much more than that. Tom Haapanen [EMAIL PROTECTED] -----Original Message----- From: Matthew Hale [mailto:[EMAIL PROTECTED]] Sent: 29 December 2001 00:15 To: [EMAIL PROTECTED] Subject: mySQL Issues I run a site that gets a LOT of traffic and uses mySQL. But for some reason, mySQL is making MAJOR load on my server. I have tried it on several servers, and they all end up with load averages like 10+! We have optimized our code as much as possible and STILL are getting super high loads! Is there ANYWAY to optimize mySQL so it doesn't run soooo much load?? Sincerely, Matthew Hale Get paid cash every time you receive email! Sign up FREE at: http://www.MintMail.com/?m=1825549 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
