Can I set a global MySQL settings that will affect all my sites?

What issue or error are you experiencing?

I have some plugins on my WordPress site that making MySQL server write huge binlogs. To give you an idea, first time I mentioned that issue, my MySQL server produced for a single site binlogs of 300GB (yes it is Gigabytes :melting_face:)

So far, I found several way to either prevent MySQL from generating those files or reduce the maximum file sizes and maximum life time of those files, but this is a manual process I have to follow every-time I start a new project.

What I am looking for, is a for a global configuration to force Local WP to use the settings required for all my sites.

I suppose, the Local WP it has somewhere a MySQL Conf Template file that used to create new sites. May I can modify this file? If so, where this file is located ?


What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

Try run Bricks builder along with OxyProps to create a website and observe the binlogs under the path:
Local/run/SITE_ID/mysql/data/binlog.xxxxxx


System Details

  • Local Version: 7.1.0+6396

  • Operating System (OS) and OS version: Ubuntu 22.04.4 LTS


Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)


Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

Hi @merianos

I’m not certain what file you’re editing but it might be possible for you to do so and then generate a Blueprint to work with moving forward. More details about this here:

1 Like

Thank you very much @Nick-B !! This seems to be a good solution !! :slight_smile:

Kind regards
Merianos Nikos

1 Like

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.