A small (18k) mariadb database restore on a new install of raspbian-lite stretch runs extremely slowly (taking more than a minute to complete).
sudo apt-get install mysql-server
sudo apt-get install mariadb-server-10.1
test (after creating database)
sudo mysql -u root internet < /home/pi/MySQL/internet.sql
If I run the same restore on a Pi3B with new raspbian-desktop stretch, it completes in less than a second.
Also OK on an old wheezy install.
Cannot see any config file differences.
Purged and re-installed mariadb - no change. Same result in Pi1B and Pi3B+. Tried 3 different sd cards too.
Tried another new install of raspbian-desktop - that also is slow, but the original new (a few days ago) install is still OK.
No problem with wheezy (MySQL 5.5)
No problem with jessie (MySQL 5.7)
It screams config., but unless I've missed a file, I cannot see any difference (as listed in /etc/mysql/mariadb.cnf).