…. It can be downloaded here So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB… 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….46 Query9NANANA Query10NANANA Query112726.203395.021.25 Query12NANANA Query13NANANA Query142345.68?NA Query15NANANA Query16725.31693.560.96 Query171895.55NANA Query18NANANA Query194896…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… new connections as in MySQL. This is very … you would want to download the “slow query log”…0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1.00 0…68 13.06 313.99 # InnoDB: # IO r bytes 0 0 0 0 0 0 0 0 # IO r ops 0 0 0 0 0 0 0 0 # IO r wait 0 0 0 0 0 0 0 0…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
… | 0 | 0 | 0 | 0 | 68 | 3 | inode | | | | | 67 | 17 | 38 | 1048 | 15720 | 0 | 0 | 69 | 17855 | index | GEN_CLUST_INDEX | art | a87 | | 68 | 17 | 1715 | 128 | 15077 | 0 | 0 | 70… source code also available to download P.S. There is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… 0 0 68 78 105K 117K 0.0 0 22 0 0 19:17:08 trime P 3 3 node3 Sync T/T 0 0 65 93 101K 135K 0.0 0 14 1 5 …this node was the originator of the transaction. Dn is download, that is, transactions from other nodes in the cluster. …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… 1988 to 2009 in chunks per month, so I downloaded 252 files (for 1988-2008 years) with size from …: 0.5s for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL is …: Years, InfoBright, MonetDB 1y, 1.74s, 0.55s 2y, 3.68s, 1.10s 3y, 5.44s, 1.69s 4y, 7.22s, …
