CODEWITHSUNDEEP
mariadbmaxscale
AIWeaver
AIWeaver

Reputation: 11

Too many 'Total Connections'. Is it normal status? MaxScale 2.3.9

I installed Mariadb 10.3.15 and Maxscale 2.3.9 It works fine, but sometimes the query speed is slow.

When I look at the status of the service through MaxCtrl, I can see that the value of 'Total Connections' is very high. At first it was small, but the value is still increasing, is this normal state value?

image 1

Upvotes: 1

Views: 1303

Answers (2)

ac_s_fer
ac_s_fer

Reputation: 53

Total Connections displays the total number of connections made to backends since maxscale start. It is normal it grows as every new connection established is counted.

Connections are the currently connections established to your backends, active (serving queries) + idle. Your backends should be able to handle these (hardware + network + configuration), otherwise it can slowdown things.

https://mariadb.com/kb/en/mariadb-maxscale-24-maxctrl/#list-services

Upvotes: 0

Rick James
Rick James

Reputation: 142518

What is the limit of connections from MaxScale? From the clients? What kind of clients -- web servers or what?

My point is that it not MariaDB's problem, it is something upstream.

If "query speed is slow", that sounds like a poorly indexed table or a poorly written query. Set long_query_time=1 and turn on the slowlog.

Upvotes: 0

Related Questions