… with records(ibdata1, *.ibd, disk image, etc.) and a table structure. Indeed, there is no information about the table structure in an InnoDB page… .frm files is not an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
…) innodb_file_per_table is OFF by default, which means all tables are in ibdata1. 2) if it was HW problem and ibdata1 was saved then ibdata1 should be valid, maybe with some corruption. The tables…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
1) innodb_file_per_table видимо по умолчанию, ибо в my.ini он отсутствует. 2) … достался мне так сказать в наследство 3) да, база в ibdata1 Поиски пути восстановления без наличия frm файлов не дали никаких…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
indapublic , Too little of information to be certain. What was innodb_file_per_table? What happened to the database? But if your database is still in ibdata1 (you can grep it to be sure) then the answer is closer to “yes”.
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… or several ibdata files. A well known innodb_file_per_table option brings the second one. Tables and system areas are split into different files. Usually system tablespace is located in ibdata1 file and every InnoDB table…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
So you’re running MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system) tablespace have grown dramatically from … it consumes all free space (or specified max size for ibdata1 file). “Good” thing is performance typically starts to suffer terribly well…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… and they lost the ibdata1 file, where all the table meta-data is stored. Fortunately, they were running with innodb_file_per_table so the data itself was available. What they could provide us was: all the tables ibd files (Nearly 200…
