loadrunner测试数据库性能测试sql语句性能的脚本例子.docxVIP

{ { lr_error_message(Could not load libmysql.dll); { { lr_error_message(Could not load libmysql.dll); Loadrunner 测试数据库性能，测试 SQL 语句性能的脚本例 [cpp] view plaincopy/* 需要的表结构如下 CREATE TABLE test_data ( order_id BIGINT UNSIGNED NOT NULL COMMENT Order numbers. Must be unique., status BOOL NOT NULL DEFAULT O COMMENT Whether data has been used or not. A value of 0 means UNIQUEFALSE., date_used DATETIME NULL COMMENT Date/time that the data was used., UNIQUE intorder_id ) ) ENGINE = innodb COMMENT = int LoadRunner test data; */ Action() { int rc; db_connection; // 数据库连接int query_result; // 查询结果集 MYSQL_RESchar** result_row; // 查询的数据char *server = localhost;char *user = root;char *password = 123456; db_connection; // 数据库连接 int query_result; // 查询 结果集 MYSQL_RES char** result_row; // 查询的数据 char *server = localhost; char *user = root; char *password = 123456; char *database = test; int port = 33O6; int unix_socket = NULL; int flags = O;// 找到 libmysql.dll 的所在位置 . rc = O; lr_load_dll(C://Program Files//MySQL//MySQL Server if (rc != O)5.1//bin//libmysql.dll); if (rc != O) lr_abort(); }// lr_abort(); } // 创建 MySQL 对象 db_connection db_connection = mysql_init(NULL); if (db_connection mysql_query(db_connection, SELECT order_id FROM0) { mysql_query(db_connection, SELECT order_id FROM 0) { lr_error_message(%s, db_connection db_connection = mysql_init(NULL); if (db_connection mysql_query(db_connection, SELECT order_id FROM0) { mysql_query(db_connection, SELECT order_id FROM 0) { lr_error_message(%s, == NULL) {lr_error_message(Insufficient memory);lr_abort(); }// 连接到 == NULL) { lr_error_message(Insufficient memory); lr_abort(); } // 连接到 MySQL 数据库 rc = if (rc == NULL) { lr_error_message(%s, mysql_real_connect(db_connection, server, user, password, database, port, unix_socket, flags); mysql_error(db_connection)); lr_abort();mysql_close(db_connection); lr_abort(); // 向数据库插入数据// 此处的{ORDER_ID}是一个参数，简单测试时可以用一个常数代替lr_save_string(lr_eval_string(INSERT INTO test_data (order_id)VALUES ({ORDER_ID})