This is a short one but hopefully it helps avoid some head-into-wall action:

You’re setting values in your my.cnf file, wherever that may be, but MySQL doesn’t seem to be picking them up?

The most common cause we run across is that there are OTHER my.cnf files on your server, and MySQL only reads the first one it finds which might not be the one you’re editing.

Look in the following locations:

  • /etc/my.cnf
  • /usr/local/my.cnf
  • /usr/local/etc/my.cnf
  • /var/lib/mysql/my.cnf
  • /var/db/mysql/my.cnf

Or break out locate and find anywhere you have them via locate my.cnf

As a finishing comment, one other issue could be that you have a typo in the variable setting and it’s being ignored, check your MySQL error log if you’re still having issues.

Good luck!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.