Summary of articles about the usage and differences of MyISAM

1. Architecture design 11. The master and slave servers can use different storage engines. InnoDB is used on the Master, taking advantage of advanced features such as transactions and row-level locks. MyISAM is used on the Slave, which has better read performance, saves memory, and is easy to back up. You can also use different data types respectively, such as varchar on the Master and char on the Slave. This not only saves space, but also makes use of the static table features of MyISAM. 2. In the M-S-Muti Slave solution, the relay slave can also use the BlackHole storage engine. The BlackHole storage engine only records logs and does not write data. Using this feature can greatly improve the performance of relay logs. However, this solution does not support Replication under GTIDs, because BlackHole can only be used with binary logs in StateMent format, and both Row and Mixed formats are not available. 3. In the design of separation of reading and writing, the master-slave server can adopt different indexing schemes. Master can only retain indexes such as primary keys or unique indexes that guarantee data relationships. Salve does index optimization for queries.

1. Recommended 10 MyISAM source code examples (collection)

##Introduction: 1. Architecture design 11. The master and slave servers can use different storage engines. InnoDB is used on the Master, taking advantage of advanced features such as transactions and row-level locks. MyISAM is used on the Slave, which has better read performance, saves memory, and is easy to back up. You can also use different data types respectively, such as varchar on the Master and char on the Slave. This not only saves space, but also makes use of the static table features of MyISAM. 2. In the M-S-Muti Slave solution, the relay Slave can also use the BlackHole storage index...

2. Explanation of the six major differences between the Mysql storage engine InnoDB and Myisam

Introduction: The difference in the composition of MyISAMInnoDB: Each MyISAM is stored in three files on the disk. The name of the first file begins with the name of the table, and the extension indicates the file type. The .frm file stores table definitions. The extension of the data file is .MYD (MYData). The extension of the index file is .MYI (MYIndex).

3. Analysis of the differences between the Mysql storage engine InnoDB and MyISAM

Introduction: I have reprinted an article before about how to choose mysql storage engine. Today I saw a summary on the Internet, which is not bad!

4. Mysql replaces the MyISAM storage engine to share the sample code recorded for Innodb operations

Introduction: The editor below will bring you a summary of the operation records of MySQL replacing the MyISAM storage engine with Innodb. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor to take a look

5. Introduction to the basic differences between high-performance MySQL-storage engine MyISAM and InnoDB

Introduction: This blog post mainly summarizes the differences between MyISAM and InnoDB. InnoDB and MyISAM are the two most commonly used table types when using MySQL. These two tables Each type has advantages and disadvantages, depending on the specific application. The basic differences are: (1) The MyISAM type does not support advanced processing such as transaction processing, while the InnoDB type supports transactions. (2) InnoDB supports data row locking; MyISAM does not support row locking and only supports locking the entire table. What needs to be noted here is that the row lock of the InnoDB table is not absolute. If you are executing an SQ

6. MySQL Advanced Nine - MyISAM Table Lock (Shared Read Lock)

Introduction: Locks are a mechanism for computers to coordinate concurrent access to a resource by multiple processes or threads. In a database, data is also a resource shared by many users. How to ensure the consistency and effectiveness of data access is a problem for all databases. Lock conflicts are also an important factor affecting the performance of concurrent access to the database. From this perspective, locks are particularly important and complex for databases.

7. Introduction to the MyISAM storage engine of Mysql storage engine

Introduction: The tables of the MyISAM storage engine are in the database, and each table is stored as three physical files named after the table name.

8. The difference between MyISAM and InnoDB

# #Introduction: MySQL has a variety of storage engines, MyISAM and InnoDB are two commonly used ones. Here are some basic concepts about these two engines (not an in-depth introduction).

9. What is the difference between MyISAM and InnoDB of mysql? How to optimize MYSQL database?

Introduction:: This article mainly introduces the difference between MyISAM and InnoDB of mysql? How to optimize MYSQL database? , students who are interested in PHP tutorials can refer to it.

10. realtek high definition audio Summary of the analysis of the differences between InnoDB and MyISAM in mysql

Introduction: realtek high definition audio :realtek high definition audio Summary of the analysis of the differences between InnoDB and MyISAM in mysql: MyIASM is a new version of the IASM table, with the following extensions: Binary level portability. NULL column index. There is less fragmentation than ISAM tables for variable-length rows. Large files are supported. Better index compression. Better keys? Statistical distribution. Better and faster auto_increment handling. The following are some details and specific implementation differences: 1. InnoDB does not support FULLTEXT type indexes. 2.

##11.

The difference between MyISAM and InnoDB

Introduction:: The difference between MyISAM and InnoDB: The difference between MyISAM and InnoDB MyISAM stores three files on the disk. The first file name starts with the table name, and the extension indicates the file type. The extension of the frm file storage table definition data file is .MYD (MYData). The extension of the index file is .MYI ( MYIndex) disk-based resources are the InnoDB table space data files and its log files. The size of the InnoDB table is only limited by the size of the operating system file, generally 2GB. Transaction processing MyISAM type tables emphasize performance, and their execution speed is higher than InnoD

12.

innodb 2 myisam php

Introduction: innodb 2 myisam php

13.

