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/optimizing-innodb-ddl-operations.html
Use TRUNCATE TABLE to empty a table, not DELETE FROM tbl_name. Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE and CREATE TABLE might be fastest. Many ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
In MySQL 5.7, all rows relating to employees working at stores in that region can be deleted with the query ALTER TABLE employees TRUNCATE PARTITION pWest, which can be executed much more efficiently than the equivalent DELETE statement DELETE FROM ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
If you wish to drop all data from all partitions while preserving the table definition and its partitioning scheme, use the TRUNCATE TABLE statement. (See Section 13.1.34, “TRUNCATE TABLE Statement”.) If you intend to change the partitioning of ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
Truncating the table flushes the host cache, which has the effects described in Flushing the Host Cache. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-timers-table.html
To avoid unpredictable results after you make timer changes, use TRUNCATE TABLE to reset Performance Schema statistics. The setup_timers.TIMER_NAME value can be changed to select a different timer. The value can be any of the values in the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance_schema_session_connect_attrs_lost The number of connections for which connection attribute truncation has occurred. For a given connection, if the client sends connection attribute key-value pairs for which the aggregate size is larger ...Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
In strict mode, inserting a value that is out of range for a column causes an error, rather than truncation to a legal value. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
row *************************** Level: Warning Code: 1265 Message: Data truncated for column 'b' at row 1 *************************** 2. SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
If N is less than the length of the input string, the string is truncated to N characters. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...