InfluxDB读写性能测试
这里将告诉您InfluxDB读写性能测试,教程操作步骤:
今天进行了InfluxDB和MySQL的对比测试，这里记录下结果，也方便我以后查阅。
操作系统： CentOS6.5_x64InfluxDB版本 ： v1.1.0MySQL版本：v5.1.73CPU ： Intel(R) Core(TM) i5-2320 CPU @ 3.00GHz内存 ：12G硬盘 ：SSD
一、MySQL读写测试 测试准备初始化SQL语句：
?| 12345678910111213 | CREATE DATABASE testMysql;CREATE TABLE `monitorStatus` ( `system_name` VARCHAR(20) NOT NULL, `site_name` VARCHAR(50) NOT NULL, `equipment_name` VARCHAR(50) NOT NULL, `current_value` DOUBLE NOT NULL, `timestamp` BIGINT(20) NULL DEFAULT NULL, INDEX `system_name` (`system_name`), INDEX `site_name` (`site_name`), INDEX `equipment_name` (`equipment_name`), INDEX `timestamp` (`timestamp`))ENGINE=InnoDB; |
单写测试代码（insertTest1.c）：
?| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 | #include <stdlib.h> #include <stdio.h> #include <time.h>#include "mysql/mysql.h" #define N 100 int main(){ MYSQL *conn_ptr; int res; int t,i,j; int64_t tstamp = 1486872962; srand(time(NULL)); t=0; conn_ptr = mysql_init(NULL); if (!conn_ptr) { printf("mysql_init failed
"); return EXIT_FAILURE; } conn_ptr = mysql_real_connect(conn_ptr,"localhost","root","","testMysql",0,NULL,0);
|
