Shulou(Shulou.com)06/03 Report--

Editor to share with you what mysql indexing skills are, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Indexing for medium to large tables is very effective, but the maintenance cost of super-large tables will be very high, so it is not suitable for indexing.

2. Avoid imposing functions on fields in the where clause, resulting in missing the index.

3. When using InnoDB, use the self-increasing primary key that has nothing to do with business as the primary key.

Even use a logical primary key instead of a business primary key.

Delete indexes that have not been used for a long time, and the existence of unused indexes will cause unnecessary performance loss. MySQL5.7 can query which indexes have never been used by querying the schema_unused_indexes view in the sys library.

When using limitoffset slow queries, you can use indexes to improve performance.

Example

CREATE TABLE `table` (`id` int (11) NOT NULL AUTO_INCREMENT, `title` char (255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `time` int (10) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX index_name (title (length) are all the contents of this article entitled "what are mysql's skills in using indexing?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.