…34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 …99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! …the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information…
Post: MySQL 5.0 Community Edition Regression
July 27, 2007 By 2 Comments
… are issues reported with SHOW PROFILE patch available in latest MySQL Community Edition and I’ve been troubleshooting customer affected by… 10 times in this case) The “fix” was to get MySQL 5.0.44 sources from Dorsal Source which base
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL 5.0 which… old MySQL versions not being upgraded to the most recent version in series. It is frequent to see something like MySQL 5.0.44 which went in as release in some of distributions. As many people use MySQL releases which come…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice… 2.47 8.03 1.01 0.96 0.96 101.44 dm-0 0.00 0.00 1052.67 0.62 8455.97 4.94 4227…
Post: xtrabackup-1.1
March 24, 2010 By 5 Comments
…: XtraBackup is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0.6 Added –host option tar4ibd can treat over… to mysql child proc Bug #510960: innobackupex –remote-host scp doesn’t copy MyISAM files The binary packages for RHEL4,5, Debian…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…- we made a short patch for MySQL 5.0 which show innodb buffer pool content mysql> select * from information_schema.INNODB_…| | | | | 61 | 0 | 61 | 69 | 0 | 0 | 0 | 63 | 4 | ibuf_free_list | | | | | 62 | 0 | 62 | 44 | 0 | 0 | 0 | 64 | 4 | ibuf_free_list | | | | | 63 | 0 | 63 | 44 | 0 | 0 | 0 | 65 …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… just for new connections as in MySQL. This is very helpful for measurement…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…0 71 # 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 # pages distin 40 11.77k 34 44…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… 0.7 4.5 0.1 0.4 46% 0 84042.8 sda3 24.4 0.7 0.5 4.7 0.0 0.3 44% 0 90043.9 sda3 21.7 0.9 0… 0.0 0.0 0.0 0.0 0.0 2.5 0% 0 23.2 sdi2 0.0 0.0 0.0 0.0 0.0 2.0 0% 0 23.2 sdj5 0.0 0.0 0.0 0.0 0.0 1.0 0% 0 23.2 sdi4 0.0 0.0 0.0 0.1 0.0 2.2 1% 0 23.2 sdi3 0.0 0.0 0.0 0.1 0.0 2.5…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… MEMORY and MyISAM storage engine. The benchmarks are done with MySQL 5.0.45 on 32bit Fedora Core 6 on Pentium 4 box… | 5f912d13f2d415c2c7cb325e1ebbdf468b37bc91 | +——-+——————————————+ 5 rows in set (0.00 sec) The table contains 1.000.000 rows with mostly unique “c” column. mysql> explain select… 9084 547160 0 0 5 44 96 103 2 0 94 3 0 0 3 116 56248 9104 549212 0 0 2 2023 1518 498 5 2 10 83 0 1…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want to copy order_line table…/vadim/mysql/export/ xtrabackup Ver 0.8.1rc Rev 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql… 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54…
