[Solved] Restart mysql server

[ventbook]

I want to allow lowercase table names and restart mysql server

[wolstech]

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.

[Krydos]

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.