… this – you might think most relevant players in MySQL community participated in MySQL Users Conference over the years. This is about 2000… you can copy MyISAM tables on file basics but not Innodb ? By the fact you can have transactions with MyISAM tables but they would not actually roll back ? Replication which can get broken by Server Crash ? A lot of…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… did I use this solution compared to others: Innodb Tables – This table is getting much more reads than writes so transactional overhead… IO dramatically. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… the crash which might need to take care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables there is very large chance of them becoming corrupted during the crash. Note…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… buffering taking place and as MySQL crashes it does not store all data it could recover to MyISAM table. Using series of queries with… not use MyISAM table but fetch data to the script instead make sure to use LIMIT or PK Rangers when MySQL crashes you will… hint – you may want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…table mode. Unlike MyISAM Innodb does not have to keep open file descriptor when table is open – open table…MySQL table_cache Innodb maintains its own (called data dictionary) which keeps all tables ever accessed since table…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… it so it consumes too much memory it may be crashing , failing to execute queries or make operation to swap seriously… lot of tables. It also means user having CREATE TABLE privilege should be able to run MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer which is large enough to contain largest record in the given table…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes and…- compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We are researching …
Comment: MySQL Crash Recovery
October 12, 2007 By 30 Comments
… for sure. MyISAM tables – yes these are not designed to be crash save. They WILL most likely become corrupted if MySQL Server crashes. However you do not have to use MyISAM tables. Innodb tables do…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at…_word_len = 4 thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer…_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover user=root skip-grant-tables
Post: Crashes while using MyISAM with multiple key caches
July 18, 2009 By Leave a Comment
Over last couple of years I have ran into random MySQL crashes in production when multiple key caches were used. Unfortunately this… or change mappings of the tables. No let me put my complain hat on. Looking into this crash bug I see it… only in later MySQL versions but left unfixed in former ones ? I also would like to have no crash bugs in the…
