…; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A… truth though file name is wrong – there should be test_myisam.MYI or test_myisam.MYD in the error message. The file with… .MYD files for the table to make it work: [root@test3 test]# touch test_myisam.MYI [root@test3 test]# touch test_myisam.MYD…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
… out that the MyISAM files have no headers which make them difficult (read almost impossible) to locate on a drive with tools like ext3grep. No headers… that means the first byte of byte of a file…@django:/var/lib/mysql/test# cat test_concat_part.MYD >> test_concat.MYD root@django:/var/lib/mysql/test# myisamchk -rq test…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… will rsync a copy of all the frm files and all the MYD/MYI files. It then does a second rsync while under a global lock… WITH READ LOCK” –compress, compresses tables per file and should typically be enabled by default. The time needed to uncompress is not a… are due to problems with “FLUSH TABLE WITH READ LOCK”. Namely when a select is blocking the flush from completing and queuing…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… there is a “tail” of pages which just were not removed from the cache yet. As Innodb does not read logfile unless… 1 file; 497.00 pages, 1.9 Mbytes per file. [root@DB01 logs]# du -h performance_log_080319.MYD 229M performance_log_080319.MYD….MYD page size: 4096 bytes 28415 pages, 111.0 Mbytes in core for 1 file; 28415.00 pages, 111.0 Mbytes per file…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…compression rate I also run gzip requests_061111.MYD and I got file which as about 520MB in size – … – this would take 1250MB so Archive does compress a bit better than myisampack. I also checked how … it as difference could be due to larger read_buffer_size used by MyISAM. Summary: Archive storage …
