June 19, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

…: Incorrect information in file: ‘./mysql/servers.frm‘ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm‘ Running mysql_install_db under strace… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…

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

Post: How to recover table structure from InnoDB dictionary

April 22, 2013 By 4 Comments

… about the table structure in an InnoDB page. Normally we either recover the structure from .frm files or take it from some… .frm files over taken from backups. But in some cases even .frm files is not an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed…

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

Post: Understanding the maximum number of columns in a MySQL table

April 8, 2013 By 5 Comments

… limit is, we must delve further into the FRM file. What is an FRM file? It’s the FoRM file from UNIREG… can create. If you try setting the storage engine to InnoDB however, you will get an error message! The exact error… of 1,000 columns. This is the code from ha_innodb.cc that enforces that limit: if (form->s->fields > 1000…

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

Comment: How to recover table structure from InnoDB dictionary

May 8, 2013 By 4 Comments

1) innodb_file_per_table видимо по умолчанию, ибо в my.ini … 3) да, база в ibdata1 Поиски пути восстановления без наличия frm файлов не дали никаких результатов. Можете хотя бы подсказать начало…

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

Post: Recovering CREATE TABLE statement from .frm file

December 17, 2008 By 5 Comments

… 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_innodb(i int) engine=innodb; Query OK, 0 rows affected (0.06 sec) mysql> Aborted [root@test3 test]# cp /tmp/test_innodb.frm . cp: overwrite `./test_innodb.frm…

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… 16:09 seo_test_innodb.frm -rw-rw—-. 1 mysql mysql 37748736 Feb 20 16:29 seo_test_innodb.ibd By comparison, this…

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

… 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.ibd So we get… Dec 16 20:58 test_innodb.frm -rw-rw—- 1 mysql mysql 9437184 Dec 16 21:06 test_innodb.ibd If you do…

Filed Under: Insight for DBAs Tagged With:

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… Innodb could be removed by doing: ALTER TABLE table_name ENGINE=Innodb; This, of course, rebuilds the whole table based on the .frm table definition and removes the existing index in Innodb, which…

Filed Under: MySQL

Post: MySQL opening .frm even when table is in table definition cache

November 21, 2011 By 8 Comments

…] close(32) = 0 <0.000012> [pid 19876] open(“./db/t2.frm“, O_RDONLY) = 32 <0.000014> [pid 19876] read(32, “”…, 10…] close(32) = 0 <0.000012> [pid 19876] open(“./db/t3.frm“, O_RDONLY) = 32 <0.000014> [pid 19876] read(32, “”…, 10… twice – in InnoDB itself and in the table_definition_cache). Further reading: MySQL Forge Internals document on the FRM file format Stewart…

Filed Under: MySQL

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

October 11, 2007 By 9 Comments

… MySQL does not stop if Innodb storage engine failed to initialize but starts properly… just having Innodb tables unavailable. I honestly do… 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…

Filed Under: Insight for DBAs Tagged With:
« Older Posts