4341 Mayank Prasad 2012-08-29
wl#6372 : Post-Iris changes to Server defaults
Details:
- Fixing MTR Test cases part4.
added:
mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_again_allow-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_bad_allow-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_good_allow-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_noname_allow-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv4_blocked-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv4_max_con-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_noname_deny-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv4_ssl-master.opt
mysql-test/suite/perfschema/t/stage_mdl_global-master.opt
modified:
mysql-test/include/default_mysqld_autosize.cnf
mysql-test/suite/perfschema/t/event_aggregate_no_u-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_deny-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_allow-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_deny-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv6_max_con-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_deny-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_deny-master.opt
mysql-test/suite/perfschema/t/hostcache_ipv6_ssl-master.opt
mysql-test/suite/perfschema/t/threads_mysql-master.opt
mysql-test/suite/sys_vars/r/sort_buffer_size_basic_64.result
4340 Mayank Prasad 2012-08-29
wl#6372 : Post-Iris changes to Server defaults
Details:
- Fixing MTR Test cases part3.
added:
mysql-test/suite/sys_vars/t/query_cache_wlock_invalidate_func-master.opt
modified:
mysql-test/suite/sys_vars/r/sort_buffer_size_basic_32.result*
mysql-test/suite/sys_vars/r/thread_cache_size_basic.result
=== modified file 'mysql-test/include/default_mysqld_autosize.cnf'
--- a/mysql-test/include/default_mysqld_autosize.cnf revid:mayank.prasad@stripped
+++ b/mysql-test/include/default_mysqld_autosize.cnf revid:mayank.prasad@stripped
@@ -33,7 +33,7 @@ loose-innodb_lru_scan_depth= 100
loose-innodb_write_io_threads= 2
loose-innodb_read_io_threads= 2
loose-innodb_log_buffer_size= 1M
-loose-innodb_log_file_size= 5M
+loose-innodb_log_file_size= 48M
loose-innodb_additional_mem_pool_size= 1M
loose-innodb_log_files_in_group= 2
=== modified file 'mysql-test/suite/perfschema/t/event_aggregate_no_u-master.opt'
--- a/mysql-test/suite/perfschema/t/event_aggregate_no_u-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/event_aggregate_no_u-master.opt revid:mayank.prasad@stripped
@@ -1,3 +1,4 @@
--general_log
--log-output=FILE
--loose-performance_schema_users_size=0
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_again_allow-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_again_allow-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_again_allow-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_bad_allow-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_bad_allow-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_bad_allow-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_good_allow-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_good_allow-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_good_allow-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_noname_allow-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_noname_allow-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_noname_allow-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_blocked-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_blocked-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_blocked-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_max_con-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_max_con-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_max_con-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_noname_deny-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_noname_deny-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_noname_deny-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/hostcache_ipv4_ssl-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_ssl-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_ssl-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--thread_cache_size=0
=== modified file 'mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_deny-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_deny-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_deny-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--bind-addr=::
+--thread_cache_size=0
=== modified file 'mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_allow-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_allow-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_allow-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--bind-addr=::
+--thread_cache_size=0
=== modified file 'mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_deny-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_deny-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_deny-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--bind-addr=::
+--thread_cache_size=0
=== modified file 'mysql-test/suite/perfschema/t/hostcache_ipv6_max_con-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv6_max_con-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv6_max_con-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--bind-addr=::
+--thread_cache_size=0
=== modified file 'mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_deny-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_deny-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_deny-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--bind-addr=::
+--thread_cache_size=0
=== modified file 'mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_deny-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_deny-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_deny-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--bind-addr=::
+--thread_cache_size=0
=== modified file 'mysql-test/suite/perfschema/t/hostcache_ipv6_ssl-master.opt'
--- a/mysql-test/suite/perfschema/t/hostcache_ipv6_ssl-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv6_ssl-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--bind-addr=::
+--thread_cache_size=0
=== added file 'mysql-test/suite/perfschema/t/stage_mdl_global-master.opt'
--- a/mysql-test/suite/perfschema/t/stage_mdl_global-master.opt 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/perfschema/t/stage_mdl_global-master.opt revid:mayank.prasad@stripped
@@ -0,0 +1 @@
+--query_cache_type=1
=== modified file 'mysql-test/suite/perfschema/t/threads_mysql-master.opt'
--- a/mysql-test/suite/perfschema/t/threads_mysql-master.opt revid:mayank.prasad@stripped
+++ b/mysql-test/suite/perfschema/t/threads_mysql-master.opt revid:mayank.prasad@stripped
@@ -1 +1,2 @@
--event-scheduler
+--thread_cache_size=0
=== modified file 'mysql-test/suite/sys_vars/r/sort_buffer_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/sort_buffer_size_basic_64.result revid:mayank.prasad@stripped
+++ b/mysql-test/suite/sys_vars/r/sort_buffer_size_basic_64.result revid:mayank.prasad@stripped
@@ -5,21 +5,21 @@ SET @@global.sort_buffer_size = 1000;
SET @@global.sort_buffer_size = DEFAULT;
SELECT @@global.sort_buffer_size;
@@global.sort_buffer_size
-262144
+32768
SET @@session.sort_buffer_size = 2000;
SET @@session.sort_buffer_size = DEFAULT;
SELECT @@session.sort_buffer_size;
@@session.sort_buffer_size
-262144
+32768
'#--------------------FN_DYNVARS_151_02-------------------------#'
SET @@global.sort_buffer_size = DEFAULT;
SELECT @@global.sort_buffer_size;
@@global.sort_buffer_size
-262144
+32768
SET @@session.sort_buffer_size = DEFAULT;
SELECT @@session.sort_buffer_size;
@@session.sort_buffer_size
-262144
+32768
'#--------------------FN_DYNVARS_151_03-------------------------#'
SET @@global.sort_buffer_size = 32776;
SELECT @@global.sort_buffer_size;
No bundle (reason: useless for push emails).
| Thread |
|---|
| • bzr push into mysql-trunk branch (mayank.prasad:4340 to 4341) WL#6372 | Mayank Prasad | 30 Aug |
