…: 0 Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11…key-checker will detect subtle redundancies that are engine-dependent, like redundant suffixes for secondary keys in…
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 Fixed…the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…different types of subqueries (correlated, non-correlated, derived tables, scalar subqueries) and we saw in my …patterns the MySQL designers know can be improved. But there’s a finite amount of engineer-years spent…to determine the last episode of each TV show. Couldn’t you have used a SUBQUERY …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… everything EXCEPT a specified set of databases and tables. With this method, every event is still written … same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves … of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL …
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… lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… box and varied cpu combinations with taskset. The following chart shows a results comparison on a single-node (on the left…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple…
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…) unsigned DEFAULT NULL, PRIMARY KEY (`TABLE_ID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 So, `TABLE_ID` is our table_id. `ID` here is the…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… the graph as the blue line – SSD config) which shows the most consistent performance. The others all have assorted … –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB table: 58GB…: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it… the table as it would be in the production over time: mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine…
