… valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and … by management, and when a server was so overloaded that nobody could get into it if they … over the place. Finally, you can capture TCP traffic. There are several ways to do this with …
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… of the node and do not send new requests to overloaded node as well as use other techniques which keep the… compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles traffic. You may be able to send some traffic to Slaves…
Post: SimCity outages, traffic control and Thread Pool for MySQL
March 16, 2013 By 16 Comments
… me again an analogy with traffic: you have probably at some point encountered “on-ramp metering” solutions, traffic lights that throttle how… MySQL does not improve the performance magically by itself, but it is rather a protection for cases when MySQL may become suddenly overloaded…
Post: How to generate per-database traffic statistics using mk-query-digest
September 16, 2009 By Leave a Comment
… multiple (identical) databases: SHOW DATABASES; +———-+ | Database | +———-+ | db1 | | db2 | | db3 | | db4 | | mysql | +———-+ Separating the data in this manner is a great setup… different physical host when the existing host begins to get overloaded. But MySQL doesn’t allow us to examine statistics on a…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… to be detailed enough. So back to this case… MySQL was getting overloaded with thousands of same queries… which corresponded to cache… much load on MySQL as MySQL load stabilizes increasing number of connections higher until you finally can serve all traffic without problems. So…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
… if actual traffic is not overloaded. So mysql connection opened in slow HTTP connection reaches to wait_timeout and MySQL aborts those mysql connections. There… mysql, optimization because there are so many web sites cheating traffic. Many Chinese web sites does not have real traffic, only cheating alexa traffic…
Post: Cache Miss Storm
September 10, 2010 By 30 Comments
… will attempt to re-create the item pushing server to overload. Now because a lot of requests being proceed in parallel… decode memcached wire traffic. For second you can have instrumentation in your applications or take a look at MySQL Slow queries – which… you’re better wait rather than starting populating it. For MySQL Query Cache the solution should have been to make queries…
