Questions about MariaDB / Cacti Config and Installing Boost

[Cactus84]

Hi All,
I am a novice when it comes to the subject of DBMS, so In order to install BOOST etc I need to get my facts right.

I am currently using 1 Minute Polling, with Cacti 0.8.8.c

I have been told everywhere that Innodb is better than MyISAM for mariadb database performance.

Should I be converting my Cacti Database from a MyISAM to an Innodb as seen with the instructions? http://technotes.twosmallcoins.com/?p=356

If so then I should do this before installing Boost.


- Before Installing the Boost Plugin:

As explained here: http://docs.cacti.net/plugin:boost

I am trying to answer the questions, but do not have the answers hence I am here...

1. The number of Data Source rows in your poller cache and how many you expect in the future?

I currently have: 58535 rows in my poller cache, (Cacti > System utilities > veiw poller_cache > 58535 rows) how can one guesstimate how much is needed in the future. Is there a good number I can throw at this to not have to think about it e.g. 300,000?

How do I get the maximum length of a row? I could not see a poller_cache table


The maximum size of any result stored into the poller_output table as updates occur

How do I get such results? I

Code: Select all

(root@localhost) [cacti]> show table status from cacti like 'poller_output';
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| Name          | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation         | Checksum | Create_options | Comment |
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| poller_output | MyISAM |      10 | Dynamic    |   48 |             60 |      189668 | 281474976710655 |       246784 |    186776 |           NULL | 2015-01-08 16:12:01 | 2015-01-08 16:25:27 | NULL       | latin1_swedish_ci |     NULL |                |         |
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
1 row in set (0.00 sec)

My max data length looks to be: 281474976710655 bytes...

Your current max_heap_table_size variable in MySQL?

Code: Select all

(root@localhost) [cacti]> select @@max_heap_table_size;
+-----------------------+
| @@max_heap_table_size |
+-----------------------+
|             536870912 |
+-----------------------+
1 row in set (0.00 sec)

Optimizing the database: should I be using phpMyAdmin or mysqltuner give it 24 hours and check the stats and optimize as so or is there a recommended /etc/my.cnf config that relates to the cacti db with peak performance?

Sorry a little overwhelmed and inexperienced, to set this up correct and could do with some advice before I install Boost and break the system...


Thanks