PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS The number of errors caused by exceeding per-user connections-per-hour quotas. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. Queries, in the form of SELECT statements, perform all the lookup ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
The default is 86400 seconds (24 hours), but the time period can be extended to as much as one year. The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-time.html
Depending on the size of the value, the units part is ps (picoseconds), ns (nanoseconds), us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), d (days), or w (weeks). Note As of MySQL 8.0.16, format_time() is deprecated and ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
(The example shown earlier illustrates how this can occur.) The query specifies a search value that is within the hour of entry into DST in the session time zone. Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
You can specify an expel timeout up to a maximum of 3600 seconds (1 hour). You can use the group_replication_member_expel_timeout system variable, which is available from MySQL 8.0.13, to allow additional time between the creation of a suspicion ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
To avoid timeouts, the semaphore wait threshold (600 seconds) is extended by 2 hours (7200 seconds) for CHECK TABLE operations. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors.