June 18, 2013

Post: Performance gotcha of MySQL memory tables

… instead of BTREE which makes indexes unusable for prefix matches or range lookups. This is however not performance…per second while converting table to MyISAM I get about 600 deletes per second and about …do all the changes directly in memory. MyISAM however had to perform number of random writes to …