Summary of the difference analysis between InnoDB and MyISAM in mysql_PHP tutorial## Introduction: Summary analysis of the difference between InnoDB and MyISAM in mysql. MyIASM is a new version of the IASM table with the following extensions: Binary level portability. NULL column index. There is less fragmentation than ISAM tables for variable-length rows. Large files are supported. Better index compression

14.

The data table is in MyISAM format, what does it mean? The data table is in MyISAM format. What does it mean? -Database related-PHP teaching_PHP tutorial

Introduction: The data table is in MyISAM format. What does it mean? The data table is in MyISAM format. What does it mean? -Database related-PHP teaching. MyISAM table. The MyISAM storage format, which has been the default type in MySQL since version 3.23, has the following characteristics: ■ If the operating system itself allows larger files, the files are stored

15.

What is the difference between MyISAM and InnoDB of mysql? How to optimize MYSQL database? , myisaminnodb_PHP tutorial

Introduction: What is the difference between MyISAM and InnoDB of mysql? How to optimize MYSQL database? ,myisaminnodb. What is the difference between mySQL's MyISAM and InnoDB? How to optimize MYSQL database? , myisaminnodb The basic differences between MyISAM and InnoDB 1. InnoDB does not support FULLTEXT type indexes. 2. InnoDB is not guaranteed

16. Update and select table lock issues (mysql myisam)

Introduction ：Update and select table lock issues (mysql myisam)

17. The difference between MySQL's storage engine MyISAM and innoDB, how to deal with it

Introduction: The difference between MySQL's storage engine MyISAM and innoDB. How do you usually choose these two types in specific projects? ------Solution--------------------MyISAM: This is the default type, which is based on the traditional ISAM type. ISAM is Indexed Sequential Access Method ( The abbreviation of indexed sequential access method), which is a standard method for storing records and files. Compared with other storage methods

18. Summary of the analysis of the differences between InnoDB and MyISAM in mysql

Introduction: Summary of the difference analysis between InnoDB and MyISAM in mysql. MyIASM is a new version of the IASM table with the following extensions: Binary level portability. NULL column index. There is less fragmentation than ISAM tables for variable-length rows. Large files are supported. Better index compression

19. The difference between MySQL’s storage engine MyISAM and innoDB, how to deal with it

Introduction: The difference between MySQL's storage engine MyISAM and innoDB. How do you usually choose these two types in specific projects? ------Solution--------------------MyISAM: This is the default type, which is based on the traditional ISAM type. ISAM is Indexed Sequential Access Method ( The abbreviation of Indexed Sequential Access Method), which is a standard method for storing records and files. Unlike other storage methods

20. The data table is in MyISAM format. What does it mean? The data table is in MyISAM format. What does it mean? -Database related-PHP tutorial

#Introduction: The data table is in MyISAM format. What does it mean? The data table is in MyISAM format. What does it mean? -Database related-PHP teaching. MyISAM table. The MyISAM storage format, which has been the default type in MySQL since version 3.23, has the following characteristics: ■ If the operating system itself allows larger files, the files are stored

21. What is the difference between MyISAM and InnoDB of mysql? How to optimize MYSQL database? , myisaminnodb

Introduction: What is the difference between MyISAM and InnoDB of mysql? How to optimize MYSQL database? ,myisaminnodb. What is the difference between mySQL's MyISAM and InnoDB? How to optimize MYSQL database? , myisaminnodb The basic differences between MyISAM and InnoDB 1. InnoDB does not support FULLTEXT type indexes. 2.InnoDB is not guaranteed

22. MYSQL A brief discussion of MyISAM storage engine

Introduction: used in mysql The most common storage engines are innodb and myisam. As the default storage engine of Mysql, myisam is worth learning. The following is my understanding of myisam mentioned in the book "High Performance MYSQL". Please give me your advice

##23.

Solution to the read-write mutex problem of Mysql (MyISAM)

Introduction: Recently, due to the increase in database read requests, serious read-write locks have appeared. Problem, due to the separation of master and slave, the master server quickly completed the write operation, but due to a large number of select queries, the slave database will be severely blocked by these updates and inserts from the master-slave synchronization, and finally caused all Mysql slaves to Library load increases rapidly.

24.

Errors and solutions when converting MySQL from MyISAM to InnoDB

Introduction: It turned out that I was using In order to install it, when setting the database usage (as shown in Figure 1), I followed the official advice of discuz and selected Non-Transactional Database Only (only supports non-transactional databases of the MyISAM data engine). Use the MyISAM database, which has not been covered yet. InnoDB is required, so I plan not to load the INNODB engine directly.

25. Difference analysis of MySQL InnoDB and MyISAM data engines

Introduction: InnoDB and MyISAM are the two most commonly used tables in MySQL types, each with advantages and disadvantages, depending on the specific application. The basic difference is: the MyISAM type does not support advanced processing such as transaction processing, while the InnoDB type supports

[Related Q&A recommendations]:

myisam - About the fixed-length table of mysql

mysql - What is the most reliable way to obtain the new id of Auto_increment under myisam?

mysql - How does MYISAM ensure data integrity

php - MySQL storage engine

mysql MyISAM concurrent insert?

The above is the detailed content of Summary of articles about the usage and differences of MyISAM. For more information, please follow other related articles on the PHP Chinese website!