PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
It may be used to time how quickly MySQL processes the expression. The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); ...The result value is 0, or ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be accepted. As of MySQL 8.0.14, additional undo tablespaces can be created at runtime using SQL. Prior ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbd.html
--connect-delay=# Command-Line Format --connect-delay=# Deprecated Yes (removed in 8.0.28-ndb-8.0.28) Type Numeric Default Value 5 Minimum Value 0 Maximum Value 3600 Determines the time to wait between attempts to contact a management server when ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
LOGGED corresponds to the time field of error events, although with certain potential differences: time values in the error log are displayed according to the log_timestamps system variable setting; see Early-Startup Logging Output Format. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
For example, table columns that show wait times, lock times, or index use may highlight types of queries that are inefficient. A typical number of statements in this table is 10 per session, so each session consumes 10 times the memory indicated by ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: 2119302 MIN_TIMER_WAIT: 196092 AVG_TIMER_WAIT: 264912 MAX_TIMER_WAIT: 569421 ... row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Scheduled tasks of this type are also ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
Must the replica be connected to the source all the time? A.14.2. Must the replica be connected to the source all the time? No, it does not. For example, you can set up a source/replica relationship over a dial-up link where the link is up only ...