… using a blocking SST method like rsync or mysqldump. So, flow control kicks in when the recv… by the above calculation if fc_master_slave=NO). This yields the number of transactions the …node by simply by running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE“, in which case flow control…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead of failing…. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
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…. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table | 0.002255 | | After create | 0.000050 | | copy to tmp table | … index; mysqldump –innodb-optimize-keys ignores the first UNIQUE index on non-nullable columns when the table has no PRIMARY KEY …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We …further improve lock times here when non-transactional tables are used Almost no locking, if not using myisam tables Built in compression Each table is …
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
… is OK table is exposed without indexes for some time. Note though nothing stops you from using LOCK TABLES on Innodb table to ensure there is not ton of queries starting reading table with no indexes and bringing… implemented but majority of high level commands or tools (like mysqldump) do not get advantage of it and will use old…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…table `C` — LOCK TABLES `C` WRITE; /*!40000 ALTER TABLE `C` DISABLE KEYS */; /*!40000 ALTER TABLE `C` ENABLE KEYS */; UNLOCK TABLES…table C at the same time as mysqldump was running we got table empty table with new structure in mysqldump instead of table…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
…thankfully just a game fan site, no real money lost. Then I …TABLES WITH READ LOCK. It immediately acquired locks on all tables — effectively write locks, as you say — except this one log table. It held those locks… InnoDB for everything, and use mysqldump –single-transaction for backups. Hopefully…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… not get to deal with recovering tables on the crash or partially executed statements. Table locks is no more problem, hot backups are easy… Performance also affects Operations aspects a lot – for example using mysqldump as a backup may well work for MyISAM but will… time to do restore for Innodb. On large scale installations mysqldump does not work anyway but it may still work for…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer…_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment…
