…23.59G … Locator Size Speed Form Factor Type Type Detail …mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…iops unaligned -vs- …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… rows – quite possible scenario for MyISAM tables. Now if we … full table scan vs range scan by index: mysql> select count(pad) from large; +————+ | count…may affect index scan/range scan speed dramatically. The rows referenced … are also clustered keys in Innodb which combine index access with…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
November 7, 2007 By 117 Comments
…InnoDB vs MyISAM for insertion queries for up to 100 threads (see presentation “Measuring MySQL Server Performance for the Sensor Data Stream Processing” at MySQL User Conference 2006. Unless you have very short records (less than 200 bytes) MyISAM outpreforms InnoDB for insertion speed. …
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… overhead of DRBD. If you’re using MySQL with Innodb (and running MyISAM with DRBD makes little sense anyway)…So overhead can vary a lot depending on the speed of the disk subsystem and network. If you… network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be well…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…not simply the case of 32 bytes vs 4 bytes for key value – if… fixed in MySQL 5.1 Data Clustering This again applies to Innodb tables aspect … was rather lookup by primary key speed. Lookup speed can be similar or can … here they are: I’ve created MyISAM tables containing just integer auto_increment …
