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

  • 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.

主站蜘蛛池模板: 循化| 万载县| 璧山县| 汽车| 湘阴县| 监利县| 分宜县| 睢宁县| 邯郸市| 长宁县| 岗巴县| 确山县| 襄汾县| 红原县| 嘉鱼县| 喜德县| 江都市| 沁阳市| 栾城县| 铁岭县| 鄂州市| 永城市| 介休市| 仙桃市| 江门市| 洱源县| 华阴市| 娱乐| 吴江市| 舞钢市| 乌拉特后旗| 凤阳县| 郑州市| 登封市| 夹江县| 曲水县| 偃师市| 海安县| 类乌齐县| 阿瓦提县| 西昌市|