Something causes slow performace in specific server actions

Hey! Gotta get back on this (had a previous topic without real answers).

My issues are:

- MySQL imports are very slow: 1-3 Mb files can take 5-15 minutes (upload time of file excluded)
- CURL/file_get_contents requests are incredibly slow also (hence WP admin is slow and similar CMS interfaces that rely on external content on occation)

These same requests on my regular computer (laptop) where I develope site takes less than a second...
So that's why I must find the reason for my production server having problems in these two areas I've mentioned.

Previously I had only really noted the issue with the SQL imports. But now that I see CURL/file_get_content actions also are very slow there must common cause for these two things being very slow. Probably a simple setting somewhere!

That's where I need your help!

The server is a fairly new (< 1 year) dedicated machine with the following specs:

Well Cedis, you need to provide us the settings you are using in your my.cnf file so we can suggest optimization or check the given values. Also please share what's the size of your Database?

Click to expand...

The databases are only 1-5 mb a piece, so not much to optimize. The performance issue only relates to inserts, and SQL-imports are especially slow.

Either way, a new VPS server I setup did the same SQL import in < 1 second, while the current dedicated server does in it 15!! seconds...! The only difference really between the servers is SSD vs old fashion slow harddrives. Even my synology NAS-servers are faster at importing to MysQL than my dedicated server....