-> ENGINE = NDB; Query OK, 0 rows affected (2.97 sec) 

The fact that the CREATE LOGFILE GROUP  statement does not actually return an error when a non- NDB storage engine is named, but rather appears to succeed, is a known issue which we hope to address in a future release of NDB Cluster. 

REDO_BUFFER_SIZE , NODEGROUP , WAIT , and COMMENT  are parsed but ignored, and so have no effect in MySQL 8.0. These options are intended for future expansion. 

When used with ENGINE [=] NDB , a log file group and associated UNDO  log file are created on each Cluster data node. You can verify that the UNDO  files were created and obtain information about them by querying the INFORMATION_SCHEMA.FILES  table. For example: 

mysql> SELECT LOGFILE_GROUP_NAME, LOGFILE_GROUP_NUMBER, EXTRA -> FROM INFORMATION_SCHEMA.FILES -> WHERE FILE_NAME = ’undo_10.dat’; +--------------------+----------------------+----------------+ | LOGFILE_GROUP_NAME | LOGFILE_GROUP_NUMBER | EXTRA | +--------------------+----------------------+----------------+ | lg_3 | 11 | CLUSTER_NODE=3 | | lg_3 | 11 | CLUSTER_NODE=4 | +--------------------+----------------------+----------------+ 2 rows in set (0.06 sec) 

CREATE LOGFILE GROUP  is useful only with Disk Data storage for NDB Cluster. See Section 23.5.10, “NDB Cluster Disk Data Tables” . 

## 13.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements 

CREATE [DEFINER = user ] PROCEDURE sp_name  ([ proc_parameter [,...]]) [ characteristic  ...] routine_body CREATE [DEFINER = user ] FUNCTION sp_name  ([ func_parameter [,...]]) RETURNS type [ characteristic  ...] routine_body proc_parameter : [ IN | OUT | INOUT ] param_name type func_parameter : param_name type type : Any valid MySQL data type characteristic : { COMMENT ’ string ’ | LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } routine_body : Valid SQL routine statement 

These statements are used to create a stored routine (a stored procedure or function). That is, the specified routine becomes known to the server. By default, a stored routine is associated with the 

