InfiniBand

Mellanox InfiniBand卡线缆性能延迟性测试程序源码,C源码实现操作mysql库,实现简单的增删改查,代码当前用的是增插入20000条数据

具体见源码

#include <mysql/mysql.h>
#include <time.h>
#include <stdio.h>
//gcc $0 -L /usr/lib64/mysql/ -lmysqlclient -o outputname
//Mellanox InfiniBand Card Perforce test,By yodoo ruiy
//

void insert() {
MYSQL      *conn;
MYSQL_RES  *res;
MYSQL_ROW  row;

char *server = "192.168.3.205";
char *user = "root";
char *password = "123"; /* set me first */
char *database = "ruiy";
//char *query = "select * from user";
//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");";
//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');"
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\")";
int t,r;

conn = mysql_init(NULL);

if(!mysql_real_connect(conn,server,user,password,database,0,NULL,0))
{
printf("Error connecting to database: %s\n", mysql_error(conn));
}
else
{
printf("Connected....\n");
}

t = mysql_query(conn, query);

if(t)
{
printf("Error making query: %s\n", mysql_error(conn));
}
else
{
printf("Query made...\n");
res = mysql_use_result(conn);
if(res)
{
for(r=0; r<=mysql_field_count(conn); r++)
{
row = mysql_fetch_row(res);
if(row<0) break;
for(t=0; t<mysql_num_fields(res); t++)
printf("%s", row[t]);
printf("\n");
}
}
mysql_free_result(res);
}
mysql_close(conn);
}

void Ptime()
{
FILE *fp;
time_t now;
struct tm *timenow;
time(&now);
timenow = localtime(&now);
fp = fopen("time.xml","a+");
fprintf(fp,"%s",asctime(timenow));
fclose(fp);
}


main()
{   Ptime();
    int i;
    for (i=0;i<20000;i++)
    insert();
    Ptime();
    return 0;
}