… reading over the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in addition to …/mysqld: Incorrect information in file: ‘./mysql/servers.frm‘ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm‘ Running mysql_install_db under …
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… in between. So how to recover CREATE TABLE from .frm file ? Recovering from .frm for Innodb Table If we simply copy .frm file back to the database we… test]# cp /tmp/test_innodb.frm . cp: overwrite `./test_innodb.frm‘? y [root@test3 test]# mysql test; Reading table information for completion of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… lot of things like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non-blocking… also elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to read these, there… log is interesting and needs to be investigated. You might find that there are InnoDB tables whose .frm files exist but have been…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… table_definition_cache set to 1000. My understanding of this is that MySQL won’t revert to opening the FRM files to read the table definition, but we can see from strace: [pid 19876] open(“./db/t1.frm“, O_RDONLY… road to removing the FRM). That blog post is from 2008, almost three years ago to the day. Since we completely reworked how metadata…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… and switch .frm table definition files. For safety, I’d recommend to flush tables with read lock while switching .frm files. When and how it works: auto_increment (removing). Let’s have a simple table with auto_increment we want to get…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…frm files and all the MYD/MYI files…to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How to restore mydumper data: Load the schema file…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… that then have to be fixed. How to optimize the program without compromising data integrity is a constant question. Relative to maintaining performance, stability… means opening tables (reading a .frm file), which requires creating a THD. The code to create a THD in turn tries to acquire LOCK_plugin…
Comment: What to tune in MySQL Server after installation
January 30, 2009 By 118 Comments
…): Incorrect information in file: ‘./db1/access.frm‘ mysql> exit; mysqldump: Got error: 1033: Incorrect information in file: ‘./db1/access.frm‘ when using LOCK TABLES…/read.php?34,177212,234851#msg-234851 i’ll have to study a bit more deeper as to how to change the parameter innodb_log_file…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…information if file table.frm is perhaps my favorite one. How do you expect to decode from … so hard to discover this issue – storage engine which is specified in .frm file is …to tell you why operation could not be performed (read error, out of file descriptors etc). In fact you can run “perror X” to…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… 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… files, and InnoDB would have to be put into a state of constant “recovery,” and it would have to be modified to be available read… could be used for read queries. This can be done, of course. It’s just a matter of how hard it is…
