Skip to content
MySQL DBA for Hire

MySQL DBA for Hire

  • Español

Menu

MySQL DBA for Hire

Author: Jaime Crespo

My Talk at PyConES 2014 Zaragoza about MySQL Fabric

My Talk at PyConES 2014 Zaragoza about MySQL Fabric

Next Saturday, 8 November 2014, at 19:30 I will be speaking about MySQL Fabric for PyConES 2014 (the Spanish version of the PyCon), the annual meeting point for all developers and enthusiasts of Python in Spain. While I say myself

Jaime Crespo 2014-11-062019-08-27 mysql Read more

My Tutorial on Query Optimization for Percona Live London 2014 (and Important Information If You Wish to Attend)

Percona Live London is next week!

Monday next week, on November 3rd, I will be delivering a tutorial on the greatest MySQL European Conference, the Percona Live London 2014. The topic is a natural continuation of the one I delivered last year on the same venue,

Jaime Crespo 2014-10-292019-08-27 mysql Read more

Testing the Fastest Way to Import a Table into MySQL (and some interesting 5.7 performance results)

load_data_04.py results for innodb optimized

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

Jaime Crespo 2014-10-082019-08-27 mysql Read more

Today is the day in which MyISAM is no longer needed

RIP MyISAM

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

Jaime Crespo 2014-09-262019-08-27 mysql Read more

Changes in Configuration of Global Variables between MySQL 5.6.20 and MySQL 5.7.4 “Milestone 14”

MySQL Upgrade from 5.6 to 5.7

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

Jaime Crespo 2014-08-272019-08-27 mysql Read more

Which Compression Tool Should I Use for my Database Backups? (Part II: Decompression)

Analysis of different compression tools: Compression ratio vs decompression speed

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

Jaime Crespo 2014-08-192019-08-27 mysql Read more

Which Compression Tool Should I Use for my Database Backups? (Part I: Compression)

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

Jaime Crespo 2014-08-112019-08-27 mysql Read more

How to install MySQL 5.6 on CentOS 7

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

Jaime Crespo 2014-07-282019-08-27 mysql Read more
  • Next »

Recent Posts

  • MySQL 8.0 new features in real life applications: roles and recursive CTEs
  • Finding out the MySQL performance regression due to kernel mitigation for Meltdown CPU vulnerability
  • How to install MySQL Server on Debian Stretch
  • Testing (again) LOAD DATA on MySQL 5.6, 5.7, 8.0 (non-GA) and MariaDB 10.0, 10.1 and 10.2 (non-GA)
  • Personal Summary of the Percona Live Amsterdam 2015 Conference

Recent Comments

  • Jaime Crespo on How to install MySQL Server on Debian Stretch
  • SoliaK on How to install MySQL Server on Debian Stretch
  • Ed Valdez on How to install MySQL Server on Debian Stretch
  • Ed Valdez on How to install MySQL Server on Debian Stretch
  • Josue ฏ๎๎๎๎๎๎๎๎๎๎๎๎ on How to install MySQL Server on Debian Stretch

Categories

  • business
  • mysql
  • wikipedia

Archives

  • February 2018
  • January 2018
  • June 2017
  • December 2016
  • September 2015
  • April 2015
  • March 2015
  • February 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
DBAHire no es un producto comercial ni se ejerce ninguna actividad económica en este sito web.