Not the answer you need?
Register and ask your own question!

Problem with Percona 5.6 when using Configuration Wizard

nicomnicom EntrantCurrent User Role Beginner
Please help me I cant figure this problem out :

I have a problem with Percona 5.6 when using Configuration Wizard

According to the Percona Configuration Wizard I need to use the following values in the my.cnf file :
innodb-buffer-pool-size = 24G
datadir = /app/mysql/

However Percona 5.6 has discontinued the my.cnf file
So How or where do I put these values into what file to get my database to use my new and larger hard disk and the new memory I added to my database hardware ?

Is it possible to modify the Percona Configuration Wizard to generate a suitable file and give comments how to use this to implement the values it is recommending on the database server


kind regards
Nico

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    I'm not sure where you found this "Percona 5.6 has discontinued the my.cnf file"
    Even with the Percona 5.6, you can see my.cnf file at the /etc/my.cnf OR on Debian /etc/mysql/my.cnf
    If you can not see any file like this, then you can create by your own with " vim /etc/my.cnf " and add all required configuration parameters.

    Btw: I really want to know that where you have seen that PS 5.6 discontinued my.cnf :)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.