InfiniBand

冷不防 2022-01-11 14:39 122阅读 0赞

[InfiniBand][]

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 }

posted on 2014-01-07 13:36 [秦瑞It行程实录][It] 阅读( ...) 评论( ...) [编辑][Link 1] 收藏

转载于:https://www.cnblogs.com/ruiy/p/Mellanox.html

[InfiniBand]: https://www.cnblogs.com/ruiy/p/Mellanox.html
[It]: https://www.cnblogs.com/ruiy/
[Link 1]: https://i.cnblogs.com/EditPosts.aspx?postid=3508640