…need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 …should expect at least as good performance from O_DIRECT as from buffered mode ? It turns out …_ci Checksum: NULL Create_options: Comment: 1 row in set (0.02 sec) The table is approximately …
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…created 100.000 empty tables containing single integer column and no indexes and when ran SELECT * FROM tableN in the loop. Each table…file system on the SATA hard drive. MySQL 5.0.85 Created 100.000 tables…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
September 30, 2009 By 29 Comments
… shared tablespace (ibdata) file growing even when i have file_per_table and indeed all my tables are created correctly as separate files. when i occasionally do ‘insert into new_bigtable select * from bigtable… .ibd / .frm files and then put them on a new mysql instance. is there any way of avoiding the ibdata file from growing to…
Comment: MySQL Crash Recovery
January 30, 2007 By 30 Comments
Hi Is there any way to recreate a create statement from a table.frm file?, when the table.MYI has become corrupted. And it is so big, running analyze table or myisamchk takes days? table.MYD is 160GB and table.MYI is 80GB? Any input greatly appreciated (mysql 4.0.27) Thanks
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…Create_options: Comment: 1 row in set (0.62 sec) Lets see what table … check size of on disk file: -rw-rw—- 1 mysql mysql…frm Can’t say I’m impressed we have only about 2 times compression rate for this table…table scan query on the table changed from 5 min to about 4 minutes, less than table…
