PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. The Commercial Edition provides additional Enterprise features, such as database ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
The filter is useful to log statements that update or delete anything from the temp_1 or temp_2 tables, such as this one: UPDATE temp_1, temp_3 SET temp_1.a=21, temp_3.a=23; The statement generates multiple table_access events, but the audit log ...