June 19, 2013

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table… know the coordinates of the last event executed: s1> show slave status\G [...] Executed_Gtid…4 ? A ‘Last_Executed_GTID’ column would have been useful. In our case …

Post: MySQL Query Patterns, Optimized - Webinar questions followup

MySQL Query Patterns, Optimized” for Percona MySQL Webinars.  If you missed it, you can still register to view the recordingin this case to force MySQL to scan the `title` table first, grouping by kind_id in index order.  This made the first table inlast episode of each TV show

Post: ZFS on Linux and MySQL

last 30 days one snapshot per hour for the last 2 days one snapshot per 5min for the last…holding a “flush tables with read lock”…t compress well showed a compression ration of… With ZFS each record on disk has a… be read from the other drive in the … interesting solution for MySQL backup servers.  All…

Post: How to recover table structure from InnoDB dictionary

SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables fromin CREATE TABLE statement internally they always go first in a record

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

In our last 5.5 series release of Percona Server, we included a regression in the RPM packaging that prevented the server fromMySQL was missing help texts in the MySQL client because the help tables

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLErecord from Arizona to be towards the top of the list. With 5.5, this is exactly what happens: mysql

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

Records: 0 Duplicates: 0 Warnings: 1 mysql> show warnings; +———+——+————————————————–+ | Level | Code | Message | +———+——+————————————————–+ | Warning | 124 | InnoDB rebuilding table

Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in… which range condition is applied cannot be used for filtering records. For example, suppose you have a key defined as: KEY…

Post: Dynamic row format for MEMORY tables

in MySQL has been one of the long-standing limitations caused by the fact that variable-length recordslast week. There have been efforts in the community to remove this limitation. Inshow-stopping, infrom this release however: MyISAM tables are still used for temporary tables where the MEMORY tables