How-to configure MySQL database monitoring

In LoadRunner (as of this writing which is version 9.0), the supported databases that can be monitored are mainly proprietary, such as, Microsoft SQL, Oracle, Sybase and DB2. Open sources such as MySQL are not supported. In order to monitor this type of databases, we have to employ alternative methods. And one of it, is to utilize SiteScope.

MySQL database monitoring will require SiteScope to be deployed acting as a bridging collector before it can be displayed in LoadRunner. The connection is illustrated in the following. Read the rest of this entry »

MySQL database server counter reference

These are the counters provided by running show status command in MySQL (as of this writing, I’m writing based on MySQL 6.0). It will be the same command to retrieve statistics as mentioned in “How-to configure MySQL database monitoring” which you can refer back again to for concept and configuration details. I’ve list down the counters for your convenience at first glance if you are looking for what to monitor in MySQL. I believed that you can agree with me that we are not experts in MySQL during load test projects. Read the rest of this entry »

How-to retrieve parameter data from MySQL database

As you’ve know, LoadRunner offers the feature of retrieving parameter data from database with the Database Query Wizard in Vugen. This allows ease and alternative preparation of your parameter data for load test. By putting a little creativity on this feature, we need not limit ourselves to the example of Microsoft Access database as mentioned in it’s Vugen User Guide, we can extend this feature to other types of database, say, MySQL database!

Let’s go through a technical overview of what you need to do for it to work!

1. Get and install the database driver to connect to the database
2. Get the database connection string
3. Get the SQL statement for query
4. Create a new parameter using Database Query Wizard
5. Enter the connection string and the SQL statement

Now, let’s go through the details here with some screenshots to make it easier to understand. Read the rest of this entry »