… something in its data dictionary so it allows MySQL to succeed displaying .frm file contents: mysql> create table test_innodb(i int) engine… sec) mysql> Aborted [root@test3 test]# cp /tmp/test_innodb.frm . cp: overwrite `./test_innodb.frm’? y [root@test3 test]# mysql test; Reading… .MYD files for the table to make it work: [root@test3 test]# touch test_myisam.MYI [root@test3 test]# touch test_myisam.MYD…
Post: Recovering CREATE TABLE statement from .frm file
Filed Under: Insight for DBAs Tagged With: InnoDB, MyISAM, Production
Post: The tool I've been waiting for years
… Mbytes in core for 2 files; 12070.50 pages, 47.2 Mbytes per file. [root@DB01 mysql]# perl /tmp/fincore –justsummarize ib_logfile0 page… -h performance_log_080319.MYD 229M performance_log_080319.MYD [root@DB01 logs]# perl /tmp/fincore –justsummarize performance_log_080319.MYD page size: 4096…
Filed Under: Insight for DBAs Tagged With: Operating Systems

