Search Results
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
If you enable setuid() core files for the current user, they are generated using mode 600 and are owned by the superuser. Note MySQL 8.4 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For ...
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
A server that participates in a group in single-primary mode should use skip_replica_start=ON. START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group replication. This statement requires the ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Reparsing uses the default database and SQL mode that were in effect for the original conversion to internal form. For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
Note Trailing spaces are removed when CHAR values are retrieved unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
trx_autocommit Whether autocommit mode was enabled when the current transaction started. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
This differs from the default thread-handling model that associates one thread with one connection such that a given thread executes all statements from its connection. This can happen in a situation where all connections are in execution mode and ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
mysql may also be used in batch mode: you place your queries in a file beforehand, then tell mysql to execute the contents of the file. This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
For example, a client's SQL mode is controlled by the session sql_mode value, which is initialized when the client connects to the value of the global sql_mode value. The MySQL server maintains many system variables that configure its operation.
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
WARN flags the issues, but allows the user to continue in interactive mode while addressing the problem. (Bug #37370439) An UPDATE subsequent to an INSERT affecting a table which had a BEFORE INSERT trigger was sometimes rejected with a null value ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
InnoDB Notes Creating a thread for parallel scan may fail, resulting in assertion failures when it fell back to single-thread mode. (Bug #37602657) If the row size exceeded the maximum allowed size due to innodb_strict_mode=OFF, confusing warning ...