Every few months or so, there's an update to Plesk which overwrites the my.ini settings for MySQL. I have customised these settings significantly, as the defaults have waaaaay to low max connection settings for my server.
However, when these changes are overwritten, my sites are inaccessible because I get so many connection errors and poor InnoDB performance.
How can I prevent the my.ini file from being overwritten? It's not acceptable to have to restore a backup of the file each time there is a change, as suggested by the KB article:
Custom changes in my.ini file are overwritten after microupdate
This takes my sites offline for several hours each time this happens.
However, when these changes are overwritten, my sites are inaccessible because I get so many connection errors and poor InnoDB performance.
How can I prevent the my.ini file from being overwritten? It's not acceptable to have to restore a backup of the file each time there is a change, as suggested by the KB article:
Custom changes in my.ini file are overwritten after microupdate
This takes my sites offline for several hours each time this happens.
After seeing this post. I went check my settings. It did the same thing to me. I'm on Windows 2016 version 17.8.11 Update #57. I'll have to look into the settings that were reverted. But most were related to the innodb settings. As well as the read buffer sizes and max connections and max user connections.
Can you please specify exactly which properties in my.ini you have customized?
In Plesk Obsidian we have fixed this issue already, I just need to confirm that your redefined options are covered by the fix.
If this fix covers all your options, then we consider backport of this fix in Plesk Onyx with next MySQL update to avoid such problems for you in future.
In Plesk Obsidian we have fixed this issue already, I just need to confirm that your redefined options are covered by the fix.
If this fix covers all your options, then we consider backport of this fix in Plesk Onyx with next MySQL update to avoid such problems for you in future.
- Page :
- 1
- 2
There are no replies made for this post yet.