Loadrunner测试数据库性能,测试SQL语句性能的脚本例子
此代码为Loadrunner 8 通过C API类型的Vuser 测试MySQL性能,或者测试sql语句性能的脚本。
这东西很少有人用,网上资料很少,一般测试B/S的很多。
view plaincopy to clipboardprint? /*需要的表结构如下 CREATE TABLE `test_data` ( `order_id` BIGINT UNSIGNED NOT NULL COMMENT 'Order numbers. Must be unique.', `status` BOOL NOT NULL DEFAULT '0' COMMENT 'Whether data has been used or not. A value of 0 means FALSE.', `date_used` DATETIME NULL COMMENT 'Date/time that the data was used.', UNIQUE ( `order_id` ) ) ENGINE = innodb COMMENT = 'LoadRunner test data'; */ Action() { int rc; int db_connection; // 数据库连接 int query_result; // 查询结果集 MYSQL_RES char** result_row; // 查询的数据? char *server = "localhost"; char *user = "root"; char *password = "123456"; char *database = "test"; int port = 3306; int unix_socket = NULL; int flags = 0; // 找到libmysql.dll的所在位置. rc = lr_load_dll("C:\Program Files\MySQL\MySQL Server 5.1\bin\libmysql.dll"); if (rc != 0) { lr_error_message("Could not load libmysql.dll"); lr_abort(); } // 创建MySQL对象 db_connection = mysql_init(NULL); if (db_connection == NULL) { lr_error_message("Insufficient memory"); lr_abort(); } // 连接到MySQL数据库 rc = mysql_real_connect(db_connection, server, user, password, database, port, unix_socket, flags); if (rc == NULL) { lr_error_message("%s", mysql_error(db_connection)); mysql_close(db_connection); lr_abort(); } // 向数据库插入数据 // 此处的 {ORDER_ID} 是一个参数,简单测试时可以用一个常数代替 lr_save_string (lr_eval_string("INSERT INTO test_data (order_id) VALUES ({ORDER_ID})"),"paramInsertQuery"); rc = mysql_query(db_connection, lr_eval_string("{paramInsertQuery}")); if (rc != 0) { lr_error_message("%s", mysql_error(db_connection)); mysql_close(db_connection); lr_abort(); }
// 从数据库读取一个数据并显示 rc = mysql_query(db_connection, "SELECT order_id FROM test_data WHERE status IS FALSE LIMIT 1"); if (rc != 0) { lr_error_message("%s", mysql_error(db_connection)); mysql_close(db_connection); lr_abort(); }