Cacti Spine

Add in crontab these 2 scrypts to rebuild poller cache and reindex hosts in databse

27 3 * * * www /usr/local/bin/php -q /usr/local/www/html/cacti/cli/rebuild_poller_cache.php > /dev/null 2>&1

52 3 * * * www /usr/local/bin/php -q /usr/local/www/html/cacti/cli/poller_reindex_hosts.php -id=All > /dev/null 2>&1

Минимални настройки на php.ini – Колкото повече, толкова повече!

max_execution_time = 180 ; Maximum execution time of each script, in seconds

max_input_time = 180 ; Maximum amount of time each script may spend parsing request data;

max_input_nesting_level = 64 ; Maximum input variable nesting level

memory_limit = 512M ; Maximum amount of memory a script may consume

short_open_tag = On

upload_max_filesize = 24M

post_max_size = 24M

Минимална конфигурация на my.cnf – за препоръчване да се ползва тази от статс-а, защото е преправена (направена)

[mysqld]

# MOST IMPORTANT FOR SPINE/BOOST PERFORMANCE

tmp_table_size = 512M

max_heap_table_size = 512M

# SOME TUNING

key_buffer = 256M

max_allowed_packet = 16M

myisam_sort_buffer_size = 32M

net_buffer_length = 8K

query_cache_size = 128M

read_buffer_size = 1M

read_rnd_buffer_size = 32M

skip-external-locking

sort_buffer_size = 128M

table_open_cache = 1024

table_definition_cache = 1024

# ENABLE LOGGING SLOW QUERIES

log_slow_queries

long_query_time = 2

log_queries_not_using_indexes = 1

# DISABLE BIN LOG

#log-bin=mysql-bin

#binlog_format=mixed

Слага се boost plugin за cacti. Прави се папка, в която да кешира rra-тата