Dear all,
so after switching from bananian to armbian around half a year ago, I've made several updates to the bananapi server running. As the prototype server is still running with bananian, some problems just occured as I am now testing a fresh install of my web-package, including nginx, mysql, php7 / laravel and some other stuff.
So what I realized was that the database, even on a fresh install, is extremely slow. I thought the newer setup with debien stretch and mariadb 10.1+ might be the problem, yet running the same on the older armbian jessie build did not change anything. I also set up a fresh virtual machine running debian stretch with two cores, 1GB of ram imitating a bananapi board. I've created a database, loaded in a mysql_dump file (around 650 lines including comments) and checked the time. Took less than 3 seconds on the virtual machine, on the old bananian image running on our prototype server this file takes 5 seconds. With a fresh armbian installation (downloaded newest image two hours ago) running on the same hardware the dumpfile takes something like half an hour.
The SD cards are fine, I tried different ones. The mariadb configuration is exactly the same as the one a fresh debian package uses.
The only problem I can still think about might be some disk I/O or permission problems with armbian. Does anybody has any suggestions here ? Actually this problem makes the whole setup not usable anymore. A full database restoration process running normally in less than a minute now takes an hour.
Here are the MariaDB variables from the database, though I did not change any configuration.
Thanks for any help !