List:Commits« Previous MessageNext Message »
From:Hakan Kuecuekyilmaz Date:September 10 2008 5:32pm
Subject:bzr commit into mysql-falcon branch (hky:255)
View as plain text  
#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 Kuecuekyilmaz10 Sep