As I mentioned on my last post, where I compared the default configurations options in 5.6 and 5.7, I have been doing some testing for a particular load in several versions of MySQL. What I have been checking is different
Today is the day in which MyISAM is no longer needed
Of course, this is just a catchy title. As far as I know not all system tables can be converted to InnoDB yet (e.g. grant tables), which makes the header technically false. MyISAM is a very simple engine, and that
Changes in Configuration of Global Variables between MySQL 5.6.20 and MySQL 5.7.4 “Milestone 14”
While doing some testing (that I published later here) on the still-in-development MySQL 5.7 I wanted to do some analysis on the configuration to see if the changes in performance were due to the code changes or just to the
Which Compression Tool Should I Use for my Database Backups? (Part II: Decompression)
On my post last week, I analysed some of the most common compression tools and formats, and its compression speed and ratio. While that could give us a good idea of the performance of those tools, the analysis would be
Which Compression Tool Should I Use for my Database Backups? (Part I: Compression)
This week we are talking about size, which is a subject that should matter to any system administrator in charge of the backup system of any project, and in particular database backups. I sometimes get questions about what should be
How to install MySQL 5.6 on CentOS 7
A bit of history The latest version of Red Hat Enterprise Linux, one of the most popular and respected Linux distributions in the server market, was released in June 2014, followed by CentOS 7 and Oracle Linux releases in July