-1

I have to change the innodb_log_file_size variable in MySQL. I am using MySQL 8.0.31 version on MacBook Pro M1. Tried to create the configuration file under /etc/my.cnf and added configuration there and restarted server. Server is not taking configuration from that file. Configuration update on linux/ubuntu system worked well.

Created custom configuration file to load.

Vishal
  • 89
  • 1
  • 1
    How did you install MySQL? Chances are it's not `/etc/my.cnf` in your installation. If you used Homebrew, see https://stackoverflow.com/questions/7973927/for-homebrew-mysql-installs-wheres-my-cnf (be sure to read more than just the accepted answer, it has varied over time). – ceejayoz Jan 12 '23 at 12:45

1 Answers1

0

There are a few things you can try to troubleshoot this issue:

1.Make sure that the custom configuration file you created is in the correct location for your MySQL version and operating system. For MySQL 8.0.31 on macOS, the default location for the configuration file is /usr/local/mysql/my.cnf.

2.Check the permissions on the configuration file to ensure that the MySQL server process has permission to read the file.

3.Verify that the MySQL server process is actually reading the configuration file by checking the process's command line arguments or by running the 'mysqld --verbose --help' command.

4.Make sure that the settings you are trying to change are actually read by MySQL. Some settings are read by the server at startup, while others can be changed at runtime.

5.If you are still having trouble, you can try specifying the configuration file location when starting the MySQL server. For example, you can use the '--defaults-file' option when starting the server.

6.Make sure that there is no other my.cnf file in the system that may be overriding the configuration you set.

Panda
  • 11
  • 2
  • This is ChatGPT, which is banned here. Please delete this before you get into bigger trouble, because we take plagiarism seriously around here. – tchrist Jun 27 '23 at 03:10