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 since 2005 based in Yangon, Myanmar (Burma). 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


Sep
24
awarded  Autobiographer
Sep
5
awarded  Popular Question
Feb
3
awarded  Notable Question
Aug
21
revised Dynamic change to innodb_flush_log_at_trx_commit
edited tags
Aug
20
awarded  Popular Question
Apr
14
accepted Where is the MySQL variable - innodb_flush_method?
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
13
awarded  Editor
Dec
13
revised Where is the MySQL variable - innodb_flush_method?
added 206 characters in body
Dec
13
asked Where is the MySQL variable - innodb_flush_method?
Dec
11
awarded  Scholar
Dec
11
accepted Dynamic change to innodb_flush_log_at_trx_commit
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
awarded  Student
Dec
7
comment Dynamic change to innodb_flush_log_at_trx_commit
Thanks for your great answer. I will try it.
Dec
7
asked Dynamic change to innodb_flush_log_at_trx_commit