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/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Configuration Options format_statement() operation can be modified using the ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
Arguments of other types are converted to BIGINT and truncation might occur. Table 12.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For truncation of nonspace characters, you can cause an error to ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
In typical load operations for data warehousing, if something goes wrong, you truncate the table (using TRUNCATE TABLE) and start over from the beginning rather than doing a ROLLBACK. In contrast with the InnoDB system tablespace, file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/delete-optimization.html
To delete all rows from a MyISAM table, TRUNCATE TABLE tbl_name is faster than DELETE FROM tbl_name. Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
Changing the cache size at runtime causes an implicit host cache flushing operation that clears the host cache, truncates the host_cache table, and unblocks any blocked hosts; see Flushing the Host Cache. Execute a TRUNCATE TABLE statement that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
To exclude this data, you can truncate the events_waits_summary_global_by_event_name table immediately after startup and before running your workload. However, the truncate operation itself may produce a negligible amount wait event data. A mutex ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
Because of this, the transactional behavior of a number of MySQL statements is affected as described in the following list: TRUNCATE TABLE is not transactional when used on NDB tables. If a TRUNCATE TABLE fails to empty the table, then it must be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
ndb_restore reports any truncation of data that it performs during lossy conversions once per attribute and column. Such values are truncated to the first 256 bytes in the output. The NDB Cluster restoration program is implemented as a separate ...