Debian Codegraph @

mysql-test/suite/ndbcluster/ndbcluster-plugins.result

raw
1 # All three ndb-plugins should be ENABLED
2 SELECT RPAD(PLUGIN_NAME, 33, ' ') 'PLUGIN_NAME ',
3 LOAD_OPTION, PLUGIN_STATUS, PLUGIN_TYPE
4 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'ndb%'
5 ORDER BY PLUGIN_NAME;
6 PLUGIN_NAME LOAD_OPTION PLUGIN_STATUS PLUGIN_TYPE
7 ndbcluster ON ACTIVE STORAGE ENGINE
8 ndbinfo ON ACTIVE STORAGE ENGINE
9 ndb_transid_mysql_connection_map ON ACTIVE INFORMATION SCHEMA
10
11 # Both ndb-engines should be enabled (SUPPORT YES)
12 SELECT RPAD(ENGINE, 10, ' ') 'ENGINE ', SUPPORT
13 FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE LIKE 'ndb%' ORDER BY ENGINE;
14 ENGINE SUPPORT
15 ndbcluster YES
16 ndbinfo YES
17
18 # ndb schemas
19 SELECT DISTINCT TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES
20 WHERE TABLE_SCHEMA LIKE 'ndb%' ORDER BY TABLE_SCHEMA;
21 TABLE_SCHEMA
22 ndbinfo
23
24 # ndb tables
25 SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE
26 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'ndb%'
27 ORDER BY TABLE_SCHEMA, TABLE_NAME;
28 TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE
29 information_schema ndb_transid_mysql_connection_map SYSTEM VIEW NULL
30 mysql ndb_apply_status BASE TABLE ndbcluster
31 mysql ndb_binlog_index BASE TABLE InnoDB
32 performance_schema ndb_sync_excluded_objects BASE TABLE PERFORMANCE_SCHEMA
33 performance_schema ndb_sync_pending_objects BASE TABLE PERFORMANCE_SCHEMA
34
35 # There should be many ndb variables
36 SELECT COUNT(*) >= 69 FROM performance_schema.session_variables
37 WHERE variable_name LIKE 'ndb%';
38 COUNT(*) >= 69
39 1
40 MYSQLD --help --verbose # ALL OFF
41 output_line
42 ndb-transid-mysql-connection-map OFF
43 ndbcluster OFF
44 ndbinfo OFF
45 MYSQLD --ndbcluster=0 --ndbinfo --help --verbose # ALL OFF
46 output_line
47 ndb-transid-mysql-connection-map OFF
48 ndbcluster OFF
49 ndbinfo OFF
50 MYSQLD --ndbcluster --help --verbose # ALL ON
51 output_line
52 ndb-transid-mysql-connection-map ON
53 ndbcluster ON
54 ndbinfo ON
55 MYSQLD --ndbcluster=1 --ndbinfo=0 --help --verbose # ndbinfo OFF
56 output_line
57 ndb-transid-mysql-connection-map ON
58 ndbcluster ON
59 ndbinfo OFF
60 MYSQLD --ndbcluster=1 --ndb-transid-mysql-connection-map=0 --help
61 --verbose # ndb-transid-mysql-connection-map OFF
62 output_line
63 ndb-transid-mysql-connection-map OFF
64 ndbcluster ON
65 ndbinfo ON