| 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 |