… MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema,… 0 Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… status variables in the Extended Show Engine InnoDB Status to improve … bug #710799. This regression caused mysql schema to be missing after the clean…MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… Performance Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time showing… focus include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…combinations with taskset. The following chart shows a results comparison on a single-…max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup… –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… schemas. The first schema is from sysbench, and the table looks like: CREATE TABLE …show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB table…lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…show_statusblogpercona.commanual Com_show_storage_enginesblogpercona.commanual Com_show_table_statusblogpercona.commanual Com_show_tablesblogpercona.commanual Com_show_triggersblogpercona.commanual Com_show_variablesblogpercona.commanual Com_show…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…2 REFERENCED_TABLE_SCHEMA: test REFERENCED_TABLE_NAME: Foo REFERENCED_COLUMN_NAME: B 2 rows in set (0.00 sec) This shows that…_SCHEMA.KEY_COLUMN_USAGE; mysql> INSERT INTO test.MY_KEY_COLUMN_USAGE SET CONSTRAINT_SCHEMA = ‘ecommerce’, CONSTRAINT_NAME = ‘fk_lineitems’, TABLE_SCHEMA = ‘ecommerce’, TABLE_…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… MySQL and InnoDB plugin’s manual: Metadata commands like SHOW INDEX, SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.STATISTICS) When 1 / 16th of the table or…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…schema from one shard. The schema is duplicated 20 times (but not the ontime_fact data): DROP TABLE IF EXISTS `dim_airport`; CREATE TABLE…all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row …
