May 21, 2012

Comment: How to recover a single InnoDB table from a Full Backup

… 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64…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: CentOS Comes with free build of MySQL Enterprise ?

….x86_64 5.0.54-1.el4.centos centosplus mysql-bench.x86_64 5.0.54-1.el4.centos centosplus mysql-devel.x86_64 5.0.54-1.el4.centos centosplus mysql-libs.x86_64 5.0.54-1.el4.centos centosplus mysql-server.x86_64 5.0.54-1.el4…

Post: MySQL 6.0 vs 5.1 in TPC-H queries

… TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a… 0.55 29.67 dm-0 0.00 0.00 550.10 0.62 132545.38 4.93 66272.69 2.46 240.69 0.30 0.54 0… 4.87 247.70 0.27 0.52 0.52 27.22 dm-0 0.00 0.00 542.60 0.61 130724.54 4.87 65362.27 2.43 240.66 0.28 0

Post: TPC-H Run on MySQL 5.1 and 6.0

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: Should we proclaim MySQL Community Edition Dead ?

Well, I’ve give a try to Provenscaling Yum Repository. 5.0.54 works fine, so I trun auto update on. But 5.0.60 broken our internal server. Then I dicide just stick with old-good 5.0.51a.

Comment: Multi-Column IN clause - Unexpected MySQL Issue

… thing, but see also http://dev.mysql.com/doc/refman/5.0/en/row-subqueries.html I have a draft post about… that 5.0.26 and newer does optimize this (I have not tested). Your bug report says you see this on 5.0.54, so…

Comment: MyISAM mmap feature (5.1)

As this article is several years old, would it be possible to post the 5.0 series patch if it will still apply to the current 5.0.54 (or other) release? Thanks, Michael

Comment: CentOS Comes with free build of MySQL Enterprise ?

… file, as MySQL provides them. For example, mysql-enterprise-gpl-5.0.54-0.rhel4.x86_64.tar. Regards, Jeremy

Comment: Pitfalls of converting to InnoDB

Hi. MySQL Version: 5.0.54-enterprise-gpl-log MySQL Enterprise Server (GPL) I have just …

Comment: Should we proclaim MySQL Community Edition Dead ?

Peter, I wish this (limited testing by the community of Enterprise releases) were not so. There are several bug fixes in versions 5.0.54+ that I want and I prefer to use a version that has been widely tested by the community.