June 19, 2013

Post: MySQL Crash Recovery

July 30, 2006 By 30 Comments

… in Innodb dictionary but .frm not created or not completely written. Partially written .frm files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option…

Filed Under: Insight for DBAs Tagged With: , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql 213909504 Feb 20 15:55 dir_test_innodb.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How much space does empty Innodb table take ?

December 16, 2008 By 7 Comments

…) Check out files (using Innodb File Per Table) -rw-rw—- 1 mysql mysql 8578 Dec 16 20:33 test_innodb.frm -rw-rw—- 1 mysql mysql 98304 Dec 16 20:33 test_innodb… the file size also jumps significantly (to 9MB): -rw-rw—- 1 mysql mysql 8578 Dec 16 20:58 test_innodb.frm -rw-rw—- 1 mysql mysql 9437184…

Filed Under: Insight for DBAs Tagged With:

Post: Add an option to Fail on Innodb Initialize failure, Please ?

October 11, 2007 By 9 Comments

… in MySQL server Error Logs but the error message accessing Innodb tables is also very obfuscated: error : Incorrect information in file: ‘./prod/user.frm… tell you Innodb (or for that sake any other Storage Engine) failed to initialize ? This error suppose to mean .frm file is corrupted…

Filed Under: Insight for DBAs Tagged With:

Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)

December 22, 2011 By 5 Comments

… can set some InnoDB options! I’m going to try the obvious first: innodb-flush-method, sync-frm and innodb-flush-log-at-trx… libeatmydata performance. I also want to disable syncing of the FRM file to disk and set log flushing to happen as infrequently… is less than my initial test with MySQL, probably due to not writing and syncing FRM files. If I run the same program…

Filed Under: MySQL Tagged With: , , , , ,

Post: MySQL Error Message Nonsenses

March 16, 2008 By 7 Comments

… to discover this issue – storage engine which is specified in .frm file is not available and give user friendly error message. Another… have some kind of strange file system/OS error until you run perror: [pz@sl1 ~]$ perror 150 MySQL error code 150: Foreign… you have too InnoDB: many active transactions running concurrently? I hope with pluggable storage engine interface Sun/MySQL spends some time to…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By 8 Comments

…. This will rsync a copy of all the frm files and all the MYD/MYI files. It then does a second rsync while… sub-second. Even with innodb only this can greatly cut down on the lock time by syncing the frm files. Enable –slave-info… and slave Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL I discuss S3 here…

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

… MyISAM files for distinct parts of the table. That was much faster and would complete within a day. Then, while the Innodb… a file is the first byte of the first row… So we should be able to concatenate these files. Let’s see. mysql…@django:/var/lib/mysql/test# ls test_concat.frm test_concat.MYD test_concat.MYI test_concat_part.frm test_concat_part.MYD…

Filed Under: MySQL

Post: The Doom of Multiple Storage Engines

May 8, 2010 By 22 Comments

… storage engine. Synchronization The top level on MySQL side, such as .frm files and binary log files has to be synchronized with storage engine… SQL level table locks and using Innodb internal data dictionary instead of Innodb files. We would use Innodb transactional log for replication (which could…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Limitations Part 2: The Binary Log

October 23, 2010 By 11 Comments

… 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 MySQL were… would need to be a mechanism of transporting the log files, and InnoDB would have to be put into a state of…

Filed Under: Insight for Developers, MySQL Tagged With: ,
« Older Posts
Newer Posts »