….e in MySQL 5.0) In short, if you use big BLOBS ( TEXT, MEDIUMBLOB, etc) (that allocated in external segment in InnoDB… database in trash state just executing update on row with blob and rolling back transaction twice ( on the same row) The… the end let me reiterate my points: – if you have BLOB/TEXT fields in your InnoDB-plugin schema, it is recommended…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 33 Comments
… the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size…
Comment: How to calculate a good InnoDB log file size
December 22, 2008 By 33 Comments
… the log group capacity yyyyy. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size…
Comment: Wanted: Better memory profiling for MySQL
May 21, 2008 By 4 Comments
Though I have a rough idea I’d love more insight into where memory is going, right now its just this big blob I hope never runs into swap 
I’ve only had to do it once but the only value I’ve had luck in reducing memory consumption was lowering innodb_buffer_pool_size.
Comment: MyISAM Scalability and Innodb, Falcon Benchmarks
October 15, 2007 By 10 Comments
… huge data load as well. In my case there were big blobs that got loaded up though they weren’t needed.
Post: Bug#12704861
November 20, 2011 By 1 Comment
… issue in tablespace extension. If the request to allocate a BLOB page leads to the tablespace being extended, crash recovery could… of a mini-transaction allocated (nonfree=TRUE) before storing the BLOBs, or freed (nonfree=FALSE) before committing the mini-transaction. btr…_FREE_CLUST_LEAF marker to the mini-transaction. btr_store_big_rec_extern_fields_func(): Add the parameter alloc_mtr, which…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… small tables, everything can reside within a single extent. For big tables, a secondary index reserves different extents from the clustered… 8100 bytes InnoDB will not allocate additional space for blobs, even if each blob is larger than 768. 2. InnoDB will allocate additional space outside of the page for _each_ blob (if we have 8 blobs 8xN bytes will be allocated) Question: How much…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… is another of the pre-beta tasks. Blob handling optimizations Falcon’s concept of blobs centers around jpegs, pdfs, and Word documents…€™t materialize blobs unless the blob is referenced and doesn’t rewrite blobs during an update unless the blob itself has changed. Blobs are also written asynchronously pre-commit to keep lots of big ugly…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… storing first 700 bytes or something like that from any blob/string in the page. Which gives you the nice surprise… outside of it. The other item with blobs – currently if I’m not mistaken blobs are stored each in its own “segment… to have more than one log flush thread. The other big lacking (especially as patch for it existed for years) is…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… in 14179 last record is stored with pointers to blobs to support very big 14180 records 14181 ******************************************************************************/ 14182 14183 static int 14184…_count) 14185 { … snip … 14268 cache->length=length+blobs*sizeof(char*); 14269 cache->blobs=blobs; 14270 *blob_ptr=0; /* End sequentel */ 14271 size=max(thd…
