…wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables….MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL… table with ENGINE=InnoDB, and the InnoDB transaction ID does not change in SHOW INNODB STATUS….
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…installations that would upgrade or are in the process of upgrading to MySQL 5.5, I thought it necessary to… Metadata Locking and Query Cache How does metadata locking behave with query_cache? That is an … key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would just fail immediately with the …
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…InnoDB patches have been merged Since Drizzle 7.0 (which was released last year), there have been over 3,500 commits to…how to install from the PPA are in the Drizzle manual. CentOS 6 packages are available from download.drizzle.org. Instructions on how to install them with…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… change data capture tool included with Flexviews. It continues with an overview of how to install and run FlexCDC, and concludes with a demonstration of the…_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert into test.demo values (1…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…with all the data points you need to attack the right query in the right way. But vanilla MySQL…InnoDB_IO_r_bytes: 16121856 InnoDB_IO_r_wait: 0.001414 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB… query log. Installing pt-query-… distribution” section shows how this query …
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…MySQL With innodb_file_per_table option but … of space but for most installations we’re speaking about tens of…MySQL CACTI Templates will have the graphs you need. If you’re looking at SHOW INNODB STATUS this is how…”Good” thing is performance typically starts to suffer terribly well before that and…
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
…how to do a lot with less hardware and time/staff needed. Florian Haas with his talk MySQL…MySQL with Innodb storage engine in case no transaction loss can be tolerated, such as dealing with…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… using InnoDB. If your server really hasn’t been configured — that is, it’s running with a default … keep in mind that the vast majority of MySQL installations don’t suffer from the variety and … to take a deeper look at the server, including how the data, schema, queries, and workload interact with…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to… is installed in /customsoftware/mysql with a different my.cnf file. The way to find this out is to… hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier to see…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…to check the platform specific part of the reference manual for hints about installing MySQL…with 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…
