官术网_书友最值得收藏!

  • MySQL 8 for Big Data
  • Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
  • 151字
  • 2021-08-20 10:06:10

Important notes about MyISAM tables

MyISAM supports full-text indexing, which can help in complex search operations. Using full-text indexes, we can index data stored in BLOB and TEXT data types. We will have a detailed look at full-text indexing in Chapter 3, Indexing your data for high-performing queries.

Due to low overhead, MyISAM uses a simpler structure, which provides good performance; however, it cannot help much for good performance when there is a need for better concurrency and use cases that don't fit the need for heavy read operations. The most common performance problem of MyISAM is table locking, which can stick your concurrent queued queries as it locks the table for any other operation till the earlier one is not executed.

A MyISAM table doesn't support transactions and foreign keys. It seems that because of these constraints, MySQL 8's system schema tables now use InnoDB tables instead of MyISAM tables.

主站蜘蛛池模板: 道孚县| 海原县| 军事| 塔城市| 宜章县| 荃湾区| 高密市| 高雄市| 汤原县| 观塘区| 开化县| 景泰县| 罗田县| 绥中县| 将乐县| 罗定市| 元谋县| 井研县| 略阳县| 裕民县| 广河县| 博客| 阿坝| 两当县| 灵山县| 万载县| 临沂市| 舒城县| 乌拉特前旗| 宝清县| 长白| 凤翔县| 广平县| 祥云县| 张家界市| 南靖县| 台中市| 绥滨县| 连平县| 鄂尔多斯市| 武定县|