Score:0

Slow MySQL 5.7 on Windows Server 2019

sd flag

MySQL 5.7 standard install with standard my.cnf (server) one table 20mb size

Dell R210II Windows Server 2019 Xeon 1230 v2 16gb ram

1 queries executed, 1 success, 0 errors, 0 warnings

Query: CALL do_import

0 row(s) affected

Execution Time : 53.650 sec
Transfer Time  : 0 sec
Total Time     : 53.650 sec

Laptop i7 L620 8gb ram

1 queries executed, 1 success, 0 errors, 0 warnings

Query: call do_import

0 row(s) affected

Execution Time : 15.521 sec
Transfer Time  : 0 sec
Total Time     : 15.522 sec

Server is not loaded , it has IIS with php, Vanilla Benchmark makes :

Math    0.083 sec.
String  0.232 sec.
Loops   0.023 sec.
If Else 0.062 sec.
Calculation total   0.400 sec.
Total   0.400 sec.

Any ideas why MySQL is so slow on Xeon WS2019? I don't have any other performance issues on Dell only super slow database.

Massimo avatar
ng flag
Please add details about storage, which is the most likely culprit.
ua flag
What engine for the table? Was is the value of `innodb_buffer_pool_size on each machine? SSD or HDD disk?
Olaman avatar
sd flag
Dell Perc H200 is a junk, write speed was about 20mb/s. The same disk in Raid1 from onboard controller: CALL do_import time drop to 10s, with H700 to 6s. Thank you for hint!
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.