Skip to content
MySQL DBA for Hire

MySQL DBA for Hire

  • Español

Menu

MySQL DBA for Hire

myisam

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

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

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

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.