120 reputation
17
bio website sithukyaw.com
location Yangon, Myanmar
age 31
visits member for 1 year, 11 months
seen Sep 25 at 9:50

Professional dedicated web developer based in Yangon, Myanmar (Burma) since 2005. PHP/MySQL/Apache is primary trend and occasionally use Visual FoxPro, a powerful data-centric procedural programming, for desktop application development.

Original creator and core developer at PHPLucidFrame.

I'm a Drupal fan and also available on Drupal Answers.

profile for Sithu on Stack Exchange, a network of free, community-driven Q&A sites


Apr
14
comment Where is the MySQL variable - innodb_flush_method?
Thank you @RolandoMySQLDBA.
Dec
14
comment Where is the MySQL variable - innodb_flush_method?
Thank you, Rolando. I found that have_innodb=YES and #skip-innodb. So, InnoDB engine is already available. When I added innodb_flush_method=O_DIRECT under the [mysqld] section, I could not restart mysql. I got the error "Windows could not start the mysql service on Local Computer. Error 1067 the process terminated unexpectedly". When I removed that line, I could restart the server. I could not add that variable anywhere in the file. Any idea?
Dec
11
comment Dynamic change to innodb_flush_log_at_trx_commit
@DTest, Thanks for your answer. According to my deep test, it did work dynamically. In my localhost, the session variable was changed without running connect ( I got error when issue connect ). With the value 2, importing 2,241,319 records took 27 mins 43 secs, whereas it took about 1 days with the value 1. The setting seems to be working in the current session but it restored the original setting (from my.cnf) after restart.
Dec
11
comment Dynamic change to innodb_flush_log_at_trx_commit
Thanks for your UPDATE, I got it too, I just wondered why we can't see its value. Since I could not find it in my.ini or my.cnf and it is not a dynamic variable, I'm not sure how can I configure it.
Dec
10
comment Dynamic change to innodb_flush_log_at_trx_commit
I noticed that regardless of server version or ini/cnf, the configuration file does not have innodb_flush_method setting and SHOW VARIABLES doesn't show it.
Dec
9
comment Dynamic change to innodb_flush_log_at_trx_commit
I tested in my localhost first. I could not find innodb_flush_method in my.ini (not my.cnf). Server information - Apache 2.4.1, PHP 5.4.4, MySQL 5.5
Dec
7
comment Dynamic change to innodb_flush_log_at_trx_commit
Thanks for your great answer. I will try it.