Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This morning I was introduced to the concept of compressing a database cache to allow a bigger cache in a given amount of RAM. I understand Microsoft SQL 2008 offers this functionality.

I was wondering if there is similar functionality available for MySQL?

share|improve this question
    
Version "8" is SQL Server 2000 (9 = SQL 2005, 10 = SQL 2008). SQL Server does not deliberately compress in cache: only if the data on disk is compressed explicitly using the new features in SQL Server 2008 –  gbn Jul 3 '09 at 6:19
    
Oops - I meant SQL 2008, not version 8. I'll edit the post. –  Brent Jul 3 '09 at 20:06

2 Answers 2

up vote 1 down vote accepted

i'm affraid it does not have.

it can compress data while replicating...

.. and there is new innodb storage plugin that does data compression.

but not in ram. up to my knowledge.

but if you deal with blobs - just store them compressed [ using mysql function or even your external application ] - i do it in one of projects. in this way data cached in ram and stored on disk is compressed; in my case it's role of application layer to decompress it.

share|improve this answer

It is dependent on the engine. Each engine implements its own cache (unless you count the query cache, which is not really useful in most cases).

Engines which use compression and have their own block caching system, for example InnoDB-plugin or Falcon, will probably do this automatically. That's because they cache in the format that the blocks are stored on disc, which means compressed.

The HEAP (in-memory) engine does not do compression (in fact, the standard HEAP engine is very inefficient, it doesn't support variable-length rows)

Engines which use the OS's cache will cache in whatever form they keep the data on the disc, for example, the Archive engine (which uses compression on-disc) will therefore keep compressed blocks in the OS's cache.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.