Search Results
https://dev.mysql.com/doc/refman/8.4/en/nontransactional-tables.html
This can happen if you try to create a table using a transactional storage engine that is not supported by your mysqld server (or that was disabled with a startup option). If you receive the following message when trying to perform a ROLLBACK, it ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-trace-system-variable.html
The optimizer_trace system variable has these on/off switches: enabled: Enables (ON) or disables (OFF) tracing one_line: If set to ON, the trace contains no whitespace, thus conserving space. This renders the trace difficult to read for humans, ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-tracing-typical-usage.html
To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 10.15.3, “Traceable Statements”, for a listing of statements which can be traced. To examine traces for multiple ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
A server started with the persisted_globals_load system variable disabled does not read mysqld-auto.cnf. If MYSQL_HOME is not set and you start the server using the mysqld_safe program, mysqld_safe sets it to BASEDIR, the MySQL base installation ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
After determining what the problem is, remove the mysql-any-password PAM service file to disable any-password access. Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
Partition selection is disabled for tables employing a storage engine that supplies automatic partitioning, such as NDB. Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
It is not possible to disable partitioning support by the InnoDB storage engine. Note Table partitioning differs from partitioning as used by window functions. In MySQL 8.4, partitioning support is provided by the InnoDB and NDB storage engines.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_accounts_size ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-tables.html
If the clone plugin is loaded but disabled, the tables are not created. The following sections describe the Performance Schema tables associated with the clone plugin (see Section 7.6.7, “The Clone Plugin”). clone_status: status information ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. To set the table size explicitly, set the ...