change MySQL System Variable cannot startDB

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
joeryo
Posts: 2
Joined: Sun Nov 08, 2020 9:54 pm

change MySQL System Variable cannot startDB

Post by 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
Developer
Posts: 3367
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Re: change MySQL System Variable cannot startDB

Post by 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
Developer
Posts: 3367
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Re: change MySQL System Variable cannot startDB

Post by cigamit »

Also, did you enter "191.99 M" for the value? You might try it without decimals.
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: change MySQL System Variable cannot startDB

Post by TheWitness »

Maybe we should be rounding to 0.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Achea9
Posts: 44
Joined: Mon Sep 07, 2020 3:07 am

Re: change MySQL System Variable cannot startDB

Post by 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
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest