[Original] compressed innodb table of MySQL 5.5

Source: Internet
Author: User

From 5.5, the INNODB engine can also be compressed like the MYISAM engine. Of course, the compressed table is okay. You should not INSERT or UPDATE it. DELETE doesn't matter. It's just MARK, and then batch DELETE it. This is the same as the BRIGHTHOUSE engine.

Of course, not all tables are suitable for compression and then reading. Application scenarios, data distribution, and hardware resources all restrict compression. At this time, the best way is to conduct stress testing to see if it is suitable for your own business. The following are some new features of the compressed table. 1. the compressed table is only valid for a single tablespace. Therefore, set the following parameters:Innodb_file_per_tableinnodb_file_format = Barracuda 2. Create Table OPTIONS.ROW_DATEFORMAT = COMPRESSED KEY_BLOCK_SIZE = (, 16.) depending on the distribution of the table data to be COMPRESSED. Simply put, you can use the same data to insert tables of different structures. After you finish viewing the size of the disk table, you will be OK. 3. Pay attention to another feature.If INNODB's compressed table is set, your INNODB_BUFFER_POOL_SIZE should be at least twice the previous size. Because two pages with different sizes but consistent data must be retained in the buffer pool. In this way, the memory overhead is increased.

This article is from "god, let's see it !" Blog, please be sure to keep this source http://yueliangdao0608.blog.51cto.com/397025/935513

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.