Search Results
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
The OVER clause has two forms: over_clause: {OVER (window_spec) | OVER window_name} Both forms define how the window function should process query rows. For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ...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/windows-pluggable-authentication.html
Suppose that the Windows user named win_user is a member of win_group and the authentication string looks like this: 'win_group = sql_user1, win_user = sql_user2' When win_user connects to the MySQL server, there is a match both to win_group and to ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
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 times. The following discussion describes how to write ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-encrypted-connections.html
The permitted TLS versions for both types of connections are therefore the same. This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
Use this address to permit both IPv4 and IPv6 connections for X Plugin. In this situation, if you want to store both sockets at a single path, you must set the mysqlx_socket system variable as well. To control activation of X Plugin, use this ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
Fixed by rewriting the package lookup to work for both older and newer CMake packages. (Bug #115162, Bug #36673883) The server did not always handle connections correctly when running with both the thread pool and audit log plugins. C API Notes ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Both of these relate to MSVC substitution of gsl::span for std::span, which is not used for MySQL. (Bug #37271715) InnoDB: It was possible for an ALTER TABLE operation using the INPLACE algorithm on a table containing both a spatial index and an ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-message-logging-options.html
The message logging works like a tee process on a Unix-like system, in which the output of a program is split to be both displayed and saved to a file. And because the default path name of backup_dir/meta is not meaningful for the two operations, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the amount of overhead on the database server. There might also be storage issues if there is not enough free space on ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
This option is not compatible with the --no-locking option; using both options together will make mysqlbackup throw an error. This option is not compatible with the --no-locking option; using both options together will make mysqlbackup throw an ...