June 19, 2013

Post: How fast can you sort data with MySQL ?

August 18, 2007 By 26 Comments

… table completes in 0.22 seconds giving us about 4.5 Million of rows/sec…is 32K which gives us the following speed: mysql> select * from gt order by i desc limit 10… | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 10 | | Sort_scan | 1 | +——————-+——-+ 4 rows in set (0.00 sec)…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…1 | | 1 | Harold Wesley Abbott Iii | 0 | | 3 | William Doyle Abbott Jr | 0 | | 5 | Robert Jack Abraham | 0 | | 7 | Mark Allen Abrell | 0 | +——-+————————–+——-+ And with 5.6: mysql… take a look at performance. How does the speed of InnoDB FTS compare to its MyISAM counterpart,…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: TPC-H Run on MySQL 5.1 and 6.0

April 10, 2008 By 16 Comments

… MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… hour in 5.1 and MySQL 6.0 can complete all queries within an hour. We can also see MySQL 6.0 improving query 20 speed dramatically…

Filed Under: Benchmarks

Post: Upgrading MySQL

January 5, 2010 By 24 Comments

… you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because so much more… one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with… of queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL does not crash…

Filed Under: Insight for DBAs, MySQL

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

…, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses …Processor ################################################## Processors | physical = 1, cores = 2, virtual = 2, hyperthreading = no Speeds | 2×1200.000…: 20975714304 Max_data_length: 0 Index_length: 9047113728 Data_…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: The Optimization That (Often) Isn't: Index Merge Intersection

December 14, 2012 By 6 Comments

… only one index actually used. To some extent, MySQL 5.0 and later changed this situation with the introduction … here that the (parent_id, status, user_type) = (0, 1, 2) tuple chosen by pt-query-digest as … not see right away. Disabling this setting might speed up this query (it did), but it might …

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

…processing and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported …, thread declared inside InnoDB 114 mysql tables in use 1, locked 0 MySQL thread id 8077, query id …hash index Innodb builds for some pages to speed up row lookup replacing btree search with hash…

Filed Under: Insight for DBAs Tagged With:

Post: Watch out for Marketing benchmarks

August 23, 2006 By 7 Comments

… we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected and bunch of other benchmarks which show 5.0… development there is no free lunch and your decisions to speed something up often will mean something else becomes slower. There…

Filed Under: Benchmarks

Post: Percona Server 5.1.59-13.0

October 16, 2011 By Leave a Comment

… Server 5.1.59-13.0 on October 15, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.59, including all the bug fixes in it, Percona Server 5.1.59-13.0 is now the current stable release in the 5.1… slave server in a replication environment, the process can be speed up by having prefetch threads to warm the server: replay…

Filed Under: MySQL, Percona Software

Comment: XtraDB storage engine release 1.0.4-8

November 2, 2009 By 12 Comments

…-percona-5.1.39-8.rhel5.x86_64 Marking MySQL-server-percona-5.1.39-8.rhel5.x86_64.rpm to be installed Loading mirror speeds… —> Package MySQL-server-percona.x86_64 0:5.1.39-8.rhel5 set to be updated –> Processing Conflict: mysql conflicts MySQL –> Finished Dependency Resolution mysql-5.0.77-3…

Filed Under: MySQL, Percona Software Tagged With:
« Older Posts
Newer Posts »