Summary of performance testing training-spotlight on mysql
For performance testing monitoring, there are many ways, generally with LoadRunner we often use sitescope, because it is strong enough.
But in this lecture, I would like to introduce you to another monitoring tool, specifically to monitor mysql's spotlight. What is spotlight own Baidu to go.
1. Download spotlight at the following address:
Http://download.csdn.net/detail/xqtesting/4171014
2. Download odbc3.5x with the following link, with google jump
Http://www.google.com.hk/url?sa=t&rct=j&q=ODBC+3.5X&source=web&cd=1&ved=0CCgQFjAA&url=http%3A%2F%2Fdownloads.mysql.com%2Farchives%2Fmysql-connector-odbc-3.51%2Fmysql-connector-odbc-3.51.24-win32.msi&ei=RJxuT_z5K-WXiAfzrLSOBg&usg=AFQjCNGsyQabn5uJJMknVo6wXlMwR5suew
3. Install odbc and next all the way
4. Install spotlight and next all the way
5. Open a connection in spotlight,new and fill in the mysql information, as shown below.
Ok is fine.
The rest is that you look at the various indicators.
6. The official document is attached.
Ps: this example takes monitoring the local mysql as an example. If you want to monitor the mysql of the remote server, you need to install the odbc of mysql on the remote server, but spotlight for mysql only supports the mysql-odbc-3.5x version of the driver. This version may not be supported on most of the latest servers, so you need to pay attention to it.
Attachment: http://down.51cto.com/data/2360135