← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/t/slow_launch_time_func.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/slow_launch_time_func.test
 
1
############# mysql-test\t\SLOW_LAUNCH_time_func.test ##########################
 
2
#                                                                              #
 
3
# Variable Name: slow_launch_time                                                                           #
 
4
# Scope: SESSION                                                               #
 
5
# Access Type: Dynamic                                                         #
 
6
# Data Type: NUMERIC                                                           #
 
7
# Default Value: 2                                                             #
 
8
# Values:      -                                                               #
 
9
#                                                                              #
 
10
#                                                                              #
 
11
# Creation Date: 2008-03-02                                                    #
 
12
# Author:  Sharique Abdullah                                                       #
 
13
#                                                                              #
 
14
# Description: Test Cases of Dynamic System Variable "slow_launch_time "       #
 
15
#              that checks behavior of this variable in the following ways     #
 
16
#              * Functionality based on different values                       #
 
17
#                                                                              #
 
18
#Reference: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#
 
19
#  option_mysqld_slow_launch_time                                              #
 
20
#                                                                              #
 
21
################################################################################
 
22
 
 
23
#
 
24
# Setup
 
25
#
 
26
 
 
27
--source include/not_embedded.inc
 
28
 
 
29
SET @global_slow_launch_time = @@GLOBAL.slow_launch_time;
 
30
 
 
31
 
 
32
--echo '#--------------------FN_DYNVARS_124_01-------------------------#'
 
33
 
 
34
#####################################
 
35
#   Increase number of connection   #
 
36
#####################################
 
37
 
 
38
--echo ** Connection default **
 
39
connection default;
 
40
 
 
41
SET @@GLOBAL.slow_launch_time=0;
 
42
SELECT @@GLOBAL.slow_launch_time;
 
43
 
 
44
--echo ** Connecting conn5 using username 'root' **
 
45
CONNECT (conn5,localhost,root,,);
 
46
--echo ** Connecting conn6 using username 'root' **
 
47
CONNECT (conn6,localhost,root,,);
 
48
--echo ** Connecting conn7 using username 'root' **
 
49
CONNECT (conn7,localhost,root,,);
 
50
--echo ** Connecting conn8 using username 'root' **
 
51
CONNECT (conn8,localhost,root,,);
 
52
--echo ** Connecting conn9 using username 'root' **
 
53
CONNECT (conn9,localhost,root,,);
 
54
--echo ** Connecting conn10 using username 'root' **
 
55
CONNECT (conn10,localhost,root,,);
 
56
--echo ** Connecting conn11 using username 'root' **
 
57
CONNECT (conn11,localhost,root,,);
 
58
--echo ** Connecting conn12 using username 'root' **
 
59
CONNECT (conn12,localhost,root,,);
 
60
--echo ** Connecting conn13 using username 'root' **
 
61
CONNECT (conn13,localhost,root,,);
 
62
--echo ** Connecting conn14 using username 'root' **
 
63
CONNECT (conn14,localhost,root,,);
 
64
--echo ** Connecting conn15 using username 'root' **
 
65
CONNECT (conn15,localhost,root,,);
 
66
--echo ** Connecting conn16 using username 'root' **
 
67
CONNECT (conn16,localhost,root,,);
 
68
 
 
69
 
 
70
#
 
71
#  Checking status of slow_launch_threads
 
72
#
 
73
 
 
74
show status like 'slow_launch_threads';
 
75
--echo 12 Expected
 
76
 
 
77
#
 
78
# Cleanup
 
79
#
 
80
 
 
81
--echo ** Connection default **
 
82
connection default;
 
83
 
 
84
--echo ** Disconnecting conn5 **
 
85
disconnect conn5;
 
86
--echo ** Disconnecting conn6 **
 
87
disconnect conn6;
 
88
--echo ** Disconnecting conn7 **
 
89
disconnect conn7;
 
90
--echo ** Disconnecting conn8 **
 
91
disconnect conn8;
 
92
--echo ** Disconnecting conn9 **
 
93
disconnect conn9;
 
94
--echo ** Disconnecting conn10 **
 
95
disconnect conn10;
 
96
--echo ** Disconnecting conn11 **
 
97
disconnect conn11;
 
98
--echo ** Disconnecting conn12 **
 
99
disconnect conn12;
 
100
--echo ** Disconnecting conn13 **
 
101
disconnect conn13;
 
102
--echo ** Disconnecting conn14 **
 
103
disconnect conn14;
 
104
--echo ** Disconnecting conn15 **
 
105
disconnect conn15;
 
106
--echo ** Disconnecting conn16 **
 
107
disconnect conn16;
 
108
 
 
109
SET @@GLOBAL.slow_launch_time = @global_slow_launch_time;