Skip to content
MySQL DBA for Hire

MySQL DBA for Hire

  • Español

Menu

MySQL DBA for Hire

5.7

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

Personal Summary of the Percona Live Amsterdam 2015 Conference

Personal Summary of the Percona Live Amsterdam 2015 Conference

Last week, 21-23 September, it took place the European MySQL Conference, or “Data performance Conference” as this year’s subtitle was “MySQL. NoSQL. Data in the cloud.”. This year, it changed its location from London to Amsterdam and, as most people

Jaime Crespo 2015-09-272019-11-27 mysql, wikipedia 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

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

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.