… suggest reading over the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in addition to the… information in file: ‘./mysql/servers.frm‘ Running mysql_install_db under strace, I saw that it was getting a lot of “bad file descriptor” errors. I was able to…
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…; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…’re discussing a 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… elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to read these, there’s a… 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… Drizzle), produce a CREATE TABLE statement that took over four minutes to execute and get a more complete view of how the Storage Engine…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… then have to be fixed. How to optimize the program without compromising data integrity is a constant question. Relative to maintaining …reading a .frm file), which requires creating a THD. The code to create a THD in turn tries to acquire LOCK_plugin! Unfortunately a thread hangs if it tries to…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…’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…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…files e.g. actor.frm and actor.ibd. The annoying thing about .ibd files you can’t easily copy the an .ibd file to… a…to modify space_id in InnoDB dictionary once than in every InnoDB page. How…to start with error: InnoDB: Reading tablespace information from the .ibd files… InnoDB: Error: trying to…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…a copy of all the frm files and all the MYD/MYI files. It then does a second rsync while under a…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…
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….com/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
…file table.frm is perhaps my favorite one. How do you expect to…to discover this issue – storage engine which is specified in .frm file…to tell you why operation could not be performed (read error, out of file descriptors etc). In fact you can run “perror X” to… not excited to see there is a limit as …
