windows-server - 阿里云服务器给了权限,本地采集的数据远程写入服务器中MySQL5.5表中,一秒可以写入多少?这个速度一般由什么来决定?
ringa_lee
ringa_lee 2017-04-17 16:40:07
0
1
457

本人将数据采集器连接到自己笔记本,并在笔记本使用LabVIEW编写采集程序,可以实时采集数据。现在希望把采集的数据实时传输到阿里云服务器的数据库MySQL5.5中,阿里云服务器给了权限,也可以传入数据,但可惜每秒只有大约12行数据,即只能每秒传十二个。

无论如何提高采样频率,每秒就是12或者13个。请问大神谁做过这种?是哪里出了问题?甚至改了my.ini配置文件中的innodb_flush_log_at_trx_commit=0,看网上说这样可以提高写入数率,但还是老样子

本人在本地电脑上写入MySQL数据库中,无论多大采样频率,最多可以写入300个,不稳定,但是服务器中最多12-13个

ringa_lee
ringa_lee

ringa_lee

reply all(1)
Ty80

After all, remote connections are different from local connections. One is the network speed limit, and the other is that the connection itself takes a certain amount of time.
It is better to directly connect to the database using a long connection, but it will not meet the real-time performance you require.
The speed of collection and uploading Different, it can be asynchronous, cache it to the local machine after collection, and another software is responsible for uploading.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template