PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
Trigger names exist in the schema namespace, meaning that all triggers must have unique names within a schema. CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body ...
https://dev.mysql.com/doc/refman/5.7/en/drop-trigger.html
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
Built-in functions and stored functions It is possible to create a stored function with the same name as a built-in function, but to invoke the stored function it is necessary to qualify it with a schema name. For example, if you create a stored ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-monitoring.html
You can use the MySQL Performance Schema to monitor Group Replication. These Performance Schema tables display information specific to Group Replication: replication_group_member_stats: See Section 17.4.3, “The replication_group_member_stats ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
For more elaborate tests involving workloads with multiple compressed tables, run queries against the Information Schema INNODB_CMP_PER_INDEX table. Examine the ratio of successful compression operations to overall compression operations by querying ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
To verify that a keyring plugin is active, use the SHOW PLUGINS statement or query the Information Schema PLUGINS table. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'keyring%'; ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
The index defined on the opening_lines table (idx) can be identified by querying the Information Schema INNODB_SYS_INDEXES table for this value (457). mysql> SELECT index_id, name, table_id, space from INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
ALTER TABLE t1 COMPRESSION="None"; OPTIMIZE TABLE t1; Page Compression Metadata Page compression metadata is found in the Information Schema INNODB_SYS_TABLESPACES table, in the following columns: FS_BLOCK_SIZE: The file system block size, which is ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
To decrease the system tablespace size, use this procedure: Use mysqldump to dump all of your InnoDB tables, including InnoDB tables located in the mysql schema. Do not forget to remove *.ibd files for tables located in the mysql schema. The system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
The Information Schema FILES table provides metadata about the InnoDB temporary tablespace. Issue a query similar to this one to view temporary tablespace metadata: mysql> SELECT * FROM INFORMATION_SCHEMA.FILES WHERE ... Non-compressed, user-created ...