PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
To import the dump file into a new database, and have the tables re-created as they exist in the original database, ensure the server has the proper settings for the configuration parameters innodb_file_format and innodb_file_per_table. SQL ...ERROR ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
CEILING(3.7004397181411) is 4, and V = POWER(2,4), which is 16.) Set N = F(column_list) & (V - 1). MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas ...
https://dev.mysql.com/doc/refman/5.7/en/repeat.html
For the rules regarding label use, see Section 13.6.2, “Statement Labels”. [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition ...
https://dev.mysql.com/doc/refman/5.7/en/examples.html
Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per article, then (article, dealer) is a primary key for the records. Here ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-tables.html
For related information and examples, see Section 14.16, “InnoDB INFORMATION_SCHEMA Tables”. INFORMATION_SCHEMA InnoDB tables can be used to monitor ongoing InnoDB activity, to detect inefficiencies before they turn into issues, or to ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system database because it adds a row to the mysql.func system table to register the function. For more information, see Section 5.6.1, “Installing and Uninstalling Loadable Functions”.
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system database because it removes the row from the mysql.func system table that registers the function. Because DROP FUNCTION removes the mysql.func row for the dropped function, the server does not ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-elements.html
Server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement INFORMATION_SCHEMA tables that provide views into the registered profiles. MySQL Enterprise Firewall is based on a plugin library that includes these elements: A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...