Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4001

Can't set the value of MaxOutstandingRequests

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 1.2.5
    • Icebox
    • ?
    • None
    • POC

    Description

      Hi,
      We are doing a POC and the machines are each 64core (hyperthreaded) with 512G RAM and local SSD.
      The test we have is for 500 concurrency and we have 2 PMs (total of 128 cores)
      We have tried setting MaxOutstandingRequests parameter and it's just not making any change...
      $ configxml.sh setconfig JobList MaxOutstandingRequests 64
      Old value of JobList / MaxOutstandingRequests is 20
      JobList / MaxOutstandingRequests now set to 64
      $ configxml.sh getconfig JobList MaxOutstandingRequests
      Current value of JobList / MaxOutstandingRequests is 64

      We have tried it with setconfig also
      $ setConfig JobList MaxOutstandingRequests 64

      $getConfig JobList MaxOutstandingRequests
      64

      And getconfig and all else reads it right. We have verified in Columnstore.xml and it reflects there too.
      But it is not running more than 20 queries...

      MariaDB > select calgetsqlcount();
      ------------------------------------------------------

      calgetsqlcount()

      ------------------------------------------------------

      Running SQL statements 20, Waiting SQL statments 230

      ------------------------------------------------------

      We ran 250 concurrent queries per server and 20 ran and 230 waited.
      Replication is on and we are sending 250 queries on pm1 and pm2.

      mcsadmin> getsystemi
      getsysteminfo Tue May 12 17:43:28 2020

      System columnstore-1

      System and Module statuses

      Component Status Last Status Change
      ------------ -------------------------- ------------------------
      System ACTIVE Tue May 12 17:10:06 2020

      Module pm1 ACTIVE Tue May 12 17:10:04 2020
      Module pm2 ACTIVE Tue May 12 17:10:00 2020

      Active Parent OAM Performance Module is 'pm1'
      Primary Front-End MariaDB ColumnStore Module is 'pm1'
      MariaDB ColumnStore Replication Feature is enabled
      MariaDB ColumnStore set for Non-Distributed Install

      MariaDB ColumnStore Process statuses

      Process Module Status Last Status Change Process ID
      ------------------ ------ --------------- ------------------------ ----------
      ProcessMonitor pm1 ACTIVE Tue May 12 17:09:06 2020 38104
      ProcessManager pm1 ACTIVE Tue May 12 17:09:13 2020 38359
      DBRMControllerNode pm1 ACTIVE Tue May 12 17:09:41 2020 39478
      ServerMonitor pm1 ACTIVE Tue May 12 17:09:43 2020 39530
      DBRMWorkerNode pm1 ACTIVE Tue May 12 17:09:43 2020 39584
      PrimProc pm1 ACTIVE Tue May 12 17:09:48 2020 39758
      ExeMgr pm1 ACTIVE Tue May 12 17:09:53 2020 40471
      WriteEngineServer pm1 ACTIVE Tue May 12 17:09:57 2020 40621
      DDLProc pm1 ACTIVE Tue May 12 17:10:01 2020 40755
      DMLProc pm1 ACTIVE Tue May 12 17:10:05 2020 40906
      mysqld pm1 ACTIVE Tue May 12 17:09:55 2020 39330

      ProcessMonitor pm2 ACTIVE Tue May 12 17:09:31 2020 19696
      ProcessManager pm2 HOT_STANDBY Tue May 12 17:09:36 2020 19916
      DBRMControllerNode pm2 COLD_STANDBY Tue May 12 17:09:42 2020
      ServerMonitor pm2 ACTIVE Tue May 12 17:09:45 2020 20261
      DBRMWorkerNode pm2 ACTIVE Tue May 12 17:09:45 2020 20337
      PrimProc pm2 ACTIVE Tue May 12 17:09:50 2020 20358
      ExeMgr pm2 ACTIVE Tue May 12 17:09:54 2020 20727
      WriteEngineServer pm2 ACTIVE Tue May 12 17:09:58 2020 20796
      DDLProc pm2 COLD_STANDBY Tue May 12 17:10:00 2020
      DMLProc pm2 COLD_STANDBY Tue May 12 17:10:00 2020
      mysqld pm2 ACTIVE Tue May 12 17:09:44 2020 20199

      Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
      mcsadmin>

      Attachments

        Activity

          People

            Unassigned Unassigned
            ravidhingra ravi dhingra
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.