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/innodb-file-format-compatibility-checking-table-access.html
All tables using any file format supported by a release can be read or written (assuming the user has sufficient privileges). The setting of the system configuration parameter innodb_file_format can prevent creating a new table that uses a specific ... When a table is first accessed, InnoDB (including some releases prior to InnoDB 1.0) checks that the file format of the tablespace in which the table is stored is fully ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. MySQL 5.7 supports ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-remote-connections.html
mysql> SELECT CURRENT_USER(), @@bind_address; +-----------------------------------+----------------+ | CURRENT_USER() | @@bind_address | +-----------------------------------+----------------+ | remoteipv6user@2001:db8:0:f101::2 | :: | ... The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_users_lost The number of times a row could ...Performance_schema_digest_lost The number of digest instances that could not be instrumented in the events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
To install functions from the library file, use the CREATE FUNCTION statement. The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. MySQL Enterprise Encryption functions are ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
The audit log plugin can also control which audited events are written to the audit log file, based on event content or the account from which events originate. For best security, write the audit log to a directory accessible only to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. On Unix, make ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
An initial start erases any files created for recovery purposes by earlier instances of ndbd. An --initial start is to be used only when starting the ndbd process under very special circumstances; this is because this option causes all files to be ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...