Loadrunner测试数据库性能,测试SQL语句性能的脚本例子.docVIP

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_err