- 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.
- Vue.js設計與實現
- Amazon S3 Cookbook
- Python數據挖掘與機器學習實戰
- Building a Quadcopter with Arduino
- Teaching with Google Classroom
- 案例式C語言程序設計實驗指導
- Building Serverless Web Applications
- Modern C++ Programming Cookbook
- Python網絡爬蟲技術與應用
- Learning Android Application Testing
- Python硬件編程實戰
- Java 9:Building Robust Modular Applications
- Python數據可視化之matplotlib實踐
- C語言從入門到精通(微視頻精編版)
- Python網絡爬蟲從入門到實踐