…shows a results comparison on a single-node (on the left) vs…status…select avg(id) from sbtest$i force key (primary) select count(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star…testing with a 4G buffer pool shows how the system performs …their were: mysql> select * from information_schema.global_status where variable_name like ‘%innodb… from ( select table_name, index_name, count(*) pages, sum(is_old=’YES’) old, count(*) – sum(…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…select count(distinct c) from antest; +——————-+ | count(distinct c) | +——————-+ | 101 | +——————-+ 1 row in set (0.36 sec) mysql> select count(distinct i) from antest; +——————-+ | count…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…_pages_distinct: 973 SET timestamp=1325146286; select count(*) from auto_inc; Note that… the number of tmp tables created in memory vs on-disk, …Tables # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_options’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_options`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
… introduce problem at first. The table is CREATE TABLE `c` ( `tracker_id` int(10) … slow ? Let me show. The query in question is (Q1): SELECT count(distinct username) …-20 00:00:00′ AND TIME_ID SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
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 the same way this blog post is aimed at a new optimizer enhancement Index Condition …
