Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-show-tables.html
By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well. --type, -t Can be used to restrict the output to one type of object, specified ... ndb_show_tables displays a list of all NDB database objects in the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-system-variables.html
performance_schema_users_size Command-Line Format --performance-schema-users-size=# System Variable performance_schema_users_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value -1 (signifies autoscaling; do not assign ...
https://dev.mysql.com/doc/refman/9.7/en/select.html
You cannot use FOR UPDATE as part of the SELECT in a statement such as CREATE TABLE new_table SELECT ... (If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being created.) FOR SHARE ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/9.7/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/mysql-router/9.7/en/router-read-write-splitting-statements.html
The following Account Management statements: GRANT, REVOKE, RENAME USER, CREATE ROLE, CREATE USER, DROP ROLE, DROP USER, SET PASSWORD, SET ROLE, SET DEFAULT ROLE. The following database administration statements: SHOW CREATE..., SHOW VARIABLES, SHOW ... The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not followed by UPDATE or ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-commands.html
Use the --mysqlx (--mx) option to create a session using the X Protocol to connect to MySQL server instance. For example: \connect --mysqlx root@localhost:33060 Use the --mysql (--mc) option to create a ClassicSession, enabling you to use classic ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-classification-train.html
Training the Model Train the model with the ML_TRAIN routine and use the training_data table previously created. Before training the model, it is good practice to define the model handle instead of automatically creating one. The following example ... After preparing the data for a classification model, you can train the ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-regression-train.html
Training the Model Train the model with the ML_TRAIN routine and use the house_price_training table previously created. Before training the model, it is good practice to define the model handle instead of automatically creating one. The following ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-topic-modeling-train.html
Therefore, you cannot use the following options for topic modeling: model_list optimization_metric exclude_model_list exclude_column_list include_column_list Unsupported Routines You cannot run the following routines for topic modeling: ML_EXPLAIN ... After preparing the data for topic modeling, you can train the ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-training-a-forecasting-model.html
Unsupported Routines You cannot run the following routines for a trained forecasting model: ML_EXPLAIN ML_EXPLAIN_ROW ML_EXPLAIN_TABLE ML_PREDICT_ROW Training the Model After following the steps to Prepare Data for Forecasting Model, train the model ... After preparing the data for a forecasting model, you can train the ...