Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-unsupported.html
To turn GTIDs off, set the gtid_mode and enforce_gtid_consistency variables to OFF. A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-online-operations.html
Operations that add and drop indexes on variable-width columns of NDB tables occur online. MySQL NDB Cluster supports online table schema changes using ALTER TABLE ... NDB Cluster handles COPY and INPLACE as described in the next few paragraphs.
https://dev.mysql.com/doc/refman/9.7/en/online-ddl-memory-management.html
The innodb_ddl_buffer_size variable defines the maximum buffer size for online DDL operations. Online DDL operations that create or rebuild secondary indexes allocate temporary buffers during different phases of index creation. The setting applies ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-maintenance.html
If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... A number of table and ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-tables.html
The use of tables rather than individual variables for setup information provides a high degree of flexibility in modifying Performance Schema configuration. The setup tables provide information about the current instrumentation and enable the ...
https://dev.mysql.com/doc/refman/9.7/en/show-errors.html
You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or notes. SHOW ERRORS [LIMIT [offset,] row_count] SHOW COUNT(*) ERRORS SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/sorted-index-builds.html
Reserving B-tree Page Space for Future Index Growth To set aside space for future index growth, you can use the innodb_fill_factor variable to reserve a percentage of B-tree page space. InnoDB performs a bulk load instead of inserting one index ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-forecaster.html
SignatureForecaster.train( Table trainData, String index, Array[String] endogenousVariables[, Array[String] exogenousVariables] ) Arguments trainData (Table): A Table containing a training dataset. endogenousVariables (Array[String]): The name or ...
https://dev.mysql.com/doc/refman/9.7/en/sys-execute-prepared-stmt.html
Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ... Given an SQL statement as a string, executes it as a prepared ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-check-lost-instrumentation.html
The ps_check_lost_instrumentation view has these columns: variable_name The Performance Schema status variable name indicating which type of instrument was lost. This view returns information about lost Performance Schema instruments, to indicate ...