… 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 thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as…) 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
…query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time …TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written to the… in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. …start the snapshot while holding a “flush tables with read lock” and the flush operation will take some… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of… simply by running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE“, in which case flow control will kick in just as soon as the… easily see flow control if I execute a FLUSH TABLES WITH READ LOCK on node3: [root@node3 ~]# myq_status wsrep Wsrep Cluster…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features that have been added in MySQL 5… excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…lock_x_lock_func(rw_lock_t*, unsigned long, char const*, unsigned long) | — rw_lock_x_lock_func(rw_lock…In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL… max_connections=5000 table_open_cache=5000 table-definition-cache=1000…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… noticeable omission: pt-table-sync. It’s still unclear if or how one would sync a cluster that, in theory, doesn’t… –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
… bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead of failing… #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… in MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE…. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed…
