May 26, 2012

Post: Three ways to know when a MySQL slave is about to start lagging

… you tell when your slave is nearing its capacity to keep up with the master? Here are three ways: One: watch for spikes of lag. If you have Cacti (and these Cacti templates for MySQL) you can see this in the graphs. If the graphs start to get a

Post: High-Performance Click Analysis with MySQL

lag badly.  More about this later. Another way to say “aggregate” is to say “pre-compute.” If you have time-critical queries for your app toabout partitioning in MySQL 5.1?  I know there are some cases when it can help a