Search Results
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-type-syntax.html
The way the server handles TIMESTAMP definitions depends on the value of the explicit_defaults_for_timestamp system variable (see Section 7.1.8, “Server System Variables”). If explicit_defaults_for_timestamp is disabled, the server handles ...
https://dev.mysql.com/doc/refman/9.7/en/index-condition-pushdown-optimization.html
(For information about triggered conditions, see Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”.) Conditions cannot be pushed down to derived tables containing references to system variables. It can be controlled with the ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-table.html
OPTIMIZE TABLE rebuilds the table using the table copy method under the following conditions: When the old_alter_table system variable is enabled. The table and indexes are reorganized, and disk space can be reclaimed for use by the operating system. After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT ...
https://dev.mysql.com/doc/refman/9.7/en/replication-functions-synchronization.html
On a multithreaded replica, the function waits until expiry of the limit set by the replica_checkpoint_group or replica_checkpoint_period system variable, when the checkpoint operation is called to update the status of the replica. Depending on the ... The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL ...Table 14.28 Positional Synchronization Functions Name Description Deprecated MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position Yes SOURCE_POS_WAIT() Block until the replica has read and ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-view.html
row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select 1 AS `a`,2 AS `b` character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci ...However an ... SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-optional-metadata.html
For metadata-optional connections, the client sets the resultset_metadata system variable to control whether the server returns result set metadata. For example, if a client executes a stored procedure that returns multiple result sets and might ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-groups.html
Groups and Permissions 20.1 Groups and Permissions MySQL HeatWave on AWS has three predefined groups. The predefined groups and associated permissions are described in the following tables. Table 20-1 Table 20-2 Table 20-3 Note: The OCI user ...
https://dev.mysql.com/doc/refman/9.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/9.7/en/dbug-package.html
Here are some example debug control strings as they might be specified on a shell command line: --debug=d:t --debug=d:f,main,subr1:F:L:t,20 --debug=d,input,output,files:n --debug=d:t:i:O,\\mysqld.trace For mysqld, it is also possible to change DBUG ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...When you have ...
https://dev.mysql.com/doc/refman/9.7/en/table-size-limit.html
You are using the MEMORY (HEAP) storage engine; in this case you need to increase the value of the max_heap_table_size system variable. The effective maximum table size for MySQL databases is usually determined by operating system constraints on ...