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/sys-sys-config.html
This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The sys_config table has these columns: variable The configuration ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. Design your tables to minimize their space on the disk. Smaller tables normally ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-issues.html
This can be done by issuing a statement such as ALTER TABLE mysql.ndb_apply_status ENGINE=MyISAM on the replica. In the event of a node failure, errors in replication of NDB tables without primary keys can still occur, due to the possibility of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains ...For more information about InnoDB FULLTEXT search, see Section 14.6.2.4, “InnoDB Full-Text Indexes”, and Section 12.9, “Full-Text Search ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the information in the internal SYS_INDEXES table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...Index ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
The INNODB_SYS_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based, equivalent to information in the SYS_VIRTUAL table in the InnoDB data dictionary. A row appears in the ...The value is large because it encodes the column sequence number and ordinal ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
These tables store statement events: events_statements_current: The current statement event for each thread. prepared_statements_instances: Prepared statement instances and statistics The following sections describe the statement event tables. There ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR ...Generally, the effect is to reset the summary columns to 0 or NULL, not to remove ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database. The LIKE clause, if present, indicates which table names to match. Matching performed by the LIKE clause is ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
$> mysql -u root -p < audit_log_filter_linux_install.sql Enter password: (enter root password here) Note Some MySQL versions have introduced changes to the structure of the MySQL Enterprise Audit tables. To ensure that your tables are up to date for ... This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 6.4.5.1, “Elements of MySQL Enterprise ...