… a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel… concurrency in most cases is seen when the system is overloaded and suffering. So what is the problem with looking at…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… activities are overloading the system causing user experience to degrade. The first thing you need to know it is not MySQL problem… typically need to reduce concurrency to where it does not overload the system. Unless it is really time critical process I… heavily writing to database. Introduce Throttling Sometimes even single process overloads system too much in this case throttling by having relatively…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… responding very well but the server is abusing them and overloading them. And sometimes, of course, the CPUs and disks have… finish these, I’ll post them on Percona.TV, our MySQL video/screencast blog site. Another interesting topic is how to…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the… was forbidden by management, and when a server was so overloaded that nobody could get into it if they wanted to… mk-query-digest’s built-in ability to decode the MySQL wire protocol, it is certainly the easiest and best solution…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… unavailable plus in many cases you can use result overload to make MySQL to consume so much memory so it will swap…. General Overload As MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely… of the worse because they would both overload IO system and wipe off both MySQL and OS caches which can cause other…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…_BIN_LOG=0 before you run ALTER TABLE query. Replication Overload Many tutorials out where will give you impression problem with… slave. So watch your replication and see if it getting overloaded. Typically you will see it as increased lag spikes as… helpful to examine execution time of queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… and the box is overloaded and “goes down”. As we fail over another server goes down with overload the same way. This… is a good approach for larger scale systems. Interested in MySQL and High Availability ? Come to Percona Live NYC taking place… the art high availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as well as…
Post: What do we optimize with mk-query-digest ?
December 15, 2009 By 2 Comments
… can see which are unrelated to query itself – general system overload, row level locks, table locks all could cause query response… it is often fine, assuming it is not causing system overload, interactive queries, which have real users waiting for them are…) – it is however perfectly possible to get bad performance with MySQL responsible for large portion of response time without any slow…
Post: SimCity outages, traffic control and Thread Pool for MySQL
March 16, 2013 By 16 Comments
… a few examples of how Thread Pool for MySQL and Percona Server for MySQL can help to prevent such incidents. Users of… by limiting the amount of working threads inside MySQL. So Thread Pool for MySQL does not improve the performance magically by itself, but it is rather a protection for cases when MySQL may become suddenly overloaded…
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… and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node… talks about Percona XtraDB Cluster, Synchronous Replication and Galera Technology, MySQL Cluster production use, and Keynote and Talk about Clustrix – another…
