…, 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, OS… localhost root Copying to tmp table create table t as SELECT ld.label_id, cai.inventory_id, COUNT(1) as installed_count from…) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In…drill-downs that are common in OLAP analysis. Each query in each flight (Q1.1 for example) is …32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… you’ll get roughly 1.67x the throughput of a … set of databases and tables. With this method, every …in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL… would you ever want to use MySQL on top of something like…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… Pretty interesting to speed up point in time recovery when you dataset is … while holding a “flush tables with read lock” and the flush operation … controller write cache use. Even the fairly slow gzip-1 mode works well. …is a very interesting solution for MySQL backup servers. All backup solutions …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc_factor=1…running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE“, in which case flow control will kick in just as … node to the cluster. This can be used to discover which node is causing flow control…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… pt-table-sync. It’s still unclear if or how one would sync a cluster that, in theory,…confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both…JSON structure. Version check is on by default In 2.1.4, released September/October 2012, we …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table…MySQL was missing help texts in the MySQL client because the help tables… feature was used. Bug fixed #1107539 …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…in your application. These are maintained in separate tables and there also exists a users_groups table…1 RTT). The other transactions will lock wait until the lock(s) they need are available. The application just waits in… used to the tradeoffs we take when deploying conventional stand-alone MySQL…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…after load of data size of datadir ~10GB). We used this dataset to check server behavior when data … For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5.6.11 in … 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads…in MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE…#1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when …
