… keep max_prepared_stmt_count very low. Prepared Statements and Blob Data If you’re want to get memory consumed by… Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables. You can also use similar technique with innodb_file_per_table. However you can’t control growth of Innodb system…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dat` blob, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `compressed_row` ( `id…(1000) -> BLOB for the intentions of using compress() ) compressed_row (The row format being set to compressed, ensure you have innodb_file… disk level is already critical and the originating table is MyISAM there may be data loss if there is not enough…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… to temporary tables – BLOB/TEXT columns are not supported with MEMORY storage engine so must use on disk MyISAM temporary table. What…(10) unsigned NOT NULL, `c` char(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 mysql> select * from gt limit 5; +——-+——————————————+ | i… table. Do not forget about it especially if running only Innodb tables so you may think there is no use for…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 16, 2007 By 117 Comments
I’m curious whether you’ve run any benchmarks comparing InnoDB vs. MyISAM when queries are being done at the same time… the improvement we expected. We ended up taking advantage of MyISAM‘s ability to do simultaneous select/creates if the table… going on pretty much continuously, and the rows contained several blobs.
Comment: MyISAM Scalability and Innodb, Falcon Benchmarks
October 16, 2007 By 10 Comments
… in this case there is no blobs so both Innodb and MyISAM will need to read full rows. Innodb has advantage doing join via…
Comment: MyISAM Scalability and Innodb, Falcon Benchmarks
October 15, 2007 By 10 Comments
Unlike InnoDb, MyISAM loads up the entire row because it may need ‘name’. … data load as well. In my case there were big blobs that got loaded up though they weren’t needed.
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 6, 2007 By 22 Comments
… subselects… Even worse is that joins with blobs that are never referenced get loaded and discarded on MyISAM tables (not so in InnoDB).
