Kristian – this is worth fixing if that is a bug in InnoDB. Can you file one at bugs.mysql.com with details from… log? AFAIK, InnoDB is snapshot safe as long as database files and log files are on the same filesystem. But MySQL/InnoDB is not snapshot safe if DDL operations are in flight because DDL between MySQL (frm files) and InnoDB is not atomic…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… an Innodb table make a copy of the .frm file do an ALTER TABLE to add an index then copy the old .frm file back…, but this basically will regurgitate the entire Innodb Data dictionary to the mysqld error log file. If I had to do it… to fix it. However if I did have to fix it, I found on my test table that the extra index in Innodb…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
… and let you to get out quickly and fix things. But it gets worse. Innodb failed initialization is not only very hidden… message accessing Innodb tables is also very obfuscated: error : Incorrect information in file: ‘./prod/user.frm‘ How this supposed to tell you Innodb (or for that sake any other Storage Engine) failed to initialize ? This error suppose to mean .frm file is corrupted…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… long time with the normal method of copying the FRM files and non-InnoDB tables. By doing a two-phase pass over the… is held. See the rsync for non-innodb files blueprint for technical implementation details. Bugs Fixed innobackupex assumed that /usr/bin/perl was… dropped table. With this bug fix, innobackupexnow safely ignores file not found errors for non-InnoDB tables. Bug Fixed: #859546 (Lachlan Mulcahy) When the…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… split into different files. Usually system tablespace is located in ibdata1 file and every InnoDB table has two files e.g. actor.frm and actor.ibd. The annoying thing about .ibd files you can…) page 11: new style: calculated = 0x E4189B9B; recorded = 0x C168689B fixing new checksum of page 11 # # ./innochecksum -f /var/lib/mysql…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… an actual fixed length page). Are there any differences in the PBXT implementation of MVCC that might surprise experienced InnoDB DBAs? Â… a table, create a session structure (THD) or create a .frm file. One extreme example of this is PBXT recovery. When MySQL…. In PBXT’s case this means opening tables (reading a .frm file), which requires creating a THD. The code to create a…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…InnoDB table cache? 3) Would converting the MyISAM tables to InnoDB fix…Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data_file…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc_miehr_posasmp/panel_decert.frm‘ (errno… MyISAM and InnoDB and the difference in how the OS handles opened files? 3) Would converting the MyISAM tables to InnoDB fix or help…_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data_file_path = ibdata1…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But again…. You might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA query… so they can decide which things to have us fix, which to fix themselves, and which to just ignore. The above process…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… posts on group commit alone. I think that a full fix might require significant architectural changes to MySQL. This will be… in InnoDB, and b) InnoDB‘s data didn’t have to be synchronized with the .frm files (and Drizzle has gotten rid of the .frm files, hooray), and c) privileges and other changes to the non-InnoDB data in…
