… 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93…99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! Current…log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… final result: As you see XtraDB, 5.0.83-percona and MySQL 5.4 are almost equal, leaving 5.0.83-standard far behind. If you wonder… IO-bound results Again you can see that XtraDB, 5.0.83-percona and 5.4 are almost equal, with difference we have get…:start) And now 5.0-tree will contain all performance fixes and show the same results as 5.4 Both 5.0.83-percona and XtraDB…
Post: 5.0.83-build17 Percona binaries
July 28, 2009 By 19 Comments
… Percona patches is available. New features in the release: MySQL-5.0.83 is taken as the basis The new patch innodb_use… sources with the patches here http://www.percona.com/mysql/5.0.83-b17/ The Percona patches live on Launchpad : https://launchpad.net…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
….tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want to copy order_line table to…/mysql/export/ xtrabackup: tables regcomp(): Success xtrabackup Ver 0.8.1rc Rev 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: uses… –target-dir=/data/vadim/mysql/export/ xtrabackup Ver 0.8.1rc Rev 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… 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.4Ratio Query1370.50372.161… more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99 Query2NANANA Query3NANANA Query4NANANA Query5NANANA…
Comment: Hacking to make ALTER TABLE online for certain changes
September 23, 2009 By 26 Comments
…. rows =5000000. Size >7GB OS =windows xp sp2 mysql vesion =5.0.83 Followed the steps as said. As expected indexes were there…_text | +————–+———+———-+———-+ | lyrics.heavy | analyze | status | OK | +————–+———+———-+———-+ 1 row in set (0.03 sec) mysql> optimize table heavy; +————–+———-+———-+———-+ | Table | Op | Msg_type…,67204#msg-67204 and http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html Is it the case that…
Comment: 5.0.83-build17 Percona binaries
July 28, 2009 By 19 Comments
Are you aware of CVE-2009-2446? 5.0.83 is affected, it’s fixed in 5.0.84 with this patch: http://lists.mysql.com/commits/77649
Comment: Performance improvements in Percona 5.0.83 and XtraDB
July 15, 2009 By 27 Comments
Sander, What about 5.1.36 ? If you mean benchmarks for standard 5.1.36 I expect the results are very close to 5.0.83
Comment: xtrabackup-0.8
July 6, 2009 By 8 Comments
Hello, I guess you forgot to update version of the xtrabackup. It still reports “xtrabackup Ver rc-0.7 for 5.0.83 pc-linux-gnu (x86_64)”. Regards, Eugene.
Comment: MySQL 5.5-m2 scalability
March 1, 2010 By 17 Comments
…/07/14/performance-improvements-in-percona-5-0-83-and-xtradb/ You specifically made changes to “align with 5.4″ — because it wasn’t…
