[drupal-devel] MySQL HEAP-tables
Did someone experiment with MySQL's memory storage engine (HEAP tables)? If not, I'll add it to my TODO list. Sounds fun and from the looks, the cache table would be a good candidate ... See http:// dev.mysql.com/doc/mysql/en/memory-storage-engine.html for more information. -- Dries Buytaert :: http://www.buytaert.net/
I used to be wary of such esoteric features, since although I can have them at home, hosting would not allow them, specially for shared hosting environments. However, it seems that lately, hosting companies have been providing support for these extra storage engines, such as InnoDB and MEMORY/HEAP. If you are in doubt, check in PHPMyAdmin under "Storage Engines" and see what is listed there. So, yes, it is a valid option, and since it only affects table creation, it should have no impact on PostgreSQL or ANSI compatibility. On 9/12/05, Dries Buytaert <dries.buytaert@gmail.com> wrote:
Did someone experiment with MySQL's memory storage engine (HEAP tables)? If not, I'll add it to my TODO list. Sounds fun and from the looks, the cache table would be a good candidate ... See http:// dev.mysql.com/doc/mysql/en/memory-storage-engine.html for more information.
And reading further, its memory waste may be huge. It says:
MEMORY tables use a fixed record length format.
So even if we change the longtext and text in the cache table to be varchar, it will still be treated as char, and A LOT OF memory would be wasted. On 9/12/05, James Walker <walkah@walkah.net> wrote:
On 12-Sep-05, at 11:31 AM, Dries Buytaert wrote:
Sounds fun and from the looks, the cache table would be a good candidate
well, except for : MEMORY doesn't support BLOB or TEXT columns.
And reading further, its memory waste may be huge. It says:
MEMORY tables use a fixed record length format.
So even if we change the longtext and text in the cache table to be varchar, it will still be treated as char, and A LOT OF memory would be wasted.
And you cannot change it to (var)char, since cache entries mostly exceed the 256 chars length. Goba
I have been benchmarking HEAP-tables some time ago for myself and was quite disappointed. MyISAM seems to be extremely optimized when it comes to buffering, same should be for a good file system. -- Best regards, Thomas mailto:ThomasIlsche@gmx.de
participants (5)
-
Dries Buytaert -
Gabor Hojtsy -
James Walker -
Khalid B -
Thomas Ilsche