… MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for the BLOB/TEXT columns which would make… of server side vs client size compression depends on the queries you have. If you just retrieve these BLOB/TEXT columns for say… better because much fewer rows required external storage now. The BLOB/TEXT column compression is not for all workloads. When your database…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… InnoBD handles blobs/text fields (needs more info) According to the documentation, InnoDB put first 768 chars of each text/blob in the page… 8100 bytes InnoDB will not allocate additional space for blobs, even if each blob is larger than 768. 2. InnoDB will allocate… a 3x performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the checkpointing rate…
Post: Trailing spaces in MySQL
November 27, 2006 By 7 Comments
… you mind trailing spaces stored choosing VARCHAR vs CHAR in addition to fixed length vs dynamic level rows and space spent for… “a “=”a”=”a ” for all textual column types – CHAR, VARCHAR, TEXT. BLOB is exception it will preserve trailing spaces and use them…
Comment: How much overhead is caused by on disk temporary tables
April 21, 2008 By 26 Comments
Right. I should again check tmpfs vs heap table to see how it works. In general of … different direction – there is a patch from Ebay to support BLOB/TEXT in memory tables and there is Maria comming which will…
