Click here to Skip to main content
15,891,767 members
Please Sign up or sign in to vote.
1.80/5 (2 votes)
See more:
what I know that I should do some modification on my.ini file to tune in MySQL Server after installation. and some of this actions depend on RAM Size.

this modification like :-
key_buffer_size
innodb_buffer_pool_size
innodb_additional_mem_pool_size
innodb_log_file_size
innodb_log_buffer_size
innodb_flush_log_at_trx_commit
table_cache
thread_cache
max_allowed_packet
max_sort_length 
net_write_timeout
net_read_timeout


What I have tried:

what i use it now is to edit this file my.ini Manually. but there are any correct idea to auto apply this modification.

I have thought about edit it by my project (c# project) by replace lines by the required values based on the ram size on the device, are this correct idea?

and what is your recommendation?
Posted
Updated 14-Apr-21 3:59am
Comments
[no name] 14-Apr-21 15:34pm    
Tuning is in response to an issue. One doesn't tune for the fun of it.
SeanChupas 14-Apr-21 16:12pm    
Then you'd never had a good tuning, have you. ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900