Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

myisam和innodb的选择？_MySQL

WBOY
Release： 2016-06-01 14:01:17
Original
860 people have browsed it

库中有七八个表数据会达百万甚至千万级，大表都已经做了分区，5.1版本的

　　其他表都十万可能都不到，

　　大数据表的update和insert的操作很频繁，

　　用什么样的引擎会是对表的操作速度（特别是对所有表的select）比较有利？

　　大数据表用innodb其他用myisam可不可取呢？myisam和innodb分别适用什么情况下呢？两个混用有什么后果没？

　　小弟对Mysql认识太浅，身边无人可问，查了好久资料还没完全弄清引擎的具体适合情况，久闻此地藏龙卧虎，就来请教

　　ENGINE可以混用的。如果你的大数据表更新很频繁，建议用innodb,这个是基于行锁定的。myisam是基于表锁定的。这意味着如果你的UPDATE，INSERT并发很多的话，会有性能问题。myisam是针对90%以上是读的情况下设计的。

　　在并发量大的时候还是用INNODB来的好

Related labels：
insert update data sheet
source：php.cn
Previous article：利用分区和负载均衡获得更大更好的MySQL数据库_MySQL Next article：MySQL中InnoDB和MyISAM类型的差别_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1872
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
2039
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1715
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1616
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1629
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template