Here are two videos by Steve Souders, former chief performance Yahoo, currently at Google. He determined that 95% of the wait on loading the Yahoo page is after the initial apache response is sent to the browser. Doing more research he determined that this is about a 80/20 rule on most popular web sites. It [...]
Tags:
It’s a bit of a long title for a blog post but the point I want to make is that not every query optimization is aimed at making the query faster. As a case in point we have a client that has a web shop and their network traffic between the web servers and the [...]
Tags: Cyber Monday·MySQL·optimization·traffic
We encountered a situation recently where the number of connections to our MySQL database started creeping up slowly but steadily. Strangely enough all the connections were in sleep mode and the database was not being stressed. The number of connections first reached 30 where it normally stays below 20 and started triggering our monitoring scripts. [...]
By special request here is a post about the MySQL slow query log. MySQL has a wonderful feature that lets you keep track of all queries that took longer than a certain time to complete. To enable it simply add the following line to your my.cnf file: log-slow-queries = [path to the log file] Secondly [...]
Tags: MySQL·slow query log·tuning
