June 19, 2013

Post: Recovering CREATE TABLE statement from .frm file

… 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: 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…