#At bzr+ssh://bk-internal.mysql.com/bzrroot/mysql-falcon/
255 Hakan Kuecuekyilmaz 2008-09-10
Setting innodb_max_dirty_pages_pct to 70. I got this hint
from Vadim:
"We did not do any special investigation around innodb_max_dirty_pages_pct
to show you results, we think in this case InnoDB will be less aggressive
in flushing dirty buffer pool pages on disk. With default configuration we
see there are periodical significant drops of TPM when InnoDB starts
flushing process."
modified:
dbt2/weekly_dbt2_overview.sh
=== modified file 'dbt2/weekly_dbt2_overview.sh'
--- a/dbt2/weekly_dbt2_overview.sh 2008-09-09 03:40:20 +0000
+++ b/dbt2/weekly_dbt2_overview.sh 2008-09-10 17:31:03 +0000
@@ -188,6 +188,7 @@ MYSQLD_CONFIG_INNODB="$MYSQLD_CONFIG_GEN
--innodb_doublewrite=0 \
--innodb-status-file=0 \
--skip-innodb-adaptive-hash-index \
+ --innodb_max_dirty_pages_pct = 70 \
--innodb_thread_concurrency=0"
# </CONFIGURATION>
| Thread |
|---|
| • bzr commit into mysql-falcon branch (hky:255) | Hakan Kuecuekyilmaz | 10 Sep |