Most serious users of MySQL have moved their tables to InnoDB years ago. For those who haven't, let's discuss why InnoDB is a more scalable solution than MyISAM. MyISAM was...
I was sincerely affected by this last MySQL post and this other very long post from Jeremy Cole . Yes, these two guys are MySQL rock stars and they are really...
After taking this MySQL for Database Administrators course , you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded...
I've already shared my presentation few hours before I made it during PLMCE 2013 , back on April 24. Let's just have it here for the reference:...
This Friday, May 31 at 10 a.m. Pacific, I ll present Percona s next webinar, SQL Query Patterns,...
Next Friday, May 31 at 10 a.m. Pacific, I ll present Percona s next webinar, SQL Query Patterns, Optimized . Based on my experiences solving tough SQL problems for Percona...
Interested in an introduction to using Performance Schema to profile statement activity on your MySQL instances? Head on over to Detailed Profiling of SQL Activity in MySQL...
While I prepared for my Hands-On Lab about the Performance Schema at MySQL Connect last year, one of the things that occurred to me was how difficult it was quickly getting an...
I was playing around with MySQL 5.7 this weekend and before having read the changelog , I managed to spot these two little gems. Duplicate Indexes The server now issues a...
Everybody seems to be looking at and debating NoSQL these days, and so am I and I thought I'd say a few words about it. Which is not to say I haven't said stuff before, bit...
343 revisions after the 7.0 release follows the new 8.0 release of HeidiSQL now. Get it from the download page . Here are the most noticable changes: - Available in 23...
I used a simple workload with sysbench to determine the rate at which InnoDB can read blocks from disk. The workload is read-only and each query fetches 1 row by PK. The...
Early this year Oracle released MySQL 5.6 - Best MySQL Release Ever . This release delivered not only quality, but also quantity in terms of number of features. See a...
Now that I'm back doing just database stuff, I've come to realize I've gotten a little sloppy about doing my homework. Â Homework's never been my favorite thing in the world,...
Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 17, 2013. Downloads are available from our download site here and Percona Software...
More from News & Blogs