…in the end for most users – you do not get to deal with recovering tables on the crash or partially executed statements. Table locks is no…MyISAM kills Innodb, such as copying binary tables between the servers. It is important the team understands Innodb and knows how to…in the MySQL server – in…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MyISAM…to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in…to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…to remove auto_increment from 100G table. No matter if it’s InnoDB or MyISAM, you’d usually ALTER TABLE `huge_table…tables with read lock, (3) swap .frm files while keeping mysql suspended and (4) unlock the tables afterwards: — 1. mysql> CREATE TABLE `huge_table…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…in MySQL 4.1 and now stable enough to use. Also check if your application can run in…in locking in 5.0 and even more to come with MySQL…no OS changes and have no changes done to application which was written keeping MyISAM tables in…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
… is done while table_cache lock is being held so no other queries…the list you really need to think how large it can get…use innodb_file_per_table=0 for such tables (thankfully you can change this variable online in Innodb Plugin, MySQL…depending on buffer pool size. MyISAM tables creating/dropping was…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions. We rarely would use…using LIKE statement. As default table format for slow_log is CSV with no indexes typical operations like finding how many queries were accumulated in…table to MyISAM…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…MySQL has detected that the underlying table has changed and it needs to close and reopen it using FLUSH. Therefore the table will be locked…to finish than the original query. On the other hand, if the table is MyISAM there will be no…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
…used for fulltext search, so no InnoDB possible for now. My question is, is it possible that it is only related to a MySQL…locked on a resource is it possible that the scheduler of a modern operating system wastes 90% time in…to substitute the fulltext search on MyISAM table…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…how does it compare in performance? Â When would I use PBXT instead of a storage engine like MyISAM…MySQL calls the engine “init” method on startup it is holding the global LOCK_plugin lock. In init, the engine needs to do recovery. In…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…TABLE STATUS” is not showing index sized in the release we tested it is hard to see how small indexes really are. [-] No “using…in MySQL anyway though). Very interesting to see how this one will compare to…
