… start if the XtraDB changed page tracking was enabled and variable innodb_flush_method was set to ALL_O_DIRECT. Bug fixed… #1003776. XtraDB changed page tracking used to hold the log system mutex for the log reads needlessly, potentially limiting performance on… file name could stop the server starting if the innodb_data_home_dir variable didn’t have the path separator at the…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…are plenty of other MySQL and OS-level status variables that you might want to keep an eye … internal understanding of what’s happening on the system below. Having never experimented with GlusterFS, though, I…grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… objects are now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for high levels… file name could stop the server starting if the innodb_data_home_dir variable didn’t have the path separator at the end. Bug fixed #1181887. Changed page tracking used to hold the log system…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag… comparison, and allow remote users to compare on a live system without needed to grant access to another “backup” server. As… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at…-vars is used to set both of these (or any) system variables. For a quick intro to metadata locks and how they… bugs. Version check will warn you about these if your system is running them. What’s new in 2.2 is…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…. Bug fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements… you encounter them, please report them to our bug tracking system. UPDATE[18-04-2013]: There was a RPM packaging regression…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… is retried only the number of times specified by this variable (default is 1 retry). This means more waiting, and after… (100, 1, NOW()); Conclusion Choosing a system to replicate your data to a distributed system requires tradeoffs. Most of us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no particular reason except… in question are LOCK_global_system_variables and LOCK_system_variables_hash. Deadlock is possible when one connection issues SHOW VARIABLES or equivalent while another…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
…, it may only affect you after you already have a system running in production for a while. Suppose you have the…. If your row has variable length columns and the complete row size exceeds this limit, InnoDB chooses variable length columns for off-page storage. In these cases, the first 768 bytes of each variable length column…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…. This feature is controlled by the expand_fast_index_creation system variable which is OFF by default. Let’s look at each… TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the… when using expand_fast_index_creation. It is a session variable, so you can temporarily switch it off if you are…
