|
1455.2.2
by Joe Daly
lower the max number of users that are tracked, the default of 10000 is to high when testing with valgrind, this causes the server to start up slow and tests to try and connect before its running |
1 |
# This test creates 750 users which is 250 over the max specified by system variables
|
|
1320.5.14
by Joe Daly
add max user test, and get it to work |
2 |
|
3 |
--disable_warnings |
|
4 |
DROP TABLE IF EXISTS a; |
|
5 |
--enable_warnings |
|
6 |
CREATE TABLE a (i int, PRIMARY KEY (i)); |
|
7 |
||
|
1999.1.3
by Brian Aker
Merge in Monty. Two changes were made: |
8 |
--echo Create 750 users |
|
1320.5.14
by Joe Daly
add max user test, and get it to work |
9 |
--disable_query_log |
|
1455.2.2
by Joe Daly
lower the max number of users that are tracked, the default of 10000 is to high when testing with valgrind, this causes the server to start up slow and tests to try and connect before its running |
10 |
let $1=750; |
|
1320.5.14
by Joe Daly
add max user test, and get it to work |
11 |
let $2=0; |
12 |
while ($1) |
|
13 |
{
|
|
14 |
inc $2; |
|
15 |
connect (con3, localhost, $2,,); |
|
16 |
eval INSERT INTO a VALUES ($2); |
|
|
1999.1.3
by Brian Aker
Merge in Monty. Two changes were made: |
17 |
connection default; |
|
1320.5.14
by Joe Daly
add max user test, and get it to work |
18 |
disconnect con3; |
19 |
dec $1; |
|
20 |
}
|
|
21 |
--enable_query_log |
|
22 |
--sleep 1 |
|
|
1999.1.3
by Brian Aker
Merge in Monty. Two changes were made: |
23 |
SELECT
|
24 |
IF(COUNT_SELECT, "NO", "YES"), |
|
25 |
IF(COUNT_DELETE, "NO", "YES"), |
|
26 |
IF(COUNT_UPDATE, "NO", "YES"), |
|
27 |
IF(COUNT_INSERT, "YES", "NO"), |
|
28 |
IF(COUNT_ROLLBACK, "NO", "YES"), |
|
29 |
IF(COUNT_COMMIT, "NO", "YES"), |
|
30 |
IF(COUNT_CREATE, "NO", "YES"), |
|
31 |
IF(COUNT_ALTER, "NO", "YES"), |
|
32 |
IF(COUNT_DROP, "NO", "YES"), |
|
33 |
IF(COUNT_ADMIN, "NO", "YES") |
|
34 |
FROM DATA_DICTIONARY.CUMULATIVE_SQL_COMMANDS ORDER BY USER + 0 ASC; |
|
|
1320.5.27
by Joe Daly
merge trunk, and add drop table calls and end of logging_stats tests where needed |
35 |
|
|
1491.4.25
by Joe Daly
disable logging_stats plugin and rename GLOBAL_STATEMENTS and SESSION_STATEMENTS tables to remove NEW tag |
36 |
|
37 |
SHOW CREATE TABLE data_dictionary.GLOBAL_STATEMENTS; |
|
38 |
--replace_column 1 # |
|
39 |
SELECT count(*) FROM data_dictionary.GLOBAL_STATEMENTS; |
|
|
1999.1.5
by Brian Aker
Fix up the tests, remove flush. |
40 |
--replace_column 2 # |
|
1491.4.25
by Joe Daly
disable logging_stats plugin and rename GLOBAL_STATEMENTS and SESSION_STATEMENTS tables to remove NEW tag |
41 |
SELECT * FROM data_dictionary.GLOBAL_STATEMENTS; |
|
1491.4.7
by Joe Daly
add tests for SESSION_STATEMENTS_NEW and GLOBAL_STATEMENTS_NEW table |
42 |
|
|
1320.5.27
by Joe Daly
merge trunk, and add drop table calls and end of logging_stats tests where needed |
43 |
DROP TABLE a; |