…drops to 33% after the first snapshot so keeping a large number of snapshots running is…snapshot while holding a “flush tables with read lock” and the…is related to better raid controller write cache use. Even the fairly slow…, ZFS on Linux is a very interesting solution for MySQL backup servers. …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… thread is now …TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped… of tables and slow IO…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… by log copying thread is now configurable by innobackupex …TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…with partitioned tables. Bug fixed #1169169. Tables that were dropped between… there are thousands of tables and slow IO then XtraBackup can…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… to 0. Then for analysis purposes the queries in the slow log were grouped by their timestamp, giving us a QPS… of MySQL used for benchmarking the new DROP TABLE implementation is MySQL 5.5.24, and the version of Percona Server used for benchmarking Lazy Drop Table is Percona Server 5.5.24 (innodb_lazy_drop_table…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… LOCK_open is locked, no query can be executed because they are stopped from accessing any table. Here is when the slow file removal… removals much more efficiently: EXT3 mysql> drop table large_table; Query OK, 0 rows affected (7.44 sec) XFS mysql> drop table large_table; Query OK, 0 rows…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…drop_eventblogpercona.commanual Com_drop_functionblogpercona.commanual Com_drop_indexblogpercona.commanual Com_drop_procedureblogpercona.commanual Com_drop_serverblogpercona.commanual Com_drop_tableblogpercona.commanual Com_drop…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…table SELECT * FROM old_table is done and then RENAME old_table to tmp_table, new_table to old_table and finally DROP tmp_table…closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow …DROP table waiting to run on the same table, and as such I have reported the bug: http://bugs.mysql…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…used 10mil row table which would look as following in terms of data and index size: mysql> show table status like… which 1.4GB is the Index. First Lets look at results of Adding and Dropping column for 128M … become very slow when index does not fit to memory any more. Creating Index by sort is great …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_…in MySQL 5.6 innodb_file_per_table is now ON by default. This is very big change and is good …large number of tables or if you do many create/drop of innodb tables. optimizer_switch is the catch all…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…is fine, and the client has asked me to figure out why the website is slow…tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…
