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

max_connections problem

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.11
    • Fix Version/s: 2.3.16, 2.4.6
    • Component/s: Core
    • Labels:
      None

      Description

      After few hours any connection attempts through maxscale finaly:
      ERROR 1040 (HY000): Too many connections
      Direct connect without maxscale working fine.

      config example:

      [maxscale]
      threads = auto
      log_warning=1
      log_debug=1
       
      [mysql07]
      type = server
      protocol = MariaDBBackend
      address = 192.168.4.106
      port = 3307
       
      [mysql08]
      type = server
      protocol = MariaDBBackend
      address = 192.168.4.107
      port = 3307
       
      [Service-for-cluster_78]
      user = maxscale
      password = pass
      filters = Hint
      max_slave_replication_lag=300
      max_sescmd_history=1500
      prune_sescmd_history=true
      type = service
      router = readwritesplit
      servers = mysql07, mysql08
      master_accept_reads = true
      max_connections = 800
       
      [MariaDB-Monitor-for-cluster_78]
      type = monitor
      module = mariadbmon
      user = replica
      password = pass
      monitor_interval = 5000
      failover_timeout = 10
      auto_failover = false
      detect_replication_lag = true
      handle_events = false
      servers = mysql07, mysql08
       
      [Listener-for-cluster_78]
      address = 0.0.0.0
      type = listener
      service = Service-for-cluster_78
      protocol = MariaDBClient
      port = 3306
       
      [MaxAdmin-Service]
      type = service
      router = cli
       
      [MaxAdmin-Listener]
      type = listener
      service = MaxAdmin-Service
      protocol = maxscaled
      socket = default
       
      [Hint]
      type = filter
      module = hintfilter
      

      MySQL server variables:

      | max_connect_errors                            | 1000            |
      | max_connections                               | 1000            |
      | max_user_connections                          | 800             |
      

      MySQL server status:

      | Max_used_connections                          | 193                 |
      | Max_used_connections_time                     | 2019-10-03 06:40:06 |
      

      maxctrl show servers "connections": 0 (Statistics section)
      maxctrl show services fragment:

      {
      	"connections":500,
      	"current_connections":1,
      	"queries":1500,
      	"route_master":0,
      	"route_slave":1500,
      	"route_all":500,
      	"rw_transactions":0,
      	"ro_transactions":0,
      	"replayed_transactions":0,
      	"server_query_statistics":[
      		{
      			"id":"mysql07",
      			"total":2000,
      			"read":2000,
      			"write":0,
      			"avg_sess_duration":"74.4405ms",
      			"avg_sess_active_pct":98.50054979380471,
      			"avg_selects_per_session":2
      		},
      		{
      			"id":"mysql08",
      			"total":500,
      			"read":500,
      			"write":0,
      			"avg_sess_duration":"74.422ms",
      			"avg_sess_active_pct":0,
      			"avg_selects_per_session":0
      		}
      	]
      }
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              ssmirnov Sergey Smirnov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration