Allow setting of query cache size

http://www.virtualmin.com/node/18275

diff --git a/mysql/lang/en b/mysql/lang/en
index 57f00c9..ee8441e 100644 (file)
--- a/mysql/lang/en
+++ b/mysql/lang/en
@@ -746,6 +746,7 @@ cnf_edatadir=Missing or invalid database files directory
 cnf_key_buffer=Key buffer size
 cnf_max_allowed_packet=Maximum packet size
 cnf_max_connections=Maximum number of connections
+cnf_query_cache_size=Query cache size in bytes
 cnf_table_cache=Tables to cache
 cnf_sort_buffer=Sort buffer size
 cnf_net_buffer_length=Network buffer size
@@ -826,6 +827,7 @@ kill_ecannot=You are not allowed to manage database connections
 kill_enone=None selected
 
 vars_title=MySQL System Variables
+vars_desc=Warning - Variables set on this page will be reset to their default values when MySQL is restarted. Permanent settings must be made on the <a href='$1'>MySQL Server Configuration</a> page.
 vars_ecannot=You are not allowed to edit system variables
 vars_name=Variable name
 vars_value=Current value

diff --git a/mysql/list_vars.cgi b/mysql/list_vars.cgi
index 436bee2..fb55963 100755 (executable)
--- a/mysql/list_vars.cgi
+++ b/mysql/list_vars.cgi
@@ -7,6 +7,8 @@ $access{'perms'} == 1 || &error($text{'vars_ecannot'});
 &ReadParse();
 %d = map { $_, 1 } split(/\0/, $in{'d'});
 
+print &text('vars_desc', 'edit_cnf.cgi'),"<p>\n";
+
 # Work out which ones can be edited
 %canedit = map { $_->[0], 1 } &list_system_variables();
 

diff --git a/mysql/mysql-lib.pl b/mysql/mysql-lib.pl
index 8283488..676fc7c 100755 (executable)
--- a/mysql/mysql-lib.pl
+++ b/mysql/mysql-lib.pl
@@ -86,7 +86,8 @@ $old_db_priv_cols = $mysql_version >= 4 ? 12 : 10;
 @mysql_set_variables = ( "key_buffer", "max_allowed_packet",
                         "sort_buffer", "net_buffer_length",
                         "myisam_sort_buffer_size" );
-@mysql_number_variables = ( "table_cache", "max_connections" );
+@mysql_number_variables = ( "table_cache", "max_connections",
+                           "query_cache_size" );
 
 # make_authstr([login], [pass], [host], [port], [sock])
 sub make_authstr