General questions about Linux, MySQL, and how they relate to IIS and MSSQL

thanovia · #1 (**permalink**) 02-20-07, 11:58

Recently I switched jobs from a Windows environment to a Linux environment. The MySQL server works great 99% of the time, but occasionally has lag. On MSSQL I can recycle the application pool to give it a jump-start and everything works fine. So far I haven't been able to find something similar with MySQL. I know there has to be something like this because restarting the service every couple days probably isn't the best idea but it's all I have right now.

Any ideas?

Currently I connect to the db server through command line and tell the os this:

/etc/init.d/mysqld restart

Something else that's command-line would be great as I could script it and just run it when needed. Thanks for the time it took to read this!

BodShane · #2 (**permalink**) 02-23-07, 12:53

If you are the root user then following 2 commands should be helpful for you :-

mysqladmin flush-privileges

or

mysqladmin refresh

flush-privileges : Reload grant tables (same as reload)
refresh : Flush all tables and close and open logfiles

thanovia · #3 (**permalink**) 02-26-07, 19:10

Thank you very much, I'll use that.

I didn't know where else to go to find that answer and didn't have time to properly research it so this saves me a good deal of time.

BodShane · #4 (**permalink**) 02-27-07, 05:18

Hello

In case in future if you require any assistance from us, please feel free to contact us.