| 1 |
source include/have_ndb.inc; |
| 2 |
|
| 3 |
echo # All three ndb-plugins should be ENABLED; |
| 4 |
SELECT RPAD(PLUGIN_NAME, 33, ' ') 'PLUGIN_NAME ', |
| 5 |
LOAD_OPTION, PLUGIN_STATUS, PLUGIN_TYPE |
| 6 |
FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'ndb%' |
| 7 |
ORDER BY PLUGIN_NAME; |
| 8 |
echo; |
| 9 |
|
| 10 |
echo # Both ndb-engines should be enabled (SUPPORT YES); |
| 11 |
SELECT RPAD(ENGINE, 10, ' ') 'ENGINE ', SUPPORT |
| 12 |
FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE LIKE 'ndb%' ORDER BY ENGINE; |
| 13 |
echo; |
| 14 |
|
| 15 |
echo # ndb schemas; |
| 16 |
SELECT DISTINCT TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES |
| 17 |
WHERE TABLE_SCHEMA LIKE 'ndb%' ORDER BY TABLE_SCHEMA; |
| 18 |
echo; |
| 19 |
|
| 20 |
echo # ndb tables; |
| 21 |
SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE |
| 22 |
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'ndb%' |
| 23 |
ORDER BY TABLE_SCHEMA, TABLE_NAME; |
| 24 |
echo; |
| 25 |
|
| 26 |
echo # There should be many ndb variables; |
| 27 |
SELECT COUNT(*) >= 69 FROM performance_schema.session_variables |
| 28 |
WHERE variable_name LIKE 'ndb%'; |
| 29 |
|
| 30 |
echo MYSQLD --help --verbose # ALL OFF; |
| 31 |
let $ndb_exec_command= $MYSQLD --no-defaults --help --verbose; |
| 32 |
let $ndb_exec_select= REGEXP_LIKE(output_line, |
| 33 |
'^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*'); |
| 34 |
let $ndb_exec_project= output_line; |
| 35 |
source suite/ndb/include/ndb_exec.inc; |
| 36 |
|
| 37 |
echo MYSQLD --ndbcluster=0 --ndbinfo --help --verbose # ALL OFF; |
| 38 |
let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster=0 --ndbinfo --help |
| 39 |
--verbose; |
| 40 |
let $ndb_exec_select= REGEXP_LIKE(output_line, |
| 41 |
'^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*'); |
| 42 |
let $ndb_exec_project= output_line; |
| 43 |
source suite/ndb/include/ndb_exec.inc; |
| 44 |
|
| 45 |
echo MYSQLD --ndbcluster --help --verbose # ALL ON; |
| 46 |
let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster --help --verbose; |
| 47 |
let $ndb_exec_select= REGEXP_LIKE(output_line, |
| 48 |
'^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*'); |
| 49 |
let $ndb_exec_project= output_line; |
| 50 |
source suite/ndb/include/ndb_exec.inc; |
| 51 |
|
| 52 |
echo MYSQLD --ndbcluster=1 --ndbinfo=0 --help --verbose # ndbinfo OFF; |
| 53 |
let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster=1 --ndbinfo=0 --help |
| 54 |
--verbose; |
| 55 |
let $ndb_exec_select= REGEXP_LIKE(output_line, |
| 56 |
'^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*'); |
| 57 |
let $ndb_exec_project= output_line; |
| 58 |
source suite/ndb/include/ndb_exec.inc; |
| 59 |
|
| 60 |
echo MYSQLD --ndbcluster=1 --ndb-transid-mysql-connection-map=0 --help |
| 61 |
--verbose # ndb-transid-mysql-connection-map OFF; |
| 62 |
let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster=1 |
| 63 |
--ndb-transid-mysql-connection-map=0 --help --verbose; |
| 64 |
let $ndb_exec_select= REGEXP_LIKE(output_line, |
| 65 |
'^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*'); |
| 66 |
let $ndb_exec_project= output_line; |
| 67 |
source suite/ndb/include/ndb_exec.inc; |