SiteScope監控Mysql注意要點

Monitoring mySQL Databases
Monitoring a MySQL database requires the use of a JDBC driver. To enable SiteScope to monitor a MySQL database:

 

Download the JDBC driver from http://www.mysql.com/downloads/api-jdbc.html
Uncompress the distribution file
Among all the other files, you should find a file with a .jar extension.
Copy the .jar file into the <SiteScope install path>/SiteScope/java/lib/ext directory

Stop and restart SiteScope
Now, use your browser to add a Database Query Monitor within SiteScope.
The Database Connection URL format for the MySQL JDBC driver is:

jdbc:mysql://<database hostname>[:<tcp port>]/<database>

 

For example to connect to the MySQL database "aBigDatabase" on a machine using the standard MySQL port number 3306 you would use:
jdbc:mysql://206.168.191.19/aBigDatabase

 

If you are using a different port to connect to the database then you should include that port number as part of the IP address.

The specification for the MySQL JDBC driver is: org.gjt.mm.mysql.Driver

Enter this string into the Database Driver text box under the Advanced Options section of the Add Database Query Monitor form.