…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…to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
…If I do show processlist, the update queries show up with state =’Updating‘ or some others with state… Info says ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I… where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The …
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
… InnoDB, then you can further clarify to yourself that the ALTER in your test case is waiting on InnoDB row locks by setting innodb_lock_wait_timeout to 1 and then issuing the ALTER: — session 1 start transaction; select * from t1 where id=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table t1 engine=innodb; And the alter will timeout…
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… Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides 1 and suddenly you can update…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout…-new pt-upgrade was written once long ago and not updated since. Now that we have four base versions of MySQL…’s like a lot of software that automatically checks for updates, but it’s also more: it’s a free service…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…was completed regardless of its state before updating. This caused some problems for some users,…existing table could wait on a metadata lock instead of failing or returning immediately if…. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… existing table could wait on a metadata lock instead of failing or returning immediately if …#49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov… can be reported on the launchpad bug tracker. UPDATE[18-04-2013]: There was a RPM …
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… Innodb, let alone Galera. I had considered a job queue system in Innodb in the past that, in absence of a ‘SKIP LOCKED… some other job (that had an open trx and had updated some meta field, but had not committed) and so could…
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
… I update this software to 2.0.7. But my backup script get this error: “innobackupex: fatal error: no ‘innodb_buffer_pool… –password=23khfisF –slave-info –no-lock –safe-slave-backup /db/backup/tst_ch118_3/201305″ innodb_buffer_pool_filename is not a…
Comment: Is Synchronous Replication right for your app?
May 15, 2013 By 18 Comments
… state that all transactions must update. Wonder if we need skip-locked or even more support to improve innodb-as-queue concurrency with…
