PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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/refman/8.0/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. However, this method may not scale well in situations where thousands of concurrent transactions are initiating updates to ...
https://dev.mysql.com/doc/refman/8.0/en/alter-server.html
For example, to update the USER option: ALTER SERVER s OPTIONS (USER 'sally'); ALTER SERVER causes an implicit commit. ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Table 8.34 Audit Log Class and Event Combinations Class Value Permitted Event Values audit startup, shutdown connection connect, change_user, disconnect general status table_access_data read, delete, insert, update connection_data Information about ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
You can also create a binary backup simply by copying the table files, as long as the server is not updating anything. Also, even if the server is not actively updating data, InnoDB may still have modified data cached in memory and not flushed to ...
https://dev.mysql.com/doc/refman/8.0/en/channels-startup-options.html
--log-replica-updates or --log-slave-updates All transactions received by the replica (even from multiple sources) are written in the binary log. This section describes startup options which are impacted by the addition of replication channels. The ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.