[SOLVED] Poller minimum connections

[darkness4773]

Hi all!

I would like to know how to increase the Poller minimum connections, please.

In Cacti \ utilites \ System Utilities \ Poller Information \ Minimum Connections

Currently, this is what i have:
Current: 151, Min Required: 241
Assumes 100 spare connections for Web page users and other various connections.
The minimum required can vary greatly if there is heavy user Graph viewing activity.
Each browser tab can use upto 10 connections depending on the browser.

I'm not able to find were to set up this

I would like to increase the minimum connection to 1000

Thx for your help

[TheWitness]

Edit /etc/my.cnf.d/server.cnf and set max_connections = 1000 and then restart MariaDB/MySQL.

[darkness4773]

Hi!

@TheWitness Thx for your help

I have added max_connections = 1000 in /etc/my.cnf.d/server.cnf
i have restarted mariadb
but CACTI doesn't take it
*********************************************************************************
server.cnf
**************************
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
max_heap_table_size=255M
tmp_table_size=255M
innodb_file_format = Barracuda
max_allowed_packet = 16777777
max_connections = 1000
join_buffer_size = 510M
innodb_file_per_table = ON
innodb_large_prefix = 1
innodb_buffer_pool_size = 4000M
innodb_additional_mem_pool_size = 90M
innodb_flush_log_at_trx_commit = 2
log-error = /var/log/mysql/mysql-error.log
log-queries-not-using-indexes = 1
slow-query-log = 1
slow-query-log-file = /var/log/mysql/mysql-slow.log
***************************************************************************************
CACTI
***************
Current: 214, Min Required: 241
Assumes 100 spare connections for Web page users and other various connections.
The minimum required can vary greatly if there is heavy user Graph viewing activity.
Each browser tab can use upto 10 connections depending on the browser.



i have restarted my centos but no change

[darkness4773]

i tried to set max_connections to 500 and it works.

so i guess max_connections depends on others parameters of CACTI.

i'm going to work on it

@TheWitness thx you for your help.