…usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and the… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time… Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested ? Sign up today!
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…. Applied to a standalone Innodb instance Let’s break it down a bit. Our unit of locking in Innodb is a single row… will take the 1 RTT). The other transactions will lock wait until the lock(s) they need are available. The application just… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb… statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a… the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb… statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a… the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB…
