…id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.5.31-30.3[/…_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage… that could cause a memory leak if query cache was used together with InnoDB. Bug fixed …
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…(11) DEFAULT NULL, `col3` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`), KEY `col2` (`col2`), KEY `col2_2` (`col2`) ) ENGINE=InnoDB DEFAULT… ADD INDEX (col2); Query OK, 0 rows affected, 1 warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register… SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But… episode of each TV show. Couldn’t you have used a SUBQUERY to fetch and compare MAX(episode_id) as an option…
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…) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT ld.label_id…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM memcached.container WHERE id=’key_id‘”); id…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-…cpu combinations with taskset. The following chart shows a results comparison on a single-node…the buffer pool we use following queries: select avg(id) from sbtest$i force key (primary)…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…as storage. By default linkbench dataset has 10M ids(after load of data size of datadir ~10GB… MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows…open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… why I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x…query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id…repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… blue line – SSD config) which shows the most consistent performance. The …=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –…query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid…
