… myisam and innodb tables. Global read lock only held until myisam tables are dumped. We are researching into how we could further improve lock… retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from s3…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
…mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | …LOCK command finally acquires the lock, it must begin flushing data. This does not apply to all storage engines. However, MyISAM…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE… even MySQL 5.1. I surely would like to see it sooner at least in more flexible community version. Relaxing Locks Row… areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5.0 Hopefully the patches he has provided…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
… MyISAM performance. As I said the reason of bad scalability is rw-locks and currently MySQL developers are working on CPU-depended rw-locks implementstation, this will be available in MySQL 5.1…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… have hidden dependencies of MyISAM table lock behavior in your applications, also check if your application handled deadlocks well. MyISAM will not produce… know two things about defaults for Innodb. First Depending on MySQL version they may be somewhere from suboptimal to absolutely disastrous…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… written before – MyISAM Does Not Scale, or it does quite well – two main things stopping you is table locks and global mutex… Key Cache in MySQL 4.1, and indeed previously it did not even scale with one CPU as global lock was held during IO duration, In MySQL 4.1 the lock is held only when key…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… as well. Locks – MySQL Replication SQL Thread executes queries same as any other thread and it has to grab the locks needed for query execution – either row level locks for Innodb or table locks for MyISAM and any DDL statements… MyISAM slaves used for long reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I installed Percona…? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it is backed up… lock using FLUSH TABLES WITH READ LOCK. MyISAM support is experimental. Apart from some very special, edge cases, I would not recommend using MyISAM…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… got to learn when working with large data things in MySQL is patience and careful planning. Both of which relate two… can’t run many simple reporting queries because for MyISAM they will lock tables for very long time and Innodb can get…. Typically it would be some portion of Index BTREE (even MyISAM which builds “normal” indexes by sort builds primary key and…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… surprise with concurrent inserts into a MyISAM table. The inserts were not happening … a different order of execution. The MySQL manual actually says this, but not …Locked – read Low priority read lock But on INSERT…SELECT, you’ll see this: Read lock without concurrent inserts That read lock…
