Search Results
https://dev.mysql.com/doc/refman/8.4/en/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. For additional information, ...This section describes how to select these protocols, and how they are similar and ...
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
The following query finds all objects that are in the given rectangle: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 15000))'; mysql> SELECT fid,ST_AsText(g) FROM geom WHERE -> ... The optimizer ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
Note For statements that assign or modify account passwords (ALTER USER, CREATE USER, and SET PASSWORD), the validate_password capabilities described here apply only to accounts that use an authentication plugin that stores credentials internally to ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
Note Because work on the MySQL optimizer is ongoing, not all of the optimizations that MySQL performs are documented here. Because MySQL does similar optimizations automatically, you can often avoid this work, and leave the query in a more ... This ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
MySQL also supports nonaggregate functions that are used only as window functions. A MySQL extension is to permit expressions, not just column names. For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts ...However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
These constraints come from the SQL standard, other than the MySQL-specific exclusions mentioned previously. If so, increasing the permitted in-memory temporary table size may improve performance; see Section 10.4.4, “Internal Temporary Table Use ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
The process assumes that following conditions are met: The backed-up MySQL Server has had its binary logging enabled (which is true by default). To check if this condition has been satisfied, perform this query on the server: mysql> SHOW VARIABLES ... You can restore your database server to its state at an arbitrary time using the binary log files included in the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
Table 4.1 Information Needed to Back Up a Database Information to Gather Where to Find It How to Use It Path to MySQL configuration file Default system locations, hardcoded application default locations, or from the --defaults-file option in the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup-os-user.html
For Linux and other Unix-like platforms: mysqlbackup does not record file ownership or permissions of the files that are backed up. To ensure no file permission issues prevent a server to be backed up, restored, and restarted successfully, it is ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables.html
This appendix provides tables of configuration attributes, grouped according to their process type or by the section of the MySQL NDB Cluster configuration file in which they appear. For information regarding MySQL NDB Cluster 8.0, see ...Each ...