homepage Welcome to WebmasterWorld Guest from 23.22.173.58
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

This 31 message thread spans 2 pages: < < 31 ( 1 [2]     
MySQL Optimization
Huge increase in traffic this week, causing MySQL problems.
Jordo needs a drink

5+ Year Member



 
Msg#: 3153256 posted 2:40 am on Nov 11, 2006 (gmt 0)

One of my sites this week has all of a sudden seen a huge(relatively speaking) increase in traffic this week. I guess Google decided it liked us.

The problem is, the server has gone down twice. Each time, MySQL was probably the cause due to extremely high CPU usage. My stats won't even run because of the cpu load, so I can't even tell how much traffic I'm really getting.

The server is a linux based pentium 4 2.8ghz. I can upgrade, but pretty sure, I just need to do some db optimization.

My question is, where do I start? Is there a MySQL optimization checklist I could start going through? If not, can y'all post some suggestions?

 

tomda

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3153256 posted 5:35 am on Dec 4, 2006 (gmt 0)

One tool is mentionned in the documentation above
One tool that I am aware with is the MySQL Slow Log Parser, written in Perl by Nathanial Hendler.

Again, the doc is old (written in 2003) so I am sure there are more tools available

This 31 message thread spans 2 pages: < < 31 ( 1 [2]
Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved