Search Results
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
An event is not migrated or dropped as a result of renaming or dropping the user who created it. The same would be true if root had issued either of these statements: DROP USER jon@ghidora; RENAME USER jon@ghidora TO someotherguy@ghidora; You can ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
After using this value, be prepared to drop and recreate all secondary indexes. With an innodb_force_recovery value of 3 or less you can DROP or CREATE tables. DROP TABLE is also supported with an innodb_force_recovery value greater than 3. DROP ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
(Running ndb_restore --rebuild-indexes at the end of the restore process causes this index to be dropped.) --append Command-Line Format --append When used with the --tab and --print-data options, this causes the data to be appended to any existing ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
(This is another reason you might wish to force MySQL to use the temptable algorithm by specifying ALGORITHM = TEMPTABLE in the view definition.) You can use DROP TABLE or ALTER TABLE to drop or alter a table that is used in a view definition. No ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
ProcedureCacheSize , Procedure Cache Size , procedure cache , procedurecache Default: 25 Sets the size of the stored procedure cache. By default, Connector/NET stores the metadata (input/output data types) about the last 25 stored procedures used.
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
ProcedureCacheSize , Procedure Cache Size , procedure cache , procedurecache Default: 25 Sets the size of the stored procedure cache. By default, Connector/NET stores the metadata (input/output data types) about the last 25 stored procedures used.
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
\eval (EVALUATING) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- eval0eval.c Evaluating/Evaluating 17,061 SQL evaluator eval0proc.c Evaluating/Procedures 5,001 Executes SQL ... The ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-showstatementactivity-category.html
Show Create Proc (Delta) The total number of SHOW CREATE PROCEDURE statements executed. Show Procedure Code (Delta) The total number of SHOW PROCEDURE CODE statements executed. Show Procedure Status (Delta) The total number of SHOW PROCEDURE STATUS ... Lists the Show Statement Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
You can load them using the stored procedure ML_MODEL_IMPORT that provides the conversion required to store the model in a MySQL table. When you use the ML_EXPLAIN_TABLE and ML_EXPLAIN_ROW stored procedures to generate explanations for a prediction, ... MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now monitored and recorded in the Performance Schema tables rpd_query_stats and ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...