ventbook Posted August 7, 2020 Share Posted August 7, 2020 I want to allow lowercase table names and restart mysql server Quote Link to comment Share on other sites More sharing options...
wolstech Posted August 7, 2020 Share Posted August 7, 2020 Lowercase table names are already supported. Only a root admin can restart the mysql server, and that's by design since there's thousands of people sharing it with you. Quote Link to comment Share on other sites More sharing options...
Krydos Posted August 7, 2020 Share Posted August 7, 2020 It restarts every 2 hours anyways right before apache restarts. Mysql uses massive amounts of memory, and freeing up all the memory right before apache restarts helps make the apache restart smoother. Apache essentially uses double memory during a restart because the old configuration continues serving pages while the new configuration loads up in parallel. Then once the new configuration is serving pages the old apache threads die when they're done. Then over the next 30 minutes or so the mysql memory usage ramps back up to its usual high amount. The other benefit of restarting mysql every 2 hours is it closes all the open connections. Before we restarted mysql regularly some people would leave mysql connections open for days on end. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.