Hello, I have a web server on my Raspberry pi 3, running php 5.6, and an IIS server that has a phpmyadmin database. I query the SQL database to retrieve data and that works instantaneously, but when I query the database to create databases/tables, it can sometimes take longer than 10 minutes, some queries don't make it to the database. it's the strangest issue.
The database is not locked, there are no previous connections, they are all dealt with appropriately and closed. Both servers are on the same VLAN.I can still use mysql from the command line on the raspberry pi with no issues.
Does anyone have any idea what could be the issue? It seems to be something related to the raspberry pi.
Web server (copied from phpmyadmin):
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407
PHP version: 7.0.21