PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_waits_history_long table contains N the most recent wait events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
The user has a column-level privilege for any of the involved tables. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. Set up indexes on columns used in the WHERE clause, to speed up ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
The server uses the sha256_password_auto_generate_rsa_keys system variable to determine whether to automatically generate the RSA key-pair files. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
Item Name Definition --------- ---------- CLASS_ORIGIN VARCHAR(64) SUBCLASS_ORIGIN VARCHAR(64) CONSTRAINT_CATALOG VARCHAR(64) CONSTRAINT_SCHEMA VARCHAR(64) CONSTRAINT_NAME VARCHAR(64) CATALOG_NAME VARCHAR(64) SCHEMA_NAME VARCHAR(64) TABLE_NAME ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engine-setting.html
By default, a warning is generated whenever CREATE TABLE or ALTER TABLE cannot use the default storage engine. For new tables, MySQL always creates an .frm file to hold the table and column definitions. When you create a new table, you can specify ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
As of MySQL 5.7.19, an exception to the preceding principle occurs for expressions for virtual generated columns. MySQL has many operators and functions that return a string. This section answers the question: What is the character set and ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL ...