… table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.25 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) NOT NULL…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… table to count the movies per production year for each kind_id. It was more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first table in the… were trying to determine the last episode of each TV show. Couldn’t you have used a SUBQUERY to fetch and…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you… to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written to the… the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server’s…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… show where GTIDs shine and where improvements are expected. This is the second post of a series of articles focused on MySQL… mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table… to know the coordinates of the last event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… to start the snapshot while holding a “flush tables with read lock” and the flush operation will … of random data that doesn’t compress well showed a compression ration of 1.70 with gzip-1…. ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact …
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables from the…. `ID` is a table identifier. We will need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
