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/partitioning-pruning.html
By doing so, it is possible to expend much less time and effort in finding matching rows than would be required to scan all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the ...
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL server. To tell mysqld ...You can either tell mysqld not to open so many files at once or increase the number of file descriptors available to ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For example, a CHAR(255) column can exceed 768 bytes if the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you connect to the server (see Client Program Connection Character Set Configuration). Connect-Time Error ...The ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
TIME_ZONE The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
The server keeps tablespace metadata in memory for the lifetime of a tablespace. If the tablespace is not empty, DROP TABLESPACE returns an error. A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax.
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/mysql-cluster-limitations-transactions.html
The resulting read is as consistent as a committed read by primary key, returning the last committed value at the time the row is read. A duplicate key or similar error causes the entire transaction to be rolled back. Important When executing a LOAD ... A number of limitations exist in NDB Cluster with regard to the handling of ...
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/performance-schema-threads-table.html
PROCESSLIST_TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. row ... The ...