[Commits] Rev 3011: Allow one to decrease page-buffer-size down to 1M (from 128M) for maria_read_log in lp:maria/5.1

Michael Widenius monty at askmonty.org
Wed Jan 12 01:48:35 EET 2011


At lp:maria/5.1

------------------------------------------------------------
revno: 3011
revision-id: monty at askmonty.org-20110111234834-sa6nr6ml6g2adh61
parent: monty at askmonty.org-20110111124233-gv3a4sa65rdqfzn6
committer: Michael Widenius <monty at askmonty.org>
branch nick: maria-5.1
timestamp: Wed 2011-01-12 01:48:34 +0200
message:
  Allow one to decrease page-buffer-size down to 1M (from 128M) for maria_read_log
  Don't allow too low value of pagecache_buffer_size for mysqld
-------------- next part --------------
=== modified file 'storage/maria/ha_maria.cc'
--- a/storage/maria/ha_maria.cc	2011-01-07 15:58:12 +0000
+++ b/storage/maria/ha_maria.cc	2011-01-11 23:48:34 +0000
@@ -191,7 +191,7 @@ static MYSQL_SYSVAR_ULONGLONG(pagecache_
        "The size of the buffer used for index blocks for Maria tables. "
        "Increase this to get better index handling (for all reads and "
        "multiple writes) to as much as you can afford.", 0, 0,
-       KEY_CACHE_SIZE, MALLOC_OVERHEAD, ~(ulong) 0, IO_SIZE);
+       KEY_CACHE_SIZE, 8192*16L, ~(ulong) 0, IO_SIZE);
 
 static MYSQL_SYSVAR_ULONG(pagecache_division_limit, pagecache_division_limit,
        PLUGIN_VAR_RQCMDARG,

=== modified file 'storage/maria/maria_read_log.c'
--- a/storage/maria/maria_read_log.c	2011-01-11 12:42:33 +0000
+++ b/storage/maria/maria_read_log.c	2011-01-11 23:48:34 +0000
@@ -199,7 +199,8 @@ static struct my_option my_long_options[
     "Path to the directory where to store transactional log",
     (uchar **) &maria_data_root, (uchar **) &maria_data_root, 0,
     GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
-  { "page-buffer-size", 'P', "",
+  { "page-buffer-size", 'P',
+    "The size of the buffer used for index blocks for Maria tables",
     &opt_page_buffer_size, &opt_page_buffer_size, 0,
     GET_ULONG, REQUIRED_ARG, (long) USE_BUFFER_INIT,
     1024L*1024L, (long) ~(ulong) 0, (long) MALLOC_OVERHEAD,



More information about the commits mailing list