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/communication-errors.html
If a client successfully connects but later disconnects improperly or is terminated, the server increments the Aborted_clients status variable, and logs an Aborted connection message to the error log. Use of Ethernet protocol with Linux, both half ... If connection problems occur such as communication errors or aborted connections, use these sources of information to diagnose problems: The error ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
MATCH FULL, MATCH PARTIAL, and MATCH SIMPLE are allowed, but their use should be avoided, as they cause the MySQL Server to ignore any ON DELETE or ON UPDATE clause used in the same statement. MATCH options do not have any other effect in MySQL, ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
CURDATE() Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in string or numeric context. CURTIME([fsp]) Returns the current time as a value in 'hh:mm:ss' or hhmmss format, depending on ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
For columns in the index, full column values must be indexed, not just a prefix. The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
If the cache is full, the least recently used entry is discarded. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The Performance Schema host_cache table ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
Within a stored routine, the default database is the database that the routine is associated with, which is not necessarily the same as the database that is the default in the calling context. ; mysql> SET @rows = FOUND_ROWS(); If you are using ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
ENGINE=InnoDB AS SELECT * FROM other_engine_table; To assess performance with a full application under a realistic workload, install the latest MySQL server and run benchmarks. Test the full application lifecycle, from installation, through heavy ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
INNODB_BUFFER_PAGE_LRU: Holds information about the pages in the InnoDB buffer pool, in particular how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
You can use SHOW FULL PROCESSLIST to determine if transactions are waiting for a metadata lock. Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-physical-structure.html
If index records are inserted in a sequential order (ascending or descending), the resulting index pages are about 15/16 full. If records are inserted in a random order, the pages are from 1/2 to 15/16 full. With the exception of spatial indexes, ...