PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
DDL performance for InnoDB temporary tables is improved through optimization of CREATE TABLE, DROP TABLE, TRUNCATE TABLE, and ALTER TABLE statements. This section summarizes what has been added to, deprecated in, and removed from MySQL 5.7. A ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
If attribute size exceeds this value, these actions take place: The Performance Schema truncates the attribute data and increments the Performance_schema_session_connect_attrs_lost status variable, which indicates the number of connections for which ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
After making instrumentation changes, you might want to truncate the summary tables. Exceptions to this truncation behavior are noted in individual summary table sections. Pre-filtering is done by the Performance Schema and has a global effect that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
Values are also truncated to 6 decimal places to display data in the same format as SHOW PROFILES and SHOW PROFILE statements. The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Exceptions to this truncation behavior are noted in individual summary table sections. Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
If the aggregate size of connection attribute data sent by a client is larger than this amount, the Performance Schema truncates the attribute data, increments the Performance_schema_session_connect_attrs_lost status variable, and writes a message ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
This attempt might fail because the Performance Schema truncates long SQL_TEXT values. in_start_fresh BOOLEAN: Whether to truncate the Performance Schema events_statements_history_long and events_stages_history_long tables before starting. Traces ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
innodb_purge_rseg_truncate_frequency: Rate at which undo log purge should be invoked as part of purge action. innodb_undo_log_truncate: Enable this option to mark InnoDB undo tablespace for truncation. Options and Variables Introduced in MySQL 5.7 ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
Arguments of other types are converted to BIGINT and truncation might occur. The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. This section describes ...