Is there any tool or script available to monitor the MySQL server. My database receives on an avg of 1 lakh queries per hr. After about 14 Hrs the server starts running slow, and then crashes after a while. The problem is unknown till now and i need some way to identify its cause.
I've heard about managing Oracle database, is there any way i can monitor my mysql server.
I've been interested in using MySQL admisitrator; but have been wondering if there is any security risks to running this remotely. Does this log into MySQL through a secure connection where usernames and passwords sent over the Internet are encrypted?
The MySQL Agent exposes various parameters needed for intrinsic monitoring of the database.
It exposes the log files which is quite useful in detecting some bottlenecks arise due to very slow queries etc.