…of months there have been no updates to our … MySQL installation was built, so you can have the new binary …tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql…. This option is standard MySQL, however after you apply the patch…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL version upgrade can have both of these issues. It gets larger as you have a larger leap in minor version – Upgrade of MySQL…work differently after change… new and old MySQL installations…table-checksum to ensure data is the same. It is possible some update statements worked differently in the new…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… installs of …new snapshot .. done Trimming excess snapshots .. Logical volume “mysql…mysql-data 0.00 mysql-logs sb -wi-ao 10.00g Suppose sometime after the snapshot, I accidentally dropped the salaries tables… Warnings: 0 mysql> update employees set age…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…not just for new connections as in MySQL. This…have the statistics available after the query is … general query log. Installing pt-query-digest tool…1.00 0.01 UPDATE wp_options # 7 …tables involved and the query execution plan used by MySQL. The end result might be that you end up limiting the number of…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…of “downtime” was really trivial. I’d like to share my experience. The article does not cover MMM installation…mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its tables…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…Based on MySQL 5.5…“UPDATE“ and “DELETE“ statements but not updating …Added a new boolean option,… Kopytov). After adding …tables where the first UNIQUE key on non-nullable columns was picked as the clustered index by InnoDB in the absence of…Software Repositories Installation instructions Consulting…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…UPDATE“ and “DELETE“ statements but not updating… After…tables where the first UNIQUE key on non-nullable columns was picked as the clustered index by InnoDB in the absence of…MySQL bug #53761 (Wrong estimate for RANGE query with compound indexes). #832528 (Alexey Kopytov). Added a new… Installation …
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…stay fully operational after any failure but…’re using MyISAM tables) which can cause…MySQL Replication for HA) the switch to the new server may not be 100% clean with few updates lost. RAID, especially with BBU also makes a good sense to get extra performance out of the box. Some installations…
