…are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_…for given thread, however if table will perform complex operations such as full table scans, …requirements retriving result sets from remove queries. Blobs may require 3x time of memory. …
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… something which can’t really be changed in many cases. Performance problems tend to appear then application is in production Ordered… would emphasize it in current Limits section though. Isolation Modes: Innodb, Oracle, PostgreSQL also support MVCC but frequently offer it in… may throw an error. Blob Handling: Just regarding your comment about blob materialization – Innodb also will only read the blob if it is accessed…
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
…serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the …operations like adding a secondary index on an InnoDB table require the whole table to be rebuilt …loss in functionality. You can no longer easily perform aggregation functions on the data (MIN, MAX, AVG)….
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… need to be aware that Archive does not have good performance. e.g. mysql> select id from archive_table order by…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
…about prepared statements. These do not neccesary provide performance beneft but they may, they also have other… Avoid SQL Injection Save memory on handling blobs There are also drawbacks and chewats of … text not only “Execute” but in SHOW INNODB STATUS you would still see statements without actual …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… better use for memory available. innodb_additional_mem_pool_size This one does not really affect performance too much, at least on… needs. innodb_log_file_size Very important for write intensive workloads especially for large data sets. Larger sizes offer better performance but…. If you have update activity spikes however or work with blobs a lot you might want to increase it. Do not…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…ENGINE INNODB STATUS. Bug fixed #1017192 (Sergei Glushchenko). The server could crash when executing an INSERT or UPDATE statement containing BLOB …fixed #1083058 (Laurynas Biveinis). Upstream changes made to improve InnoDB DROP TABLE performance were not adjusted for XtraDB. This could cause server…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… offset by keeping myisam_sort_buffer_size low, but then performance would suffer. Prepared Statements Number – Happily now there is a… keep max_prepared_stmt_count very low. Prepared Statements and Blob Data If you’re want to get memory consumed by… Saturation Both Innodb and MyISAM have hotspots and having few connections which use appropriate operations heavily you can reduce system performance beyond…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… memory. In general PBXT seems to be very optimized for Blobs handling and handling long rows in general. Also worth to… in terms of performance properties and transaction implementation details Falcon is unlikely to be easy drop-in replacement for Innodb but for… if performance will be adequate. Solid also has clustering by primary key and unlike Innodb has key compression (one of major Innodb problems…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… which needs to be put to temporary tables – BLOB/TEXT columns are not supported with MEMORY storage … GROUP BY results sorted – it can significantly improve performance in some cases. First I run the query …Do not forget about it especially if running only Innodb tables so you may think there is no …
