Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1948

Connections not balanced between workers

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.2.9
    • 2.2.11
    • Core
    • None
    • CentOS7

    Description

      We found that, In high pressure, load is not balance between workers; Our test shows this have big impact on performance.

      Test1: long session

      sysbench --test=$sysbenchpath/tests/db/oltp.lua --mysql-host=$ro --mysql-port=$port --mysql-user=xxxx --mysql-password=xxxx --mysql-table-engine=innodb --oltp-table-size=25000 --oltp-tables-count=250 --db-driver=mysql --max-requests=0 --oltp_simple_ranges=0 --oltp-distinct-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --max-time=$maxtime --oltp-read-only=on --num-threads=256 --mysql-db=xxx  --report-interval=1 --oltp-skip-trx=on run
      
      


      test2: short session

      function prepare()
         return 0
      end
       
      function cleanup()
      end
       
      function thread_init(thread_id)
      end
       
      function event(thread_id)
         db_connect()
         rs = db_query("select 1;")
         db_disconnect()
      end
      

      Attachments

        1. image.png
          108 kB
          dapeng huang
        2. image-2018-06-29-09-32-34-656.png
          115 kB
          dapeng huang

        Activity

          People

            markus makela markus makela
            dapeng dapeng huang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.