Better performance is important in everything, not just MySQL. I don’t want to wait for my text editor to open a file or perform syntax highlighting. I don’t want to wait for my version control system to compute diffs or update my copy of the code with other peoples’ changes. I don’t want to wait for my code to compile. I don’t want to wait, period.
VISUAL EXPLAIN will be come a standard tool in your DBA toolbox but you will need later versions of both MySQL Workbench and MySQL Server. The examples here were created with Workbench 5.2.44 and MySQL 5.6.8, the latest Release Candidate of MySQL 5.6. And both are available for free from http://Dev.MySQL.Com.
Last time I took this query
SELECT City.Name, Country.Name
JOIN Country on (City.CountryCode=Country.Code)
My previous poll got a great response so I thought I should continue these series.
The question of the day today is How much data do your store in your largest MySQL instance ? I’m interested about single instance not the total amount of data you have in MySQL in your Sharded replicated environment. Feel free to share details in comments – are you using MyISAM or Innodb ? Is it working out well for you or are there any challenges you’re seeing ?
I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA. Personally, I’ve been attending this conference for 6 or 7 years and missing it only when my wife was pregnant with a due date in April (we have two children with April birthdays).
This is due to Oracle's policy for security-related bugs. Tomas Ulin, Vice President MySQL Development at Oracle , was kind enough to discuss Oracle's policy with me, and these are the key points as I understand them:
The Internet Summit seems to be the largest Tech event of the year in Raleigh,NC area. I’ve attended this conference last year and I’m proud to be a speaker this time around. If you’re up for early morning talks I’m part of “Tech Track: Inside the Data Center” block of sessions, starting at 8am, where I will talk about challenges of using MySQL in the data center.