Php -- Notes: 0214_MySQL

Source: Internet
Author: User
Php-note 0214 1. MyISAM tables (mysql) cannot process transactions, so there is no additional overhead required by the transactional storage engine (such as InnoDB. Applicable to the following situations:

1> select intensive tables.

MyISAM filters a large amount of data quickly, even in high-traffic environments.

2> Insert intensive tables.

The concurrent MyISAM insert feature allows you to select and insert data at the same time. For example, you can manage mail or WEB server log data.

2. the static TABLE structure (xBLOB, xTEXT, or VARCHAR are not used) has high performance, but it must be at the cost of space. If dynamic TABLE structure is used, optimize table statements are often used, it sorts out the fragments of the table caused by moving variable-length fields.

3. INNODB is a robust transactional storage engine that uses dedicated buffer management (configurable) to introduce row-level locking and foreign key constraints. Applicable to the following situations:

1> update intensive tables.

Suitable for processing multiple concurrent update requests.

2> transactions.

3> automatic disaster recovery.

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.