SQL advice (Minecraft Server)

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Post Reply
SynPDX
New here
Posts: 2
Joined: Sun Mar 16, 2014 10:51 pm

SQL advice (Minecraft Server)

Post by SynPDX »

Hello. I currently run a Minecraft server on dedicated hardware. This Minecraft server has java plugins that write to various SQL databases. I have the plugins configured to write to the remote databases which are hosted by my QNAP device.

Once in a while, my Minecraft servers throw errors like this one:

https://paste.md-5.net/pixonalule.avrasm

I'm curious if there are settings in the QNAP device that can make the database respond faster? Is there a best practice guide to set up the SQL server? For the most part the SQL server runs fine, but after about 24 hours of running, I start getting errors (took xxxxxxxx milliseconds to respond, communications link failure). I know that the server is up because other databases are running and can communicate fine. Is there max connection limits, I'm kinda lost on where to troubleshoot next.

Any advice would be appreciated!!!
Post Reply

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”