… ms total 0.60486 ms per/cmd 0.586 ms min per/cmd 0.805 ms max per/cmd 0.219… ms total 0.288257 ms per/cmd 0.2843 ms min per/cmd 0.3026 ms max per/cmd 0.0183… ms total 0.347181 ms per/cmd 0.3208 ms min per/cmd 0.4159 ms max per/cmd 0.0951… ms total 0.441573 ms per/cmd 0.4327 ms min per/cmd 0.5129 ms max per/cmd 0.0802…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… is worrisome to me. Let’s zoom in to 10 min intervals and see throughput: We can see periodical drops, which… = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M…
Comment: How long Innodb Shutdown may take
May 14, 2013 By 9 Comments
… innodb shutdown and startup both took long i.e. 7 mins each 130514 7:57:39 InnoDB: Starting shutdown… 130514 8…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… bugs with small static rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length+(ulong) create…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
…-06 00:00:00 | +——-+———————+ (root@localhost) [test]> select min(update_date) from foo; +———————+ | min(update_date) | +———————+ | 1058-11-06 00:00:00… foo SET i=i+100000 where i select min(update_date) from foo; +———————+ | min(update_date) | +———————+ | 2024-06-21 10:35:55…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
….464 sec Q2.1 1 hour 54 min 27.74 sec (6867.74) 19 min 44.35 sec (1184.35 sec) 9694.534 sec Q2.2 1 hour 13 min 33.15 sec (4413.15) 19 min 49.56 sec (1189.56 sec) 9399.965 sec Q2.3 1 hour 8 min 23.41 sec (4103.41) 19 min 52.27 sec (1192.25 sec) 8875.349 sec Q3.1 NA 19 min 11.23 sec (1151.23 sec) 16376.93 sec Q3…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
…_TIMER_UPDATE: 78153671549 COUNT_DELETE: 4292 SUM_TIMER_DELETE: 1302645570629 MIN_TIMER_DELETE: 18127219 AVG_TIMER_DELETE: 303505097 MAX_TIMER_DELETE…_TIMER_UPDATE: 78153671549 COUNT_DELETE: 4292 SUM_TIMER_DELETE: 1302645570629 MIN_TIMER_DELETE: 18127219 AVG_TIMER_DELETE: 303505097 MAX_TIMER_DELETE…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… set k=k+1; Query OK, 1000000 rows affected (1 min 14.12 sec) Rows matched: 1000000 Changed: 1000000 Warnings: 0… –max-requests=0 –max-time=300 run …. per-request statistics: min: 0.68ms avg: 0.88ms max: 306.80ms approx. 95… update statement on the different cluster node: per-request statistics: min: 0.69ms avg: 1.12ms max: 52334.76ms approx. 95…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | | test.t | optimize | status | OK | +——–+———-+———-+——————————————————————-+ 2 rows in set (2 min 57.65 sec) mysql> SHOW TABLE STATUS LIKE ‘t’\G… | | test.t | optimize | status | OK | +——–+———-+———-+——————————————————————-+ 2 rows in set (1 min 12.19 sec) mysql> SHOW TABLE STATUS LIKE ‘t’\G…
