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/mysqlbinlog.html
For statement-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth. For example: # at 141 #100309 9:28:36 ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. The following table lists each built-in (native) function and operator and provides a short description of each one. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
KeepAliveSendInterval: Time between keep-alive signals on links between data nodes, in milliseconds. MaxNoOfConcurrentTransactions: Maximum number of transactions executing concurrently on this data node, total number of transactions that can be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The restart_info table contains the following columns: node_id Node ID ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
row *************************** NAME: wait/synch/mutex/pfs/LOCK_pfs_share_list ENABLED: NO TIMED: NO PROPERTIES: singleton FLAGS: NULL VOLATILITY: 1 DOCUMENTATION: Components can provide their own performance_schema tables. row ... The ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ... The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
TIME_ZONE The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. EVENT_TYPE The event repetition type, either ONE TIME (transient) or RECURRING (repeating). EXECUTE_AT For a ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. Wait event data collected in Performance Schema tables can help identify mutexes with the most waits or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
To specify more than one database, use this option multiple times, once for each database; however, doing so does not cause cross-database statements such as UPDATE some_db.some_table SET foo='bar' to be logged while a different database (or no ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
CAST(expr AS type [ARRAY]) CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)]) timezone_specifier: [INTERVAL] '+00:00' | 'UTC' With CAST(expr AS type syntax, the CAST() function takes an expression of any type and produces ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...