Using mysql_embedded and mysqld --bootstrap to tinker with privilege tables

http://www.skysql.com/blogs/kolbe/using-mysql-embedded-and-mysqld-bootstrap-tinker-privilege-tables

(Read More..)

MYSQL QUERY PATTERNS, OPTIMIZED

https://www.percona.com/live/mysql-conference-2014/sessions/mysql-query-patterns-optimized

(Read More..)

MYSQL BREAK/FIX LAB

http://www.percona.com/live/mysql-conference-2014/sessions/mysql-breakfix-lab

(Read More..)

How to monitor ALTER TABLE progress in MySQL

http://www.mysqlperformanceblog.com/2014/02/26/monitor-alter-table-progress-innodb_file_per_table

(Read More..)

Today’s practical use-case for Performance Schema

http://www.tocker.ca/2014/02/18/todays-practical-use-case-for-performance-schema.html

(Read More..)

Easy HA and automatic failover using MySQL Fabric - Part II

http://mysql-nordic.blogspot.fi/2014/02/easy-ha-and-automatic-failover-using_26.html

(Read More..)

Generating test data for MySQL tables

http://www.mysqlperformanceblog.com/2014/02/10/generating-test-data-mysql-tables

(Read More..)

A quick introduction to innodb_ruby

In On learning InnoDB: A journey to the core I introduced a new library and command-line tool in the innodb_ruby project. Now I’ll show off a few of the things it can do. I won’t try to explain all of the InnoDB structures exposed, since that will get the demos here way off track. We’ll come back to those structures later on!

http://blog.jcole.us/2013/01/03/a-quick-introduction-to-innodb-ruby/

(Read More..)

Exploring MySQL Metadata Lock Instrumentation in Closer Detail

http://www.chriscalender.com/?p=1422

(Read More..)

Filesort optimization in 5.7.3: pack values in the sort buffer

http://mysqlserverteam.com/filesort-optimization-in-5-7-3-pack-values-in-the-sort-buffer/

(Read More..)

Migration of MTR suites to use InnoDB (2)

http://mysqlserverteam.com/migration-of-mtr-suites-to-use-innodb-continued/

(Read More..)

Migration of MTR suites to use Innodb (1)

http://mysqlserverteam.com/migration-of-mtr-suites-to-use-innodb/

(Read More..)

Cleanup a MySQL Schema

http://blog.mclaughlinsoftware.com/2014/02/07/cleanup-a-mysql-schema/

(Read More..)

A simple rule for sane timestamps in MySQL

http://www.xaprb.com/blog/2014/01/30/timestamps-in-mysql/

(Read More..)

MySQL server memory usage troubleshooting tips

http://www.mysqlperformanceblog.com/2014/01/24/mysql-server-memory-usage-2

(Read More..)

Analyzing WordPress MySQL queries with Query Analytics

http://www.mysqlperformanceblog.com/2014/01/16/analyzing-wordpress-mysql-queries-query-analytics/

(Read More..)

The "test" Database and Security

https://blogs.oracle.com/jsmyth/entry/the_test_database

(Read More..)

A Close Encounter with MaxScale

http://izoratti.blogspot.com/2014/01/a-close-encounter-with-maxscale.html

(Read More..)

How to recover table structure from .frm files with MySQL Utilities

http://www.mysqlperformanceblog.com/2014/01/02/recover-table-structure-frm-files-mysql-utilities/

(Read More..)

Multiple column index vs multiple indexes with MySQL 5.6

http://www.mysqlperformanceblog.com/2014/01/03/multiple-column-index-vs-multiple-indexes-with-mysql-56/

(Read More..)