MySQL Forums
Forum List  »  Partitioning

Re: Wether is it possible to compress partitioned MyISAM tables?
Posted by: Rick James
Date: June 03, 2009 11:30PM

As for the question you asked -- I don't know. Sorry, I like to think out of the box; here goes...

Maybe you need Achive instead of MyISAM.

Better yet, look at InfoBright. It promises very fast load speeds, 10x data compression, and good ad hoc query performance. (And, I'm not quoting only the company spokesperson.)

Also -- consider inet_aton() to convert IP addresses to INT UNSIGNED. Now you are using up to 16 bytes; with that it would be 4 bytes.

And consider the other VARCHARs -- are there compression tricks for them? Do they need to be UTF8? (IP address certainly did not need to be.)

And TIMESTAMP is 4 bytes -- half the size of DATETIME, which is 8.

Smaller --> more cacheable --> faster.

Also, seriously look at summarizing the data (by the hour? minute?) and only storing the summaries. Everything runs faster then. And much smaller.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Wether is it possible to compress partitioned MyISAM tables?
3590
June 03, 2009 11:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.