network profile
| bio | website | |
|---|---|---|
| location | Yangon, Myanmar | |
| age | 29 | |
| visits | member for | 6 months |
| seen | Apr 15 at 6:04 | |
| stats | profile views | 3 |
I started my professional web developer life in 2005 once I graduated Computer Science.
I have been using PHP/MySQL on Windows and sometimes I use Visual FoxPro for desktop apps.
I'm a Drupal fan. Most often, I'm on Drupal Answers. Occasionally I'm on SO, Dojo and Foxite.
I live in the most interesting country in South East Asia, also called Golden Land Myanmar.
|
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 |
|
Dec 4 |
awarded | Supporter |
