MariaDB tuning error

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
ftor105
Posts: 1
Joined: Fri Sep 01, 2017 10:03 am

MariaDB tuning error

Post by ftor105 »

Hello.

I've installed cacti using this HOWTO: https://www.tecmint.com/install-cacti-n ... ora-17-12/
But, I had to reinstall MariaDB, because using this HOWTO I got v5.5.52

So, in the end, my CentOS is 7.3.1611 (Core)
MariaDB 10.0.32

I am on the last step of this howto (where you connect to cacti using its IP address) and there I get Cacti Installation Wizard saying this:
Screenshot_3.png
Screenshot_3.png (91.29 KiB) Viewed 1358 times
After this I've tried to modify the file /etc/my.cnf using mcedit, but when I simply wrote the new values as in the shown picture
for example: max_heap_table_size=75M
and when I try to run mariadb typing mysql I get an error, stating that mariadb isn't running because of unknown variable 'max_heap_table_size=75M'

So, my question is, how do you "tune" mariadb using my.cnf file?
User avatar
Linegod
Developer
Posts: 1626
Joined: Thu Feb 20, 2003 10:16 am
Location: Canada
Contact:

Re: MariaDB tuning error

Post by Linegod »

Make sure 'max_heap_table_size' is under '[mysqld]' and not another subsection
--
Live fast, die young
You're sucking up my bandwidth.

J.P. Pasnak,CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests