3.3. Tuning InnoDB Compression

Most often, the internal optimizations in InnoDB described in a later portion of this section, ensure that the system runs well with compressed data. However, because the efficiency of compression depends on the nature of your data, there are some factors you should consider to get best performance. You need to choose which tables to compress, and what compressed page size to use. You may also want to adjust the size of the buffer pool based on run-time performance characteristics such as the amount of time the system spends compressing and uncompressing data.


User Comments
Sign Up Login You must be logged in to post a comment.