change MySQL System Variable cannot startDB

[joeryo]

Hi all, i have install cacti window version , cacti recommend change the MySQL System Variable ,after change System Variable in my.ini file DB cannot start , any one can help?

max_heap_table_size 16 M >= 191.99 M
join_buffer_size 64 M >= 383.99 M
innodb_buffer_pool_size 8 M >= 2999.89 M


FATAL: Connection to Cacti database failed. Please ensure:

the PHP MySQL module is installed and enabled.
the database is running.
the credentials in config.php are valid.

[cigamit]

Depending on your Database version, they removed some of those variables in newer versions, so if you check the logs, you will probably see it saying that the config variable doesn't exist.

[cigamit]

Also, did you enter "191.99 M" for the value? You might try it without decimals.

[TheWitness]

Maybe we should be rounding to 0.

[Achea9]

Hi,

I think it is obvious, that you can't start your DB after you insert " >= " signes for a value in your my.cnf. Please decide for values like:

max_heap_table_size = 192 M
join_buffer_size = 384 M
innodb_buffer_pool_size = 2000 M

after that save the file and check, but not you put the suggestions back as values.

cheers