…upgrading from MySQL 4.0 and 4.1 to MySQL…MySQL handled this problem. While working for MySQL we spotted this problem early in MySQL…MySQL being slow but few queries being “inside innodb…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…problems with replication lag (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb…problems. MySQL Restart MySQL Restarts may include recovery time but what is the most important…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…upgrades, …problems might be: is the disk saturated? Is the machine swapping actively? (This is more important…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…InnoDB tables whose .frm files exist but have been dropped from InnoDB…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…locks is no more problem, hot backups are easy, though there are some important things which we…instantly break upon upgrading to Innodb. Features The MyISAM features which forbid moving to Innodb are typically…exercises not so common paths in the MySQL server – in particular Optimizer may have harder…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
…(id) ) Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example…problem? Here are a few approaches you can take to solve this: Upgrade… worse compression will work). Something important to note is that … think you have a bigger problem than Innodb‘s internal limitations), though…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log write latency is triple important…intensive workload you will have problem with number of outstanding …MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades…
Post: Percona Server with XtraDB Case Study, Behind the Scenes
October 21, 2010 By 13 Comments
…was struggling on standard MySQL and InnoDB. The big win was the upgrade to XtraDB. The … could be done without fixing these problems inside MySQL and InnoDB at the source code level, or…temperature of patients in the hospital isn’t important.” Good performance means avoiding outliers and variations…
Page: Presentations
May 3, 2006 By
…problems. Download Innodb Performance Optimization MySQL Users Conference 2007, Santa Clara,CA, April 2007 Presentation covering Innodb specific application design recommendations as well as Innodb MySQL…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…important the patch is available for all the recent MySQL…problem…InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB extensions msl patch for MySQL…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…If you are using InnoDB, it is also important that your …discover the problem, so it is really important that …mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position 336797275 mysql-bin.000022 | mysql mysql… ALTER or server upgrade, this method can …
