PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-options-system-variables.html
To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at startup.
https://dev.mysql.com/doc/refman/9.7/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
Purpose: Provide an application-level firewall enabling the database administrator to allow or block SQL statements based on matching them against accepted statement patterns. The component-based version of MySQL Enterprise Firewall includes the ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-formats.html
The MySQL server calls the audit log component to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after component startup contains the server description and startup options.
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-reading.html
The audit log component supports functions that provide an SQL interface for reading audit log files. When the audit log component initializes, it uses the directory containing the current audit log file as the location to search for readable audit ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. To use a different database, set ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-reading.html
Important The audit_log plugin is deprecated, and is being replaced by the audit_log component. Deprecation of the plugin means that you should expect the plugin to be removed in a future version of MySQL. For more information about the audit log ...