…EXCEPT a specified set of databases and tables. With this method, every event is …SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL…MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… start the snapshot while holding a “flush tables with read lock” and the flush operation will take some… of random data that doesn’t compress well showed a compression ration of 1.70 with gzip-1…ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… show 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: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack…node by simply by running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE“, in which case flow control…control came from this node because ‘Flow snt’ shows a message sent as soon as flow …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL…TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…Server for MySQL was missing help texts in the MySQL client because the help tables were …
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… that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the… 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…MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows…_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL…TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…Server for MySQL was missing help texts in the MySQL client because the help tables were …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail … message which should include the revision was showing “undefined”. Bug fixed #1171721. Other bugs fixed…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail … message which should include the revision was showing “undefined”. Bug fixed #1171721. Redundant code…
