Installing MySQL 5.6 on Ubuntu 14.04 (Trusty Tahr)

Ubuntu 14.04 defaults to MySQL 5.5, but also has MySQL 5.6 available for installation from the universe archive. Installing 5.6 is as easy as specifying the version, apt-get install mysql-server-5.6: root@ubuntu1404:~# apt-get install mysql-server-5.6 Reading package lists… Done Building dependency tree Reading state information… Done The following extra packages will be installed: libaio1 libdbd-mysql-perl libdbi-perl […]

MySQL 5.6.17 Community Release Notes

Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.17. In particular: Thanks to Anthony Pong for reporting a confusing error message when mysql_install_db could not locate the required Perl modules. Bug #69844. Thanks to Jervin Real for […]

Percona Live Highlights

Last week marked my first April-MySQL-Conf since 2009, and now that I’m back home I wanted to reflect on some of my personal highlights. Photo Credit: @miguel2angel Tomas’ keynote on Wednesday morning was awesome. It felt great to be part of the team at Oracle that announced a release 2x faster than MySQL 5.6 and […]

Configuring MySQL to use minimal memory

I’ve been experimenting with MySQL Fabric – the official tool in development to provide HA and sharding. Part of this experimentation has meant that I have been running 7 copies of the MySQL Server on my laptop at once, which can consume a lot of memory So today I wanted to write about how to […]

Plan to remove unused command line programs (10 out of 43)

Have you ever noticed the vast number of command line programs that ship with MySQL? Here is an ls from MySQL 5.6.16′s bin directory: morgo@Rbook:~/Documents/mysql-installs/5.6.16/bin$ ls innochecksum msql2mysql my_print_defaults myisam_ftdump myisamchk myisamlog myisampack mysql mysql_client_test mysql_client_test_embedded mysql_config mysql_config_editor mysql_convert_table_format mysql_embedded mysql_find_rows mysql_fix_extensions mysql_plugin mysql_secure_installation mysql_setpermission mysql_tzinfo_to_sql mysql_upgrade mysql_waitpid mysql_zap mysqlaccess mysqlaccess.conf mysqladmin mysqlbinlog mysqlbug mysqlcheck […]

A followup on SHOW ENGINE INNODB MUTEX

In November, I wrote about the command SHOW ENGINE INNODB MUTEX and sought feedback as to how it continues to be used post introduction of performance_schema. The outcome from this feedback is that the MySQL team has decided to remove this command from MySQL 5.7. These decisions are not light ones for the team to […]

Optimizing InnoDB Transactions

(This is a cross-post from the Engine Yard blog. The original article appears here.) Here is a question I’ve actually been asked a few times: “I am writing a batch processing script which modifies data as part of an ongoing process that is scheduled by cron. I have the ability to group a number of […]

The MySQL Team is Hiring

As mentioned in my recent MySQL Performance Blog interview, Oracle has a number of vacancies in the MySQL team. By my count, there are 21 current vacancies: IRC2431754Software Developer 4MySQL Server Development (Windows) IRC2433642Software Developer 4MySQL Server Development (Replication) IRC2435607Internet Sales Representative IIMySQL Corporate Sales IRC2437590Software Developer 3MySQL Enterprise Tools IRC2423566Technology Sales Representative IIIMySQL Sales […]