Description
Hey Guys
I see the following on RHEL7,Mariadb and cacti 1.2.5
Seems like its just not picking up the variables unless I am doing something completely wrong
not seeing the same issues on Ubuntu though
MariaDB [(none)]> show variables LIKE 'tmp_table_size';
+----------------+-----------+
| Variable_name | Value |
+----------------+-----------+
| tmp_table_size | 136314880 |
+----------------+-----------+
1 row in set (0.00 sec)
MariaDB [(none)]> show variables LIKE 'join_buffer_size';
+------------------+----------+
| Variable_name | Value |
+------------------+----------+
| join_buffer_size | 33554432 |
+------------------+----------+
1 row in set (0.00 sec)
MariaDB [(none)]> show variables LIKE 'innodb_large_prefix';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_large_prefix | ON |
+---------------------+-------+
1 row in set (0.00 sec)
MariaDB [(none)]> show variables LIKE 'innodb_buffer_pool_size';
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| innodb_buffer_pool_size | 262144000 |
+-------------------------+-----------+
1 row in set (0.00 sec)
Here is what Cacti reports its seeing
Here is the config from Mariadb my.cnf
innodb_file_format = Barracuda
character_set_client = utf8mb4
max_allowed_packet = 16777777
join_buffer_size = 32M
innodb_file_per_table = ON
innodb_large_prefix = 1
innodb_buffer_pool_size = 250M
innodb_additional_mem_pool_size = 90M
innodb_flush_log_at_trx_commit = 2
max_heap_table_size = 150M
tmp_table_size = 130M
join_buffer_size = 250M
innodb_large_prefix = 1
innodb_buffer_pool_size = 2000M