Search Results
https://dev.mysql.com/doc/refman/9.7/en/resignal.html
The maximum number of condition areas in a diagnostics area is determined by the value of the max_error_count system variable. RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-procedure.html
row *************************** Function: hello sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Function: CREATE DEFINER=`me`@`localhost` FUNCTION `hello`(s ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-trigger.html
character_set_client: The session value of the character_set_client system variable when the trigger was created. collation_connection: The session value of the collation_connection system variable when the trigger was created. SHOW CREATE TRIGGER ...
https://dev.mysql.com/doc/refman/9.7/en/show-procedure-status.html
row *************************** Db: test Name: hello Type: FUNCTION Definer: testuser@localhost Modified: 2020-03-10 11:10:03 Created: 2020-03-10 11:10:03 Security_type: DEFINER Comment: character_set_client: utf8mb4 collation_connection: ... SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/doc/refman/9.7/en/using-gdb-on-mysqld.html
On most systems you can also start mysqld from gdb to get more information if mysqld crashes. In this case, you should set the following environment variable in the shell before starting gdb: LD_ASSUME_KERNEL=2.4.1 export LD_ASSUME_KERNEL When ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-setting-options.html
A Boolean option all can also be specified to include information about all Group Replication system variables in the output. transactionSizeLimit: positive integer value which sets the Group Replication system variable ... You can check and modify ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
See Automatic Loading and Unloading of DB System Tables and Partitions. To view command-line help in the terminal, run the following command: mysql> CALL sys.heatwave_unload(JSON_ARRAY(),JSON_OBJECT("output","help")); Unload Specific Tables You can ... You can use MySQL HeatWave Auto Unload to unload data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-prereqs.html
MySQL HeatWave on OCI Lakehouse Requirements The DB System must have Lakehouse enabled. See Creating a DB System in the MySQL HeatWave on OCI Service Guide. The MySQL HeatWave Cluster in the DB System must meet the following requirements: As Of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-resource-principal.html
Dynamic groups allow you to group DB Systems as principal actors, similar to user groups. You can then create policies to permit DB Systems in these groups to make API calls against services, such as Object Storage. To set up resource principals ...