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/packet-too-large.html
When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query ... A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
The following example compares the difference between execution times when exchanging a partition with a nonpartitioned table, with and without validation. Exchanging Partitions Without Row-By-Row Validation To avoid time consuming validation when ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
You should keep the following issues and notes in mind: As of macOS 10.14 (Majave), the macOS MySQL 5.7 Installer application requires permission to control System Events so it can display a generated (temporary) MySQL root password. Choosing ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
By default, an error occurs if you try to modify a user that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each named user that does not exist, rather than an error. The account can be used for a maximum of ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-restrictions.html
As of MySQL 5.7.8, the default value for this directory can be set at build time with the INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR CMake option. The embedded server has the following limitations: No loadable functions. You cannot set this up as a ...
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
These binary logs are the incremental backup; at restore time, you apply them as explained in Section 7.5, “Point-in-Time (Incremental) Recovery”. The next time you do a full backup, you should also rotate the binary log using FLUSH LOGS or ...
https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html
An error occurs if the argument is not a valid JSON document. An error occurs if the json_doc argument is not a valid JSON document or the path argument is not a valid path expression or contains a * or ** wildcard. The functions in this section ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-engines-table.html
In the latter case, the error log should contain a reason indicating why the option is disabled. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. The ENGINES table has these ...