Replies: 1 comment
-
even a select * from the largest table (playtime), its super quick via command line. (select * from CMI_playtime) I'm at a loss for what CMI is doing thats taking 90+ seconds when establishing MySQL connection. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
[13:31:00] [Server thread/INFO]: Started MySQL data base. Took 97721ms
I'm setting up a new server and remote connection to my database server from CMIs perspective is very slow.
I don't think it's latency related, good ping times and no packet loss. Plus, other plugins like core protect, etc have no issues (even tested plenty of querys/rollbacks).
time mysql -u'minecraft' -p -h ip.to.db.server -e'show status'
real 0m0.576s
user 0m0.008s
sys 0m0.004s
I did try changing from hostname to IP thinking that could help a little, but didn't. (name resolution shouldn't take 60+ seconds anyway).
Beta Was this translation helpful? Give feedback.
All reactions