…I worked for Monty at the time. Bernd Ocklin from MySQL Cluster team was able to fly home via Iceland – …airport in Europe that was not closed. He took a nice picture flying only a few km from the culprit: …/2010/04/around-volcano-and-home-from-us-in-20.html Personally I got home via Mexico City and …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… lot of updates can also be the problem. It is nice to analyze your replication traffic regularly with mk-query-digest…-20% difference in data size can be the difference between slave never lags and slave never is able to catch up. MySQL…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…problem happens, it spikes up into the range of 20 or higher. A safe trigger might be 15, …tool that Linux doesn’t have] better? What’s nice about collect is that it gathers many different types… are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over…
Post: Win free MySQL Conference Passes!
April 7, 2011 By 31 Comments
…to the O’Reilly MySQL Conference next week in Santa Clara, California? It’s the MySQL conference, and the …serious about committing to go — it would not be nice to claim a ticket and deny someone else …see us there, in booth #312! There’s a 20% discount code here: https://en.oreilly.com/mysql2011/…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1…, 8:1 compared to raw input data), which is quite nice. Each shard contains only 128MB of data! Storage engine makes…-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20 nodes for…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 11 Comments
I already wrote about some MySQL Error Messages which are confusing, here is one more: 080603 20:53:10 [Note] Slave: connected…, reconnecting to retry, log ‘master-bin.003676′ position 444292333 080603 20:53:10 [Note] Slave: connected to master ‘repl@host.com… very least it would be nice to include possible reason for this error message which MySQL already does in many other cases…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…run. Anything else is gravy. If there are nice-to-haves, consider not building them in. Listen …optimizing the short head. It’s the classic 80-20 rule. Maybe 80% of your ad impressions are …save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing …
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…ALTER statements for removing unused indexes, which is nice, but it’s often helpful to ask … used a variation on MySQL Sandbox to set up a little throw-away MySQL instance — that took ten …i_c,fud26_forum_i_lpi | 6095451542512376951,11680437198542055892 | 20 | | mpb_forum.fud26_msg.fud26_msg_i_ta …
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… enable slow logging with –slow-query-log parameter. MySQL 5.1 has this nice feature which allows you to redirect query log… general log now) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will not work… by the slave thread. This can be achieved by running MySQL with startup time parameter –log-slow-slave-statements. Please note…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably… of handling SELECT traffic, these same queries were responding nicely on the passive master, too. Is that all? “Buffer…09 6.29 site.user_achievements 1.36 1.20 0.35 site.clicks 1.26 3.05 5…
