Strange improvement in mysql query performance on a larger schema

Question

I have a very strange problem with the query and MySql InnoDB schema on my server.

This request has a high request time (about 1.6 - 2 seconds), and my db is almost empty.

To test performance on a larger dataset, I cloned my db and populated it with thousands of lines. It is very strange that the request takes less time than before (0.5 seconds).

Using the command explainfor both queries gives the same results.

I have no idea, so where can I see any metric or difference between db ??

EDIT:

I am trying to reset DDLboth circuits:mysqldump -u user -ppwd -h ***** -d mySchema > mySchemaDDL.sql

Then I executed a command of diffabout 2 dumps and as a result: there is no difference.

This is an example of my result:

2: EXPLAIN EXTENDED. .

Answer 1

, . . , . mysqldump .

:

• mysql OPTIMIZE TABLE
• ( )