… No Spinlocks Falcon does not use…stored but in random order). In my opinion this however should have been implemented outside of MySQL Storage Engine level for MySQL…Blob handling for example having direct blob writes to the database and probably some others. This would be very interesting to see how…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
…stored outside of the page (this behavior is version specific, see http://www.mysqlperformanceblog.com/2010/02/09/blob… data-dependent bugs like this one. Now, how can you work around this problem? Here …and you use MySQL‘s built in functions for handling this data. This approach, however, does have …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…performance” which is cool but it does not really tell you how exactly read_rnd_buffer_size …converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer to optimize data … Row pointers are stored in the sort_buffer, not the whole data selected Blob/Text columns are …
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
…to create columns as easy as it does serialized blobs. YMMV, but I’m a … can’t easily get statistics such as how often the parameter is specified or …error which caused an unindexed column to store the word broccoli as ‘brocoli’ [sic]. … all my tools I’m used to (mysql cli, etc). I then have to create…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… of partitioning stored procedures views and a lot of stuff. Think how much …MySQL Skills also would likely loose portability. If you look at MySQL 4.0 you could simply ask if person knows MySQL or does… top of MySQL or other databases. Other interesting development is Scalable Blob Streaming. This…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… using blob/text columns which force table creation on the disk because MEMORY storage engine does …://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html MEMORY table contents are stored in…how this issue was fixed (patch pending): ChangeSet@1.2311, 2006-11-16 04:11:16+03:00, ted@ted.mysql…
