…” – 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 84 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 30 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: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… can start writing to them you experience down time. This means the risk with automated … (SQL nodes for MySQL Cluster) in the same way as you work with web servers – any of …MySQL Replication is handled by cluster internally – for example if timeouts are reconfigured the transient network slowness…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… tables | 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | …some really hot tables, for example in web applications its typical to see a “sessions…up waiting for table metadata lock bringing down the MySQL server or causing all the connections to…
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 …
