List:Commits« Previous MessageNext Message »
From:Georgi Kodinov Date:August 6 2010 1:52pm
Subject:bzr push into mysql-5.1-bugteam branch (Georgi.Kodinov:3477 to 3478)
Bug#54909
View as plain text  
 3478 Georgi Kodinov	2010-08-06
      Bug #54909: Confusing description about read_buffer_size and
      read_rnd_buffer_size
      
      Applied the updated description from Paul's patch.

    modified:
      support-files/my-innodb-heavy-4G.cnf.sh
 3477 Bjorn Munch	2010-08-06
      Bug #55503 MTR fails to filter LEAK SUMMARY from valgrind report of restarted servers
      Undo workaround as fix is being merged in

    modified:
      mysql-test/suite/innodb_plugin/t/innodb-autoinc-44030.test
      mysql-test/suite/innodb_plugin/t/innodb-autoinc.test
=== modified file 'support-files/my-innodb-heavy-4G.cnf.sh'
--- a/support-files/my-innodb-heavy-4G.cnf.sh	2009-03-31 14:04:01 +0000
+++ b/support-files/my-innodb-heavy-4G.cnf.sh	2010-08-06 12:56:23 +0000
@@ -109,6 +109,16 @@ binlog_cache_size = 1M
 # table which could otherwise use up all memory resources.
 max_heap_table_size = 64M
 
+# Size of the buffer used for doing full table scans.
+# Allocated per thread, if a full scan is needed.
+read_buffer_size = 2M
+
+# When reading rows in sorted order after a sort, the rows are read
+# through this buffer to avoid disk seeks. You can improve ORDER BY
+# performance a lot, if set this to a high value.
+# Allocated per thread, when needed.
+read_rnd_buffer_size = 16M
+
 # Sort buffer is used to perform sorts for some ORDER BY and GROUP BY
 # queries. If sorted data does not fit into the sort buffer, a disk
 # based merge sort is used instead - See the "Sort_merge_passes"
@@ -310,16 +320,6 @@ server-id = 1
 # used for internal temporary disk tables.
 key_buffer_size = 32M
 
-# Size of the buffer used for doing full table scans of MyISAM tables.
-# Allocated per thread, if a full scan is needed.
-read_buffer_size = 2M
-
-# When reading rows in sorted order after a sort, the rows are read
-# through this buffer to avoid disk seeks. You can improve ORDER BY
-# performance a lot, if set this to a high value.
-# Allocated per thread, when needed.
-read_rnd_buffer_size = 16M
-
 # MyISAM uses special tree-like cache to make bulk inserts (that is,
 # INSERT ... SELECT, INSERT ... VALUES (...), (...), ..., and LOAD DATA
 # INFILE) faster. This variable limits the size of the cache tree in


Attachment: [text/bzr-bundle] bzr/georgi.kodinov@oracle.com-20100806125623-wu8dpos5rtoglro3.bundle
Thread
bzr push into mysql-5.1-bugteam branch (Georgi.Kodinov:3477 to 3478)Bug#54909Georgi Kodinov6 Aug