MySQL Forums
Forum List  »  Performance

Variable time execution for INSERT
Posted by: Matt K
Date: July 03, 2024 09:20AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Variable time execution for INSERT
245
July 03, 2024 09:20AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.