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/alter-table-partition-operations.html
To delete rows from selected partitions, use the TRUNCATE PARTITION option. TRUNCATE PARTITION merely deletes rows; it does not alter the definition of the table itself, or of any of its partitions. To verify that the rows were dropped, check the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Once that amount of space is used during digest computation, truncation occurs: no further tokens from a parsed statement are collected or figure into its digest value. Consequently, if performance_schema_max_digest_length is less than ... The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. Truncation is permitted to clear collected events, ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
This table is also truncated by truncation of the table_io_waits_summary_by_table table. The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
Long values may be truncated as indicated in the element descriptions given later. Long values may be truncated as indicated in the attribute descriptions given later. Long values may be truncated as indicated in the item descriptions given later.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
In MySQL 5.7, you can also truncate partitions using ALTER TABLE ... This statement can be used to delete all rows from one or more partitions in much the same way that TRUNCATE TABLE deletes all rows from a table. Prior to MySQL 5.7.2, ANALYZE, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
It has these effects: In general, truncation resets the baseline for statistics, but does not change the server state. In addition, each memory summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
For other summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ... The ...