Preparing Optimizing MySQL Configuration talk for Percona Live in Washington,DC I noticed how many Variables did MySQL get over years – it is pushing 400 these days even if we do not count variables/options which do not have matching SHOW VARIABLES value, and settings done by changing tables rather than command line options (like much of Performance Schema configuration). Innodb settings alone push 100.
I got a question a while ago about how Percona Server handles corrupted data more gracefully than the standard MySQL server from Oracle. The short version is that it won’t crash the whole server.
One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during peak times. This is a high number by any account.
In my opinion, The Server Option and Variable Reference at http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html rates as my most important page. This is a consolidated index that enables a drill down to the Server Command Options, System Variables, Startup and replication specifics, as well as important information on default values and differences between versions including point releases.
I am working on a presentation for the San Francisco MySQL Users Group on using EXPLAIN and EXPLAIN EXTENDED. But I need some help from the MySQL Community. Do you have any good examples of EXPLAIN EXTENDED providing unexpected results when compared to the original query? Please post your statement and possibly a SHOW CREATE TABLE below or send them to david.stokes AT Oracle.
I’ve created a Central Virginia MySQL Meetup group for those of you in the area. Our first event will be in a couple of weeks at Meddius’s headquarters. I’d like to meet and get to know more people in this area who use MySQL, so come out and we’ll have a good time together! Oh, and beer. And pizza. Of course.
In just over a week, we’ll be running a Percona Live MySQL conference in the nation’s capital, in a beautiful modern conference facility that has its own Metro rail stop. And for a limited time, you can save 20% with this discount code: PerLiveDC.
If you’re in the DC area and you use MySQL, this is the event you shouldn’t miss. Here’s what you’ll see: