Debian Codegraph @

mysql-test/suite/x/r/performance_schema_threads.result

raw
1 CREATE USER 'user_on_localhost'@localhost;
2 CREATE USER 'user_on_127_0_0_1'@127.0.0.1;
3 GRANT SELECT ON *.* TO 'user_on_localhost'@localhost;
4 GRANT SELECT ON *.* TO 'user_on_127_0_0_1'@127.0.0.1;
5 #
6 # Get actual number of worker threads
7 #
8 include/assert.inc [X Plugin must have idle worker threads]
9 #
10 # Assert all significant columns in thread table
11 #
12 include/assert.inc [All workers must have NULL in field `CONNECTION_TYPE`]
13 include/assert.inc [All workers must have NULL in field `PROCESSLIST_USER`]
14 include/assert.inc [All workers must have NULL in field `PROCESSLIST_HOST`]
15 include/assert.inc [All workers must have NULL in field `PROCESSLIST_DB`]
16 include/assert.inc [All workers must have NULL in field `PROCESSLIST_COMMAND`]
17 include/assert.inc [All workers must have NULL in field `PROCESSLIST_TIME`]
18 include/assert.inc [All workers must have NULL in field `PROCESSLIST_STATE`]
19 include/assert.inc [All workers must have NULL in field `PROCESSLIST_INFO`]
20 include/assert.inc [All workers must have NULL in field `PROCESSLIST_COMMAND`]
21 include/assert.inc [All workers must have NULL in field `PROCESSLIST_ID`]
22 Login OK
23 Verify [Current process needs to have x_root in PROCESSLIST_USER column]
24 Verify [Current process needs to have localhost in PROCESSLIST_HOST column]
25 Verify [Current process needs to have performance_schema in PROCESSLIST_DB column]
26 Verify [Current process needs to have performance_schema in PROCESSLIST_DB column]
27 Verify [Current process needs to have TCP/IP in CONNECTION_TYPE column]
28 Verify [Current process needs to have TCP/IP in CONNECTION_TYPE column]
29 Verify [Current process needs to have Query in PROCESSLIST_COMMAND column]
30 ok
31 Login OK
32 Verify [Current process needs to have user_on_127_0_0_1 in PROCESSLIST_USER column]
33 Verify [Current process needs to have localhost in PROCESSLIST_HOST column]
34 Verify [Current process needs to have mysql in PROCESSLIST_DB column]
35 Verify [Current process needs to have mysql in PROCESSLIST_DB column]
36 Verify [Current process needs to have TCP/IP in CONNECTION_TYPE column]
37 Verify [Current process needs to have TCP/IP in CONNECTION_TYPE column]
38 Verify [Current process needs to have Query in PROCESSLIST_COMMAND column]
39 ok
40 Login OK
41 Verify [Current process needs to have user_on_localhost in PROCESSLIST_USER column]
42 Verify [Current process needs to have localhost in PROCESSLIST_HOST column]
43 Verify [Current process needs to have sys in PROCESSLIST_DB column]
44 Verify [Current process needs to have sys in PROCESSLIST_DB column]
45 Verify [Current process needs to have TCP/IP in CONNECTION_TYPE column]
46 Verify [Current process needs to have TCP/IP in CONNECTION_TYPE column]
47 Verify [Current process needs to have Query in PROCESSLIST_COMMAND column]
48 ok
49 #
50 # Get actual number of worker threads
51 #
52 include/assert.inc [X Plugin must have idle worker threads]
53 #
54 # Assert all significant columns in thread table
55 #
56 include/assert.inc [All workers must have NULL in field `CONNECTION_TYPE`]
57 include/assert.inc [All workers must have NULL in field `PROCESSLIST_USER`]
58 include/assert.inc [All workers must have NULL in field `PROCESSLIST_HOST`]
59 include/assert.inc [All workers must have NULL in field `PROCESSLIST_DB`]
60 include/assert.inc [All workers must have NULL in field `PROCESSLIST_COMMAND`]
61 include/assert.inc [All workers must have NULL in field `PROCESSLIST_TIME`]
62 include/assert.inc [All workers must have NULL in field `PROCESSLIST_STATE`]
63 include/assert.inc [All workers must have NULL in field `PROCESSLIST_INFO`]
64 include/assert.inc [All workers must have NULL in field `PROCESSLIST_COMMAND`]
65 include/assert.inc [All workers must have NULL in field `PROCESSLIST_ID`]
66 DROP USER 'user_on_localhost'@localhost;
67 DROP USER 'user_on_127_0_0_1'@127.0.0.1;