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/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. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 25.4.1, “Performance Schema Event Timing”. This value is computed in microseconds but normalized to picoseconds for easier comparison with ...For example, the events_statements_history and events_statements_history_long tables are collections of the most recent statement events that have ended, up to a maximum number of rows per thread and globally across all threads, ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
The statement following FOR EACH ROW defines the trigger body; that is, the statement to execute each time the trigger activates, which occurs once for each row affected by the triggering event. MySQL handles errors during trigger execution as ...It ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. For MAX_USER_CONNECTIONS, the limit is an integer representing the maximum number of simultaneous connections by the account. For example, to remove ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
binlog_max_flush_queue_time Command-Line Format --binlog-max-flush-queue-time=# Deprecated Yes System Variable binlog_max_flush_queue_time Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 100000 Unit microseconds ...binlog_group_commit_sync_delay Command-Line Format --binlog-group-commit-sync-delay=# System Variable binlog_group_commit_sync_delay Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 1000000 Unit microseconds Controls how many microseconds the binary log commit waits before synchronizing the binary log file to ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
YEAR(2) column definitions for new tables produce warnings or errors: Before MySQL 5.7.5, YEAR(2) column definitions for new tables are converted (with an ER_INVALID_YEAR_COLUMN_LENGTH warning) to 4-digit YEAR columns: mysql> CREATE TABLE t1 (y ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/5.7/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 13.1.21, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 13.1.10, “ALTER VIEW Statement”), or DROP VIEW (see Section 13.1.32, ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-check.html
This causes myisamchk to keep going, up through a maximum of 20 errors. To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. It first checks all index entries for errors and then reads through all ...What it cannot find is corruption that involves only the data file (which is very ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. Memory summary tables do not contain timing information because memory events are not ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...