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:
Or break out
locate and find anywhere you have them via
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.