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.
0
There are no comments made for this post yet
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.
There are no comments made for this post yet
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.
There are no comments made for this post yet
Yes, they were InnoDB settings for me too. max_connections is also important.
Lost settings for me are:
Lost settings for me are:
default-storage-engine=INNODB
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
join_buffer_size=1M
thread_cache_size=512
key_buffer_size=64M
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size=1M
innodb_buffer_pool_size = 18G
innodb_log_file_size = 256M
innodb_thread_concurrency=0
innodb_io_capacity_max=2000
innodb_io_capacity=1500
innodb_buffer_pool_instances=8
innodb_purge_threads=1
innodb_file_per_table=1
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_ft_min_token_size = 3
innodb_ft_enable_stopword = OFF
innodb_ft_cache_size = 32M
max_connections = 512
There are no comments made for this post yet
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.
Any updates here? Last week my.ini was overwritten again and caused a very udnesirable down time. Was the fix released?
There are no comments made for this post yet
Any updates here? Last week my.ini was overwritten again and caused a very udnesirable down time. Was the fix released?
Same here. Also downtime thanks to the config reset (we normally run a HUGE innodb buffer, which was reset to a tiny one which was overwhelmed immediately).
There are no comments made for this post yet
There are no comments made for this post yet
The changelog states that it was indeed fixed in Plesk 17.8.11 MU70, can you please verify?
There are no comments made for this post yet
4 weeks ago
·
#606
Hi. It seems that this "my.ini" file is no longer overwritten, for what I can see (On 12.5 and Onyx)
However, the very last question relates to Plesk Obsidian :
"In Which "MY.INI" file" do we need to set our parameters in Plesk Obsidian ?"
C:\Program Files (x86)\Plesk\Databases\MySQL\my.ini (File containing some parameters, and not stating it will be overwritten : it seems to be THE FILE to write into ...)
C:\Program Files (x86)\Plesk\Databases\MySQL\Data\my.ini (Very light file not containing a lot)
C:\Program Files (x86)\Plesk\MySQL\Data\my.ini (Very light file not containing a lot)
C:\Program Files (x86)\Plesk\MySQL\my.ini (Stated at the top of file that these changes will be overwritten)
Thanks for your help, for me, and for the community members coming to this page !
However, the very last question relates to Plesk Obsidian :
"In Which "MY.INI" file" do we need to set our parameters in Plesk Obsidian ?"
C:\Program Files (x86)\Plesk\Databases\MySQL\my.ini (File containing some parameters, and not stating it will be overwritten : it seems to be THE FILE to write into ...)
C:\Program Files (x86)\Plesk\Databases\MySQL\Data\my.ini (Very light file not containing a lot)
C:\Program Files (x86)\Plesk\MySQL\Data\my.ini (Very light file not containing a lot)
C:\Program Files (x86)\Plesk\MySQL\my.ini (Stated at the top of file that these changes will be overwritten)
Thanks for your help, for me, and for the community members coming to this page !
There are no comments made for this post yet
MySQL that serves customer databases uses %plesk_dir%\Databases\MySQL\my.ini and that's where custom settings should go. So indeed, in your case that would be C:\Program Files (x86)\Plesk\Databases\MySQL\my.ini.
The %plesk_dir%\MySQL\my.ini is used by a different instance of MySQL, for Plesk itself.
The %plesk_dir%\MySQL\my.ini is used by a different instance of MySQL, for Plesk itself.
There are no comments made for this post yet
- Page :
- 1
- 2
There are no replies made for this post yet.