Welcome to WebmasterWorld Guest from 54.162.164.247
Forum Moderators: open
MySQL Optimization
Huge increase in traffic this week, causing MySQL problems.
Full Member
joined:Jan 14, 2006
posts:222
votes: 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?
Senior Member
joined:Jan 7, 2004
posts:929
votes: 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
Join The Conversation
- Register For Free! - Become a Pro Member!
- See forum categories - Enter the Forum
Moderators and Top Contributors
- Moderator List | Top Contributors:This Week, This Month, June, May, Archive, Top 100 All Time, Top Voted Members
Hot Threads This Week
- Google Updates and SERP Changes - July 2017
- July 2017 AdSense Earnings & Observations
- WordPress: Vulnerability Scanners WPScan, WPSeku
- Page layout impacts on speed and indexability
- It's official: Adobe to kill Flash Player, end support by 2020
- Adsense/AMP
- Negative SEO Is Alive and Well
- GSC July 13-14 Decrease in Average Positions is a Reporting Change... Not a Rankings Drop
- Feb 7, 2017 Google Algorithm Update - studies suggest it was Phantom
- What would you do if Google SERPs just disappeared
Featured Threads
- It's official: Adobe to kill Flash Player, end support by 2020
- WordPress: Vulnerability Scanners WPScan, WPSeku
- Google AdSense: No More Pop-Up and Pop Under - New Rule
- GSC July 13-14 Decrease in Average Positions is a Reporting Change... Not a Rankings Drop
- Report: Facebook to Test Subscription News Service
- Google Search App Gets Algorithmic News Feed
- What would you do if Google SERPs just disappeared
- Twitter Adds Advanced Filter Settings With Better Mute Controls
- Most of Your Website Traffic is Not Human
- Google Updates and SERP Changes - July 2017