… to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that would … mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting … why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… might have created and forgot to remove (or still use for processing). Of …509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0… is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate …
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
…demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT… Total_R | Pct_R | Calls | R/Call | +———————-+———-+——-+——-+————–+ | removing tmp table | 0.095135 | 55.10 | 3…000014 | 0.01 | 2 | 0.0000070000 | | System lock | 0.000010 | 0.01 | 1 | 0….
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… page): Release the shared lock on the latch protecting the AHI Lock the page in exclusive mode Remove all entries in the AHI pointing to the page Release the lock on the… Oracle MySQL >= 5.5.23 The main function that is responsible for cleaning the bufferpool is buf_LRU_flush_or_remove_pages…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… to be removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down… mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We are researching… retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from s3…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… would lock up at random times and then it would go back to normal in just a few seconds. This was MySQL…-rw—- 1 mysql mysql 1073742171 Nov 2 15:15 /var/lib/mysqllogs/db1-bin-log.003229 -rw-rw—- 1 mysql mysql 1073742976 Nov 2… than expire_logs_days are removed. &LOCK_log mutex is held for the duration of the binary log removal and if your file…
Post: Announcing Percona XtraBackup 2.0.5
January 23, 2013 By Leave a Comment
…what extra file to read the default MySQL options before the standard defaults-file. It… caused database to be unnecessarily locked with FLUSH TABLES WITH READ LOCK. Innobackupex now waits … –tables-file options of XtraBackup. Fixed by removing the partition suffix (#P#…) before doing filtering. …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… get relaxed locks in many other cases. Gap or next-key locks which limit concurrency in many cases can be removed for READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1 It… areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5.0 Hopefully the patches he has provided…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…innodb_current_row_locks. (Yasufumi Kinoshita) Old system variable innodb_enable_unsafe_group_commit was deleted. The existing MySQL variable innodb_…updated version of the original implementation of the Remove Excessive Function Calls feature, which removes some fcntl calls to improve performance. (…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… least remove confusing message which leaves impression this thing works. Until this issue is fixed getting Crash Safe replication with MySQL is… do traditional and recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount…
