(kolbe) The much-anticipated, long-awaited, and possibly irrelevant (Sphinx? Lucene?) InnoDB Fulltext finally makes a semi-official appearance in MySQL 5.6.4! MySQL 5.6.4, release December 20, 2011, is the newest “development milestone release” (“DMR”) of MySQL 5.6.
Tag: Open Source
Optimizer Tracing
(Dave Stokes) A a new tracing capability has been added to the MySQL optimizer with 5.6.3. Optimizer Tracing goes beyond EXPLAIN EXTENDED to show how the optimizer treats queries. The demonstration of this feature at Oracle Open World had several noted DBAs speechless.
Hijacking Innodb Foreign Keys
(Peter Zaitsev) I guess I’m first to post in 2012 so Happy New Year all blog readers!
A 3-way join that touches only indexes
(Igor) Can an execution of 3-way join use only indexes and not touch table rows at all? If we have MyISAM tables it’s just impossible. Yet with InnoDB tables it would be possible if we could exploit so called extended keys – the regular secondary keys extended by the components of the primary key.
How To Test Your Upgrades – pt-upgrade
(Jervin Real) Upgrades are usually one of the biggest part of any database infrastructure maintenance. Even with enough planning something else can go bad after sending your production application to the version you’ve upgraded to.
Revoke Statement in MySQL
(Alejandro Gervasio) In this article I show you how to work with the REVOKE MySQL statement. It can be used for removing the privileges assigned via its counterpart GRANT, in either the global, database or table scope.
Actively monitoring replication connectivity with MySQL’s heartbeat
(Miguel Angel Nieto) Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master before abort the connection and establish it again.
Determination of a leap year in PostgreSQL
(Pasha Golub) From Wikipedia: A leap year (or intercalary or bissextile year) is a year containing one extra day (or, in the case of lunisolar calendars, a month) in order to keep the calendar year synchronized with the astronomical or seasonal year.
Identifying the load with the help of pt-query-digest and Percona Server
(Ovais Tariq) Profiling, analyzing and then fixing queries is likely the most oft-repeated part of a job of a DBA and one that keeps evolving, as new features are added to the application new queries pop up that need to be analyzed and fixed. And there are not too many tools out there that can make
Profiling your slow queries using pt-query-digest and some love from Percona Server
(ovais.tariq) Profiling, analyzing and then fixing slow queries is likely the most oft-repeated part of a job of a DBA. And there are not too many tools out there that can make your life easy by providing analysis of queries with such data points that allow you to attack the right queries in the rig
