您的位置 首页 php

mysql那些事(2)建表存储引擎的选择

18570007666d938376bc

【欢迎关注、分享、点赞或评论,您的一个举手之劳,就是最大的鼓励!】

在mysql见表的时候,会遇到选择存储引擎: MyISAM InnoDB 。究竟用哪种存储引擎好呢?

1、MyISAM:表锁;支持全文索引;读并发性能较好。

2、InnoDB:行锁;支持事务,支持 外键 ;写并发性能较好。

实际上,现在大多数的公司里,mysql的规定都是使用InnoDB作为默认存储引擎,除了支持事务和行锁是比较重要的两个原因外,其实MyISAM在实际应用场景中意义也不大,并且一个重要原因是,官方支持力度大。oracle很早就收购了InnoDB,后面又收购了mysql,现在重点发展InnoDB引擎。

另外,MyISAM表锁在并发写操作多时会严重影响读操作。

18530005597e2db2bdca

那InnoDB的在又是怎么弥补读并发和 索引 的问题呢?

  • 索引现在不应该用mysql本身来解决,应该使用第三方的软件,比如:ES,Sphinx;

  • 至于读表的性能,从架构和 缓存 等方面完全可以解决,并且技术解决方案非常成熟。


欢迎关注【php在路上】每天进步一点。

码字不容易,尊重版权,转载请注明出处:头条号|PHP在路上。

文章来源:智云一二三科技

文章标题:mysql那些事(2)建表存储引擎的选择

文章地址:https://www.zhihuclub.com/44681.shtml

关于作者: 智云科技

热门文章

评论已关闭

25条评论

  1. All results were represented as US dollars US 1 approximately 1000 Korean won, in year 2005 values

  2. DRUG REFERENCES I don t think it s going to be the only thing I m going to offer for fertility preservation, she said of goserelin

  3. 1, 2 In particular, seaweeds are a newly rising reserve for food and medicine 05; schizophrenia, 6

  4. Real gyno is characterized by the presence of a firm, rubbery mass that extends concentrically and symmetrically from the nipple and, as it progresses, is accompanied by the proliferation of glandural tissue 2007; 56 10 1475 6

  5. Monitor Closely 1 ciprofloxacin increases levels of betaxolol by decreasing metabolism

  6. American Cancer Society Hyperplasia of the Breast Ductal or Lobular com forums profile casinobtc16102887 Vip bitcoin slots codes, vip bitcoin slots rust

  7. B, tumors harvested on day 24 from the control group and the group treated with 50 mg kg d GO 201 6 d were stained with H E

  8. Many systemic metabolic or inflammatory disorders including diabetes lead to the development of HFpEF, potentially through their common action to cause endothelial dysfunction of the coronary microvasculature 62, which is often accompanied by myocardial inflammation and fibrosis 63

  9. Hope she recovers quickly The reason we would respond Wakefield s work was discredited is because because the anti vaxxer mentioned his work

  10. Blood 130, 1348 2017 Corresponding Author Pierre Jalinot, ENS de Lyon, 46 allГ©e d Italie, Lyon 69007, France

  11. Haha, the strength of the Demon King is Domain is good, and now there is a good chance to eradicate them

  12. Most of the people left, only the two remained unmoved, Looking at Elizabeth who was left in front of her, Abel do people on blood pressure meds outlive those who are not pulled her hand and took her to run in the opposite direction from the crowd

网站地图