Is MySQL slow to query for the first time?

problem description

there is a user table with

in it.

uid
regdate //
reg_package //
reg_channel //
...

now I have a SQL query for user data

SELECT * FROM `user` ORDER BY `regdate` DESC  LIMIT 0,50;

there is a multi-column index on this table. idx_regdate_reg_package_reg_channel (key_len has 202)
this SQL also uses this index (using EXPLAIN to see)

question

When

this statement is executed for the first time, the query speed of is very slow , and then it will be much faster. I am very confused here
PS:. I know that InnoDB indexes need buffering. Does it have anything to do with buffering?

Mysql-Index mysql-optimized mysql

Jul.20,2021

The reason why

is slow does not lie in this sentence. If I made a mistake, I checked. It is select COUNT (*) FROM user that the sentence is slow

there are many caches in the database, sql parsing cache, query result cache, index cache, you say slow first, then fast, probably query result cache. You can try to change the parameters in the second query:

as for the first time

SELECT * FROM `user` ORDER BY `regdate` DESC LIMIT 0,50;

second time

SELECT * FROM `user` ORDER BY `regdate` DESC LIMIT 5,55;

see if it's slow, too?

if the amount of data is large, please do not use select *, it is recommended to use select field

Previous: Vue lets loop label radio and multiple selections highlight?

Next: Element upload component problem

Mysql batch data update and insertion pit
has such a logic, a piece of data, if there is in the database, then update, if it does not exist, then insert. But now there are ten thousand. So how to accomplish the task efficiently? ...

Mysql-Index mysql-optimized mysql

Mar.14,2021
How to index the mysql time field
when querying, you need to query the scope according to the time field, timestamp type. Statement does not have subqueries, associated queries, only look up this table. it takes about 4.5 seconds to find 50, 000 results. This field has been indexed, bu...

Mysql-Index mysql-optimized mysql

Mar.31,2021
Million-level mysql database uses count, group, order query is very slow, how to optimize
the database currently has 1 million data (it has been running for about half a month) the following sentence takes 6 seconds to run (1 million results for where alone), and both user_id and time are indexed ...

Php mysql-Index mysql-optimized mysql

May.25,2022