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?