MYSQL and MQTT connection

Forum Home Forums Communicating with Devices MYSQL and MQTT connection

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #6693
    AvatarRoland
    Participant

    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

    #6696
    MikhailMikhail
    Moderator

    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.

    #6699
    AvatarRoland
    Participant

    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.

    #6709
    MikhailMikhail
    Moderator

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

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.