my.ini innodb settings

[Shaka]

I want to improve the perfomance of our MySQL databases .
Every article says that we should adjust some settings in my.ini

Original settings:

innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M

intended changes:

innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=4M
innodb_buffer_pool_size=2GB
innodb_log_file_size=128M


But every time we change this settings MySQL stops working and doesnt restart
What is the problem? what we should do to optimize settings?

Thanks

 

[Shaka]

As asked here is our server info:

PRODUCT, VERSION, VERSION OF MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Windows 2008 server R2 , plesk 10

PROBLEM DESCRIPTION...refer to previous post

STEPS TO REPRODUCE
Change My.ini as explained previously

ACTUAL RESULT
Mysql doesnt work

EXPECTED RESULT
Improved MySQL perfomance

ANY ADDITIONAL INFORMATION
refer to previous post

 

[Shaka]

Nobody? Not even a single answer?

 

[IgorG]

How it is related to Plesk? Looks like it is common MySQL question. Did you try to investigate mysql logs at least?

 

[Shaka]

How it is related to Plesk? Looks like it is common MySQL question. Did you try to investigate mysql logs at least?

I think It's related with plesk because is plesk that installs 2 instances of MySQL and sets everything to work with the panel

Besides I could not finddocumentacion on where to find the MySQL logs for the clients

As you seem to have more knowledge than me , can you help pointing me so I can find these logs?
Thanks

 

[IgorG]

http://kb.parallels.com/en/111289