… manual is only partially correct in how to properly build the server to use it (bug 61587). We …MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb…here due to the way this variable is used. Moving on. ==9090== Possible data race during write of …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…to traditional MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication with a write latency increase equivalent to…in Galera is how multi-node writing is implemented. … Innodb. Galera is allowing the first transaction to commit to…single piece of data to be written on …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB…been restarted recently. It is surprising how often a server crashes, perhaps even…, so there was no need to write new ones. For example, the …
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…t work. How can I recover deleted rows? We’re going to follow …data. The tool that we’re going to use to achieve this objetive is Percona Data Recovery Tool for InnoDB…write all the information related with tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…Data Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…to wait for metadata locks, at that point the ALTER simply blocks any type of queries to the table, we know that writes…) ENGINE=InnoDB; When using MySQL 5… but because of how meta data locking …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…to answer some and others are better answered in writing anyway. Q: One developer on our team wants to…)) engine=INNODB; when table has to be …how MySQL will execute the join. If it will fist lookup Table2 using some other index and when go to Table1 to…scanning data in index order MySQL gets data …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…Clearly About Performance by Cary Millsap. So how we can use this data to estimate capacity of MySQL system ? We can look at … it to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… sec mysql tables in use 2, locked 0 MySQL thread id 53038, OS thread handle 0x7ff759b22700, query id 3918786 localhost root Sending data… lets illustrate how MySQL and Innodb level locks play together with each other. To do this we can issue LOCK TABLE sbtest WRITE and repeat…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…to move to Innodb and when staying on MyISAM is preferred ? I generally prefer to see Innodb…data size is close to memory size), generally slower writes…Innodb and knows how to handle it, or be able to learn it. It is also important to adjust processes as required to work with Innodb…the MySQL server -…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job, and getting up to…to explore how to get beyond a single-mastered data store and why it’s a hard problem to solve. State of the Art for MySQL…
