Comments on Jonathan Levin's Axioms: Compressed MyISAM is..

Useful, but not easy to use. For example, there i...

2010-03-18T13:55:19.782Z

Useful, but not easy to use.

For example, there is no SQL interface to myisampack. There is no locking which stops myisampack interfering with MySQL. The mmap() cannot be disabled (which will break 32-bit systems).

If you have < 2G data nothing matters much; if you have more, mmap will break on 32-bit systems.

It is very nice for some use cases. Now we just ne...

2010-03-17T23:32:33.772Z

It is very nice for some use cases. Now we just need to convince MySQL to show it some love and start improving it again.

I was pondering the same and raised the issue in #...

2010-03-17T21:08:16.060Z

I was pondering the same and raised the issue in #mysql, especially after I read the following in the mysql documentation comments: "The mmap() behaviour described here is not optional and may cause a 32-bit server to run out of address space sooner than it otherwise would.

Therefore I strongly recommend factoring address space usage into any feasibility study of myisampack on 32-bit systems."

I was then pointed at the following bug report, but I am not sure how the fix really addresses the issue:
http://bugs.mysql.com/bug.php?id=37408