Search Results
https://dev.mysql.com/doc/refman/9.7/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...
https://dev.mysql.com/doc/refman/9.7/en/alter-resource-group.html
ALTER RESOURCE GROUP group_name [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE [FORCE]] vcpu_spec: {N | M - N} ALTER RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”).
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-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/9.7/en/alter-tablespace.html
ALTER TABLESPACE ts1 ENGINE_ATTRIBUTE='{"key":"value"}'; ENGINE_ATTRIBUTE values can be repeated without error. It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB Cluster ...
https://dev.mysql.com/doc/refman/9.7/en/analyze-table.html
Column Value Table The table name Op analyze or histogram Msg_type status, error, info, note, or warning Msg_text An informational message Key Distribution Analysis ANALYZE TABLE without either HISTOGRAM clause performs a key distribution analysis ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...
https://dev.mysql.com/doc/refman/9.7/en/audit-api-message-emit.html
The audit_api_message_emit component enables applications to add their own message events to the audit log, using the audit_api_message_emit_udf() function. For concreteness, examples use the audit_log plugin described in Section 8.4.6, “MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-installation.html
For example: mysql> SELECT * FROM mysql.component; +--------------+--------------------+----------------------------+ | component_id | component_group_id | component_urn | +--------------+--------------------+----------------------------+ | 1 | 1 | ... Note The Audit Log component is intended to replace the Audit Log plugin, which is now ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | audit_log | ACTIVE | ...