…” – actively working web server processes, if you do not have to wait for slow clients. Now you… slow web services. Timeouts. Web services might get slower themselves or network connectivity to them might slow things down…call Web Services. So you might want to cache data on Disk – in files or MySQL …
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…this is way too large – if you’re developing Web application you probably want whole page to be …not get as much battle testing as rest of MySQL Server. Good thing is – you do not have to …SELECT queries but slow down INSERT/UPDATE ones. Final Note: You do not have to have patched MySQL for these …
Comment: Debugging sleeping connections with MySQL
December 1, 2011 By 28 Comments
… queries slowing down our servers – its become quiet frequent now and we are trying to find out why – the problem in tracking down is… tried to use the approach above, however our mysql and web servers are on 2 separate servers – this poses additional problems as we cannot… coming to the mysql server – it will always be the web server. Also when we try the netstat command on the mysql server to see the…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…cron jobs is way to frequent. If slow down happens on the database server or job takes longer to run … function in MySQL. The second one is good if you want to serialize jobs from multiple servers (for … for certain processes – like if you have 50 web servers which run certain cron jobs, but you do …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…to hear complains about MySQL interactive performance – serving simple standard web traffic is drastically impacted …CPU to spare. We’re using Percona Server 5.5.15 for this test with…slows down about 2x. What is going on here ? To understand it we should take a look at the buffer pool contents. mysql…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
… peter. I found the problem of slow down of our site with small load of db server, web server thanks to this article. Timeout setting in httpd.conf do great harm to so many mysql connections in… from our web server, so there are many child processes even if actual traffic is not overloaded. So mysql connection opened in slow HTTP…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
…slow (especially when backup was running) but I do not remember significant downtime, until today we went down…about a week after we moved MySQL Performance Blog to the new server, it stopped responding. I …so I went ahead and returned web site back to old server which happily was still available. …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… expenses but also because of the suffering – slow web site means your marketing budget is wasted, … scale application I’d recommend to looking down to 5 minutes or even 1 minute …less complicated single MySQL server application there is often the question if it is MySQL server causing the problem …
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…load may not be directly related to the web traffic some customer has. The load can also…but just as well it can bring the server down. You can have slow query log enabled and review it …currently fall under Other_commands a few MySQL performance counters broken down by users (full joins, table scans,…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… not to mention understanding all ups and downs of database management system. This sounds nice… also why old products become feature overkill, slow and complicated. I’m not in positions…web servers as well, such as lighttpd. In fact in this area MySQL Cluster, which was always best isolated of MySQL…
