Search Results
https://dev.mysql.com/doc/refman/8.4/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Select ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). However, not all system variables can be ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use PAM (Pluggable Authentication Modules) to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. This section discusses current restrictions and limitations on MySQL partitioning support. For a list of ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
It is possible to exclude certain parts of the Performance Schema instrumentation. For example, to exclude stage and statement instrumentation, do this: $> cmake . \ -DDISABLE_PSI_STAGE=1 \ -DDISABLE_PSI_STATEMENT=1 For more information, see the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the INFO value shows the SELECT statement. The MySQL process list indicates the operations currently being performed by the set of threads executing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
Query results can be saved in tables for further analysis, or assigned to variables and thus used in stored procedures. This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the PROCESSLIST_INFO value shows the SELECT statement. The threads table contains a row for each server thread. Each row contains information about a ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
For example, to unpack and build a DBI distribution, use a procedure such as this: Unpack the distribution into the current directory: $> gunzip < DBI-VERSION.tar.gz | tar xvf - This command creates a directory named DBI-VERSION. MySQL Perl support ...