How to understand MySQL InnoDB index and transaction
An index is a structure that sorts the values of one or more columns in a database table. An index is used to provide quick...
Read More
Tag: Mysql index
Must be aware of the SQL statement is not indexed when the troubleshooting tool
December 14, 2023
by 尹哲瑋
No Comments
If there is an implicit character set conversion (SCS) in the index field, the index will be invalid, and the query efficiency will be greatly...
Read More
Shallow in and shallow out of MySQL index
December 14, 2023
by Faiyaz Dugar
No Comments
What is an index? Why is there a MySQL index, what problem is it solving, and what is the underlying principle? Why use B+ trees...
Read More
Elasticsearch vs. MySQL
December 14, 2023
by Kahurangi Gee
No Comments
In the preface, I have been maintaining the search function of the product. Every time I see ElasticSearch on the admin platform, I am curious...
Read More
Probably the most thoughtful MySQL note
December 14, 2023
by Angela Farland
No Comments
{code... } {code... } {code... } {code... } {code... } {code... } {code... } {code... } {code... } Continuously updated...
Read More