Created
June 22, 2020 06:55
-
-
Save youtux/02d02300d968423add1e60f45968f75f to your computer and use it in GitHub Desktop.
MySQL configuration with query log and fix for mac os file limit
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Default Homebrew MySQL server config | |
| [mysqld] | |
| # Only allow connections from localhost | |
| bind-address = 127.0.0.1 | |
| general_log_file = /usr/local/var/mysql/Argon.local.log | |
| general_log = ON | |
| # Since MySQL 5.6 innodb_file_per_table option is ON by default, | |
| # which means that each table's data is stored in its own file. | |
| # OSX default limit of the number of the open files is 256 per process. | |
| # This will cause errors like "ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32" | |
| # when connecting to mysql | |
| innodb_file_per_table = OFF |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment