Skip to content
MySQL DBA for Hire

MySQL DBA for Hire

  • Español

Menu

MySQL DBA for Hire

5.6

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)

Throughput result comparison, in rows inserted/second, for the LOAD data test with default configuration

I’ve been lately compiling and generating .deb packages for several MySQL and MariaDB recent versions, and I wanted to try them more in depth -specially MySQL 8.0 and MariaDB 10.2, both of which are still in development. Several people have

Jaime Crespo 2016-12-062019-08-27 mysql Read more

Regarding MySQL 5.6 temporary tables format

A temporary table

default_tmp_storage_engine variable was introduced in 5.6.3, allowing the configuration of the default engine for temporary tables. This seems to be in the direction, as I commented before, of making MyISAM an optional engine. In 5.7, a separate tablespace is being

Jaime Crespo 2015-02-242019-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

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

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

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.