Search Results
https://dev.mysql.com/doc/refman/8.4/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Scalability means that your application can handle more ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
The relay log file name (Relay_Log_File) is set according to the relay_log_recovery setting, either a new file that was created at server start or the first relay log file present. Source_User The user name of the account used to connect to the ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
To ensure SRID 0 behavior, create geometry values using SRID 0. This provides additional flexibility to users because it is unnecessary to be concerned about the uniqueness of geometry data. Spatial values, or geometries, have the properties ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema.html
The MySQL upgrade procedure produces an error if a sys schema exists but has no version view, on the assumption that absence of this view indicates a user-created sys schema. MySQL 8.4 includes the sys schema, a set of objects that helps DBAs and ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
The following sections describe the syntax for creating and dropping triggers, show some examples of how to use them, and indicate how to obtain trigger metadata. Additional Resources You may find the MySQL User Forums helpful when working with ...
https://dev.mysql.com/doc/refman/8.4/en/views.html
The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums helpful when working with views. Views are stored queries that when ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-crashing.html
If you have examined all other possibilities and concluded that the MySQL server or a MySQL client is causing the problem, it is time to create a bug report, see Section 1.6, “How to Report Bugs or Problems”. This can normally be checked by ...
https://dev.mysql.com/doc/refman/8.4/en/windows-extract-archive.html
Make sure that you are logged in as a user with administrator privileges. To install MySQL manually, do the following: If you are upgrading from a previous version then refer to Section 3.11, “Upgrading MySQL on Windows” before beginning the ...