Hello,
I do an INSERT in a table who has around 1 million rows in MySQL 8.0. I don't know why I have different execution times for the same data to insert.
For example, I measure one time 281 milliseconds and an other time 1 second. There are no other queries running at the same time except mine.
How is it possible ?
UPDATE 1 : Additional informations
Somes lines in my.ini :
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
slow-query-log=1
table_open_cache=2000
tmp_table_size=697M
thread_cache_size=10
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
innodb_flush_log_at_trx_commit=1
innodb_log_file_size=48M
innodb_thread_concurrency=9
OS : Microsoft Windows Server 2019 Standard (64 bits)
RAM : 16 GB
4 cores
2 disks - 120 GB x2, don't know if it's NVME or SSD (it's not mine)
SELECT COUNT(*) FROM information_schema.tables;
Result : 203
SHOW GLOBAL STATUS;
Result :
https://justpaste.it/e5ek0
SHOW GLOBAL VARIABLES;
Result :
https://justpaste.it/fev9k
SHOW FULL PROCESSLIST;
Result :
https://justpaste.it/63gdx
SHOW ENGINE INNODB STATUS;
Result :
https://justpaste.it/fot5h