… extent SQL Server handle better. JOIN has long been something MySQL has done badly, people have been ragging on about it… why it has taken several years before we’ve seen MySQL look to actually overhaul the optimizer to start to resolve… performance across the board? With the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB which are either tweaking…
Post: Preventing MySQL Emergencies Webinar
January 24, 2012 By Leave a Comment
… PST, I will present a webinar on preventing MySQL emergencies titled “Preventing Downtime in Production MySQL Servers”. The material I will present is… Percona across many production servers. We analyzed more than 150 emergency cases and categorized our findings to help you learn ways… avoid production downtimes. Join us to learn more about why emergencies happen (it may be different than what you think) and…
Post: White Paper: Preventing MySQL Emergencies
February 7, 2011 By 7 Comments
About a year ago, I started a study of emergency incidents that our customers filed with us. What I found …, and defied conventional wisdom. I learned a lot about preventing emergencies. I just published the outcome as a white paper, including… your own servers. (Analysis of the nature and causes of emergencies is due to be published in the next issue of…
Post: What Causes Downtime in MySQL?
March 21, 2011 By 10 Comments
… just published a new white paper analyzing the causes of emergency incidents filed by our customers. The numbers contradict the urban… companion to my earlier white paper suggesting ways to prevent emergencies in MySQL. It is a re-published and re-edited version… SELECT magazine. You can download it for free from the MySQL white papers page on the Percona web site.
Post: Fixing MySQL with a comment in the config file
February 4, 2011 By 5 Comments
A customer called with an emergency issue: A server that normally runs many MySQL instances wouldn’t start them up. Not only… the first one. The multiple instances were started through the mysql_multi init script. Perhaps you already know what was wrong… on; I just checked a recent download, and the official MySQL distribution contains a file called mysqld_multi (note the different…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max… as though I go work for a while and then emerge with a report, it’s not that way a lot…
Post: Percona Launches New Support Option for MySQL
October 5, 2010 By 9 Comments
… which we have offered top-notch consulting since 2006. Just MySQL, MariaDB, Percona Server with XtraDB, and Percona XtraBackup. Focusing makes… the entire community. MySQL users need better choices. They need immediate access to deep expertise, 24×7, worldwide, with emergency support when necessary…
Post: Meet MySQL Performance Blog guys on MySQL Users Conference
April 14, 2008 By Leave a Comment
… and Maciek is staying to be able to reliably service emergencies arising with our customers. Everyone but Aurimas is speaking on… have: Sphinx: High Performance Full Text Search for MySQL (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb Scalability Limits…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 9, 2011 By 37 Comments
… by MySQL, are broken in various ways. It came up a lot in the research I did on causes of MySQL emergencies. What I would consider to be a good quality init script for MySQL simply isn’t available… that). Debian actually adds quite a lot of changes to MySQL, and many aren’t aware of that. One of my…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
… I’m using sandbox servers on my laptop to illustrate: mysql> select * from heartbeat\G *************************** 1. row *************************** ts: 2011-08-03T18:12…location. That saves me a huge amount of time in emergency situations. To enable this functionality, just drop your heartbeat …
