~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/logging_stats/tests/t/max_user.test

• browse files at revision 1291
• compare with another revision
• download diff
• download tarball
• view history from revision 1291

Show diffs side-by-side

added

removed

plugin/logging_stats/tests/t/max_user.test

 

1

# This test creates 750 users which is 250 over the max specified by system variables

 

2

 

 

3

--disable_warnings

 

4

DROP TABLE IF EXISTS a;

 

5

--enable_warnings

 

6

CREATE TABLE a (i int,  PRIMARY KEY (i));

 

7

 

 

8

--echo Create 750 users  

 

9

--disable_query_log

 

10

let $1=750;

 

11

let $2=0;

 

12

while ($1)

 

13

{

 

14

  inc $2;

 

15

  connect (con3, localhost, $2,,);

 

16

  eval INSERT INTO a VALUES ($2);

 

17

  connection default; 

 

18

  disconnect con3;

 

19

  dec $1;

 

20

}

 

21

--enable_query_log

 

22

--sleep 1

 

23

SELECT * FROM DATA_DICTIONARY.CUMULATIVE_SQL_COMMANDS ORDER BY USER + 0 ASC;

 

24

 

 

25

DROP TABLE a;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1