Mellanox InfiniBand卡线缆性能延迟性测试程序源码,C源码实现操作mysql库,实现简单的增删改查,代码当前用的是增插入20000条数据
具体见源码
1 #include <mysql/mysql.h> 2 #include <time.h> 3 #include <stdio.h> 4 //gcc $0 -L /usr/lib64/mysql/ -lmysqlclient -o outputname 5 //Mellanox InfiniBand Card Perforce test,By yodoo ruiy 6 // 7 8 void insert() { 9 MYSQL *conn; 10 MYSQL_RES *res; 11 MYSQL_ROW row; 12 13 char *server = "192.168.3.205"; 14 char *user = "root"; 15 char *password = "123"; /* set me first */ 16 char *database = "ruiy"; 17 //char *query = "select * from user"; 18 //char *query = "insert into perforce values("rui_C","rui_S","rui_N","rui_v","rui_O","rui_U","rui_T","rui_S","rui_CO","rui_All");"; 19 //char *query = "insert into perforce values('rui_C','rui_S','rui_N','rui_v','rui_O','rui_U','rui_T','rui_S','rui_CO','rui_All');" 20 char *query = "insert into perforce values(\"rui_C\",\"rui_S\",\"rui_N\",\"rui_v\",\"rui_O\",\"rui_U\",\"rui_T\",\"rui_S\",\"rui_CO\",\"rui_All\")"; 21 int t,r; 22 23 conn = mysql_init(NULL); 24 25 if(!mysql_real_connect(conn,server,user,password,database,0,NULL,0)) 26 { 27 printf("Error connecting to database: %s\n", mysql_error(conn)); 28 } 29 else 30 { 31 printf("Connected....\n"); 32 } 33 34 t = mysql_query(conn, query); 35 36 if(t) 37 { 38 printf("Error making query: %s\n", mysql_error(conn)); 39 } 40 else 41 { 42 printf("Query made...\n"); 43 res = mysql_use_result(conn); 44 if(res) 45 { 46 for(r=0; r<=mysql_field_count(conn); r++) 47 { 48 row = mysql_fetch_row(res); 49 if(row<0) break; 50 for(t=0; t<mysql_num_fields(res); t++) 51 printf("%s", row[t]); 52 printf("\n"); 53 } 54 } 55 mysql_free_result(res); 56 } 57 mysql_close(conn); 58 } 59 60 void Ptime() 61 { 62 FILE *fp; 63 time_t now; 64 struct tm *timenow; 65 time(&now); 66 timenow = localtime(&now); 67 fp = fopen("time.xml","a+"); 68 fprintf(fp,"%s",asctime(timenow)); 69 fclose(fp); 70 } 71 72 73 main() 74 { Ptime(); 75 int i; 76 for (i=0;i<20000;i++) 77 insert(); 78 Ptime(); 79 return 0; 80 }
