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/server-status-variables.html
For example, Com_delete and Com_update count DELETE and UPDATE statements, respectively. Com_delete_multi and Com_update_multi are similar but apply to DELETE and UPDATE statements that use multiple-table syntax. Handler_delete The number of times ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
version_tokens_delete(name_list) Deletes tokens from the server's list of version tokens using the name_list argument and returns a binary string that indicates the outcome of the operation. name_list is a semicolon-separated list of version token ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
While a transaction is open, the system keeps a snapshot of the data as seen at the beginning of the transaction, which can cause substantial overhead if the system inserts, updates, and deletes millions of rows while a stray transaction keeps ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
You can use standard system commands to back up, rename, move, delete, and copy tables that are managed by the MyISAM storage engine. The ORDER BY and LIMIT clauses of the UPDATE and DELETE statements. The LOW_PRIORITY clause of the INSERT, REPLACE, ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
For the syntax required to perform multiple-table updates, see Section 13.2.11, “UPDATE Statement”; for that required to perform multiple-table deletes, see Section 13.2.2, “DELETE Statement”. Does MySQL 5.7 have a Query Cache? Does it work ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
The permissible priv_type values at the table level are ALTER, CREATE VIEW, CREATE, DELETE, DROP, GRANT OPTION, INDEX, INSERT, REFERENCES, SELECT, SHOW VIEW, TRIGGER, and UPDATE. [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NO ACTION, 32 = ON UPDATE NO ACTION. The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
When you delete data from a table, InnoDB contracts the corresponding B-tree indexes. Whether the freed space becomes available for other users depends on whether the pattern of deletes frees individual pages or extents to the tablespace. Dropping a ... The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system ...