Slow MySql server on new host?

Question

MySQL

Hello everyone, I recently transferred databases from hosting to my server, after a while I noticed that queries on my server are executed 3-6 times slower, while on my computer and on a known good server, queries are executed normally. What could be the problem?
OS server specifications
- Windows Server 2012 R2
Intel E5-2603 v4, 16GB RAM
intel server SSD (database and web server specific)
https://pastebin.com/iCDatJV7 - my server's my.ini
https://pastebin .com/7pQis5kR - my computer's my.ini

Answer 1

I solved the problem by reinstalling MySql server from 64 bit to 32 bit version.

Answer 2

And what is your performance based on? In percent, memory, ssd? You are in top/htop etc. peeked during requests?
Use more utilities https://tools.percona.com
Proc is quite low frequency, and a complex query can make it think. Look at the load on the cores of the processor. If this is the case, then it is worth turning off the HT of the processor (if any) or overshadowing it with a more productive one. It if to optimize requests of an opportunity is not present.

Answer 3

yet it all depends on the configs on the server, maybe caching is used there, but you don’t!?
are the versions the same mysql? Perhaps the type of tables has changed during export/import?
there are a lot of options, screenshots will not help here in any way if you clearly see that nothing rests on the hardware.

Answer 4

Good day.
How do you connect to bases? If by domain name or localhost, then there may be a gag. Try instead of the ip domain (and even register 127.0.0.1 instead of localhost) it may also be better to connect via sockets / pipe.