search

TablePlus / DBngin

DB Engine
https://dbngin.com
1.06k stars 19 forks source link

edit my.cnf configuration parameters #45

Closed colonelclick closed 4 years ago

colonelclick commented 4 years ago

Please fill out the detail below, it helps me investigate the bug:

  1. Driver (Ex: PostgreSQL 10.0): mysql 5.7, mysql8

  2. DBngin build number: Version 1.1 (20)

  3. macOS version: 10.15.4 (19E266)

  4. The steps to reproduce this issue: Install DBngin and try to edit my.cnf to add more memory for MySQL

I want to tune the mysql parameters because I have large databases and lots of unused ram. I do not find the .cnf files to make this possible and there are no preferences or other indicators about where to look. Can you give information on where to find these files, or even better add a screen in DBngin where we can edit my.cnf for each installation, or maybe an info screen that can tell you where all the files are for each installation.

colonelclick commented 4 years ago

I did some research and I discovered two things I could do.

I could add command line options to the plist file to manually specify an additional (or replacement) cnf file to load. This would be the best if you need different options for each version of MySQL installed.

The second option works if you want the same cnf file for all versions. Just add it to ~/.my.cnf and it will be loaded automatically for all versions from DBngin.