…MySQL‘s Transactions work with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed in many cases it will Create temporary table…mysqldump –lock-all-tables instead which does not…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…at commit. That makes prefetch simple but has high overhead from locking rows only to undo… (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not work correctly with tables where the first UNIQUE…KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug… at commit. That makes prefetch simple but has high overhead from locking rows only to undo…855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not work correctly with tables where the first UNIQUE…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…table makes any difference: mysql> SET expand_fast_index_creation=OFF; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE…table I used in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-keys > dump_optimized.sql $ time mysql…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…not get to deal with recovering tables on the crash or partially executed statements. Table locks…not work with Innodb. Backup tools like “mysqlhotcopy” does not work etc. Note Performance also affects Operations aspects a lot – for example using mysqldump…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 18 Comments
… make it running with 2 nodes too. 2. Each Node is regular MySQL … continue to work, you can continue to run queries on working nodes….available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona … FLUSH TABLES WITH READ LOCK command). Xtrabackup SST does not require READ LOCK for …
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not… make single full table scan…tables and so do not suffer from table locks…mysqldump, or even careful file transfer if you’re using MyISAM tables. Chop it If you can’t execute this work…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…not fit into memory. As benchmark software I tried iiBench, which you can take there https://launchpad.net/mysql-patch/mytools What makes… is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied TABLE LOCK on copying table. … in MySQL 6.0, but I can’t yet say how it will work …
