MYSQL and MQTT connection

[Roland]

Hi,

I am trying to configure a fast communication between mqtt messages and mysql database. However, I achieved only 10-14 SQL insert queries per second (sensor->rapidscada->mqtt->mysql db). I am using Windows 10 on a virtual machine configuration. Do you have any idea how could I boost up the connection and insert query rate? I’ve already changed the followings:
– sync_binlog mysql parameter to 500,
– disabled autocommit,
– set max_allowed_packet=524288000,
– innodb_flush_log_at_trx_commit=0 (not sure if this counts)
– the allowed_max_packet to 500M.

I guess, on a native installation of Windows 10 the performance will be signfificantly better.

I also have a question about the mqtt communication. I am using mosquitto broker and have set up a publisher to send 100 messages without any delay inbetween. Once the sending finishes, rapid scada still receives incoming data. I think, it receives approximately 10 values from the publisher in every second. Is it possible to boost this up somehow? Is it possible to achieve ~100 or more mqtt message receiving in every second?

Thanks.

Roland

[Mikhail]

Hi,
I think, you should use real physical machine, because performance of a virtual machine is unpredictable.

What database model do you use?

Please create a different topic to discuss MQTT. One subject is a one topic.

[Roland]

I am using MySQL Server 8.0 with the default relations that you defined here:
http://rapidscada.net/doc/content/latest/en/modules/mod-db-export.html

I also removed the primary key attribute from the datetime column, to allow more than 1 entries from the same second.

[Mikhail]

Are there changes in performance if you install Rapid SCADA and MySQL to a physical machine?

[Author]

Posts