Mysql Tuning.

azib · Post by **azib** » Sat May 13, 2017 3:47 am

Dear Community,
I have installed cacti & during installation i faces some issues. Mysql tuning screen shot is attached. please guide, How do I fix these errors.

Regards'

Osiris · Post by **Osiris** » Mon May 15, 2017 1:22 am

They go into the my.cnf file in /etc/. Take care to make a backup just in case you blow things up. Changing the character codes is not easy. Best to start with a fresh install. But if you are not using a foreign language, then they can stay latin.

azib · Post by **azib** » Mon May 15, 2017 3:13 am

It is a fresh install & I got these recommendations during installation. I have tried using edit my.cnf file but when I edit my.cnf file mysqld service will not be start.

Regards'

amazen123 · Post by **amazen123** » Mon May 15, 2017 8:35 pm

Can you post here the config on my.cnf?

azib · Post by **azib** » Tue May 16, 2017 7:43 am

Here is the output of my.cnf file.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Regards'

amazen123 · Post by **amazen123** » Wed May 17, 2017 4:03 am

Just add all the red variable to your my.cnf and the value should be same with recommended value.

like this
[mysqld]
max_heap_table_size=49M
max_allowed_packet=16777216

After you edit the my.cnf restart your mariadb service.

azib · Post by **azib** » Wed May 17, 2017 6:28 am

Now I am getting Directory permission error. Screen shot is attached. Please review & guide accordingly.

Regards'

phalek · Post by **phalek** » Wed May 17, 2017 6:36 am

Did you read the text in that screenshot ? It tells you what to do right there ...

azib · Post by **azib** » Wed May 17, 2017 6:58 am

I read the text in the screen shot & perform the same step as suggested but still getting the same error.

Regards'

amazen123 · Post by **amazen123** » Wed May 17, 2017 7:30 pm

Does the /resource/snmp_queries has the same permission as /cacti/scripts?

azib · Post by **azib** » Thu May 18, 2017 12:28 am

It has the same permission as cacti/scripts. Screen shots are attached. Please review & guide.

Regards'

amazen123 · Post by **amazen123** » Thu May 18, 2017 8:19 pm

Hmmm that's weird, the permission is correct so I don't know why it gives error that it's not writable.

cigamit · Post by **cigamit** » Sun May 21, 2017 1:52 pm

Is SELinux enabled?

Sumdzik · Post by **Sumdzik** » Sun May 21, 2017 2:55 pm

I had the same problem. Disabling SELinux (setenforce 0) helped.

ghie11 · Post by **ghie11** » Tue Jul 18, 2017 8:55 pm

I had the same problem on my mysql tuning, i have tried using this config..but i got error on my cacti database

Cacti

Mysql Tuning.

Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Re: Mysql Tuning.

Who is online