… value before returning it as an object. As far as “blob size“, I think some common sense should be used. I haven…, but I imagine it’s related to MySQL’s block size, which I’m sure I’m under. Most JSON strings…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… each text/blob in the page and will allocate some space outside of the page. However: 1. if the total size of the row is less than 8100 bytes InnoDB will not allocate additional space for blobs, even if each blob is… is also very interesting question what happens for blobs larger than 16K – is exact size allocated or also segment based allocation is…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… but not worth storing on disk. No fixed cache size, but size range The trick in managing the row cache is maintaining… 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…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
…” which means having many blobs in the same row is going to be slow. For medium sized blobs it would be much better to merge them and store on the same segment and ie only store blobs over… all of modified tablespaces in the parallel. Multiple page sizes. One size does not fit all and for certain workloads 16K is…
Comment: Blob Storage in Innodb
February 17, 2010 By 13 Comments
… deploying a new server or increasing disk or logical volume size. If you split things into multiple subdirectories then you also… for indexing or searching. If you think you need multiple blob columns, then as Peter suggested, consider combining them into 1 blob and on the application side splitting up the blobs. That might not so easy either…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… in practice difference can be less. [-] Not fixed cache size, but size range This is minor one. Unlike you would typically see Falcon uses minimum and maximum sizes for row cache instead of single size, this is complicated. If I have 8GB… often. [+] Blob handling optimizations Jim loves BLOBs as his own child, so Falcon is optimized in Blob handling for example having direct blob writes…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If you’re using… temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory might be allocated. But… have unbound memory requirements retriving result sets from remove queries. Blobs may require 3x time of memory. This is important if…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… for the entire blob to be returned to the user. So imagine a blob that is 1 GB in size and you have 25 conncurrent requests for such a sized blob, innodb will need… this query. See: http://mysqlinsights.blogspot.com/2009/01/mysql-blobs-and-memory-allocation.html The people at pbxt have created…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… of difference. When it makes the difference is even larger blobs which can use less external pages. When compressed. Check this… some 50 times smaller 
Also note this less than 1MB blob takes about 1.5M this is because space allocation for… actually a strange decision for blobs as Blobs never grow and could be allocated to exact size. If Blob changes it is stored in…
Comment: Heikki Tuuri to answer your in depth Innodb questions
September 28, 2007 By 51 Comments
… each text/blob in the page and will allocate some space outside of the page. However: 1. if the total size of the row is less than 8100 bytes InnoDB will not allocate additional space for blobs, even if each blob is… additional space outside of the page for _each_ blob (if we have 8 blobs 8xN bytes will be allocated) Question: How much…
