…-55 x86_64 5.5.29-rel29.4.401.rhel6 percona 15 M php-mysql x86_64 5.3.3-14.el6_3 updates 79 k…-compat x86_64 5.5.29-rel29.4.401.rhel6 percona 3.4 M php-mysql x86_64 5.3.3-14.el6_3 updates 79 k…, this has the advantage of allowing an upgrade from 5.1 to 5.5 without uninstalling any software that depended on the old version…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… to fix, But why is not it mentioned in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to work with group… interesting. If you have update prevailing load you would see very strange behavior on 5.0 of MySQL being slow but few queries…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… MySQL 5.0 to 5.5 for MyISAM tables? MyISAM have not been getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5… with hints to get to old execution plans. In many cases though you can get to former execution plan either by updating statistics (ANALYZE…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…to the core of original implementation which appeared in MySQL 4.0 Query Cache was designed to…MySQL Query Cache instances hashed by query hash. It would help to reduce complexity dramatically. Fast Invalidation Right now when you update…
Post: Introducing the “Version Check” Feature in Percona Toolkit
September 10, 2012 By Leave a Comment
…. To list a few: MySQL 5.5.25 UPDATE on InnoDB table enters recursion, consumes all disk space All MariaDB and MySQL versions up to 5.1.61, 5.2.11, 5.3.5, 5.5… will be available in the next release, version 2.1.4. To activate Version Check, you will call the tool that supports…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… version – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5.0.86. The largest… to different major version, especially if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5… made it to caught up you can use mk-table-checksum to ensure data is the same. It is possible some update statements…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
…to try to diagnose the issue, one of which being to try to force MySQL to…update_date) | +———————+ | 2024-06-21 10:35:55 | +———————+ (root@localhost) [test]> select update_date FROM foo order by update_date LIMIT 5; +———————+ | update…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… your password in the configuration file, update it in Tunnelier now also) Re-connect to see if your password change worked as…-conflicts… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-1 Total Download… start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… ibdata was updated MySQL will fail to start with error: InnoDB: Reading tablespace information from the .ibd files… InnoDB: Error: trying to add tablespace… page 11 4. The third time to be sure ibdata1 has valid checksums: #./innochecksum /var/lib/mysql/ibdata1 # 5. Now you can start MySQL and…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… x86_64 Percona Server 5.5.11 with XtraDB. Requires m1… int(11) DEFAULT NULL, `DistanceGroup` tinyint(4) DEFAULT NULL, `CarrierDelay` int(11) DEFAULT…data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table…-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay…
