The advantages and disadvantages of InnoDB and MyISAM for MySQL storage engine analysis bitsCN.com are as follows:
◆ Does your database have a foreign key?
◆ Do you need transaction support?
◆ Do you need full-text indexing?
◆ What query mode do you often use?
◆ How big is your data?
Thinking about the above questions can help you find the right direction, but that is not absolute. If you need transaction processing or foreign keys,
Tags: log system Oat data file display capability one database SQ backup xxx1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. It is not transaction-safe, and foreign keys are not supported, and if a large number of Select,insert MyISAM are performed, the comparison is appropriate.2,
write (double write), adaptive hash (Adaptive Hash Index), pre-read (read ahead), etc.InnoDB uses aggregation (clustered) to store the data in the table, each of which is stored in the order of the primary key (if you specify a primary key without an explicit build table, InnoDB generates a 6-byte ROWID for each row, which is used as the primary key);The InnoDB table will have three hidden fields: In addit
Label:Operating system cluster size is generally 4K, and InnoDB page size is generally 16K, then it is possible that 16K pages are not stored in a continuous cluster, so that the scanning software will not scan out such a page. To solve this problem, we decided to add half-page scanning function to the software.In the first scan, all the page headers are correctly characterized, but the page with incorrect tail features is saved in a separate file and
InnoDB is a transaction-safe storage engine designed to draw on many Oracle architecture ideas, and in general, in OLTP applications, InnoDB should be the first storage engine for the core application table. InnoDB was developed by a third party Innobase Oy company and is now being acquired by Oracle, the founder of Heikki Tuuri, the Finnish Helsinki people, and
Next let's answer some questions:
◆ Does your database have a foreign key?◆ Do you need transaction support?◆ Do you need full-text indexing?◆ What query mode do you often use?◆ How big is your data?
Thinking about the above questions can help you find the right direction, but that is not absolute. If you need transaction processing or foreign keys, InnoDB may be a good method. If you need full-text indexing, MyISAM is usually a good choice because i
Next let's answer some questions:◆ Does your database have a foreign key?◆ Do you need transaction support?◆ Do you need full-text indexing?◆ What query mode do you often use?◆ How big is your data?Thinking about the above questions can help you find the right direction, but that is not absolute. If you need transaction processing or foreign keys, InnoDB may be a good method. If you need full-text indexing, MyISAM is usually a good choice because it i
Comparison between MyISAM and Innodb: bitsCN. comMyISAM and Innodb
Http://www.oschina.net/question/17_4248
Considerations for MySQL storage engine InnoDB, MyISAM, and row Lock2010-02-21 18:21 MyISAM is the default storage engine in MySQL. generally, not many people care about this. It is a tricky thing to decide what storage engine to use, but let's take a look a
[MySQL] talking about InnoDB storage engine bitsCN.com
[MySQL] about the InnoDB storage engine
InnoDB is a transaction-safe storage engine. it is designed based on a lot of Oracle architecture ideas. generally, in OLTP applications, InnoDB should be the first storage engine for core application tables.
pit X, changed to 1GB, and automatically extended Innodb_data_file_path = Ibdata1:1g:autoextend #如果不了解本选项, recommended set to 1, Can better protect data reliability, has certain influence on performance, but controllable innodb_flush_log_at_trx_commit = 1 #InnoDB的log buffer, usually set to 64MB is enough innodb_log_buffer_size = 6 4M #InnoDB redo log size, usually set 256MB is enough innodb_log_file_size =
MyISAM and InnoDB explain that InnoDB and MyISAM are the two most common table types when many people use MySQL. The two table types have their own advantages and disadvantages, depending on the specific application. The basic difference is that the MyISAM type does not support advanced processing such as transaction processing, while the InnoDB type does. MyISAM
MySQL study--mysql InnoDB Engine Backup tool One of the Xtrabackup (Install)Xtrabackup is a innodb to do data backup tools, Support Online hot backup (backup without affecting the data read and write), is a commercial backup tool InnoDB hotbackup a good alternative. Xtrabackup has two main tools: Xtrabackup, Innobackupex(1) Xtrabackup can only back up
To find the storage engine for a database:Show enginesShow variables like '%storage_engine% 'Change the engine of the database to change the configuration file/etc/my.cnfModify Default-storage-engine=innodb (the storage engine that needs to be changed), and then restart the databaseService mysqld RestartALTER TABLE engine=innodbThe storage engine is how to store the data, how to index the stored data, and how to update and query the data. Because the
concurrent user settings, and performance is degraded if it is above this number. In this case, it is recommended to set the Innodb_thread_concurrency parameter to 80 to avoid affecting performance;
If other apps are allowed on the DB server and you need to limit MySQL thread usage, you can set the number of threads that can be assigned to DB, but it is not recommended to run other applications on the DB, and this is not recommended, as this may result in the database not being optimally us
code ',' Data_name ' varchar (+) not NULL COMMENT ' data dictionary value ',PRIMARY KEY (' data_type ', ' Data_code '),KEY ' data_dict_dn ' (' data_name ') USING HASH) Engine=innodb DEFAULT Charset=utf8 comment= ' data dictionary table 'is hash, so we thought the hash index was created successfully.In fact, we are all fooled by MYSQL, we use the SHOW INDEXES from statement to retrieve the table index:SHOW INDEXES from Data_dict;Printing results:Back
Introduction to InnoDB and MyISAM: This is the default type. It is based on the traditional ISAM type, and ISAM is the abbreviation of IndexedSequentialAccessMethod (sequential access method with indexes, it is a standard method for storing records and files. compared with other storage engines, MyISAM has most tools for checking and repairing tables. myISAM tables can be pressed
Introduction to InnoDB and
the table was properly closed. If the--myisam-recover option starts the Mysqld,myisam table is automatically checked when it is turned on, the table is repaired if the table is improperly closed.
· If you run Myisamchk with the--update-state option, it is labeled as checked. Myisamchk--fast Only check those tables that do not have this flag.
· Myisamchk--analyze stores statistics for a partial key, as well as for the entire key.
· Myisampack can pack blobs and varchar columns.
MyISAM also suppo
records, 1.5G size, optimization time of about two minutes, optimized performance increased by 50%, and the size of the table to 1.4G, but as the table is frequently rewritten, about a day later back to the previous speed, so it seems to me is not worth it.Query CacheBecause each write operation Query Cache will be emptied, in addition to very special circumstances (large-volume reading, a small amount of writing, but even if this should also be multi-memcached) absolutely no need to use this,
MySQL database InnoDB Engine master-slave replication synchronization experience, mysqlinnodb
Recently, the company's MySQL architecture has been upgraded, from the original one-master-many slave to the DRBD + Heartbeat dual-master-many slave, and a new e-commerce website project is coming soon, DRBD + Heartbeat dual master and one slave are used. Because this process is different from the previous MyISAM engine, I will summarize my experiences here:
after each modification. The merge to change buffer may take several hours if the number of secondary index rows being updated is more. During the merge process, the disk's I/O increases and may cause a decrease in performance for other queries.The merge operation may also occur after a transaction commits. In fact, the merge operation may occur even after the instance is restarted. In memory, the change buffer takes up space in buffer pool, and on the physical disk, changes buffer is part of s
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.