PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
There is an exception for CREATE DATABASE, ALTER DATABASE, and DROP DATABASE. The database being created, altered, or dropped is considered to be the default database when determining whether to output the statement. The server's binary log ...To ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
--database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the database that contains the table being queried. --sys-drop Command-Line Format --sys-drop Drop all statistics ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
For this reason, DROP FUNCTION requires the DELETE privilege for the mysql system database. For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. Uninstalling Loadable Functions To remove a loadable function, ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root[root] @ localhost ... The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
Note If the --auto-generate-sql option is also given, mysqlslap drops the schema at the end of the test run. --no-drop Command-Line Format --no-drop Type Boolean Default Value FALSE Prevent mysqlslap from dropping any schema it creates during the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 MODIFY COLUMN c2 TINYINT GENERATED ALWAYS AS (c1 + 5) STORED; Generated columns can be renamed or dropped, if no other column refers to them. CREATE TABLE t1 (c1 ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-installation.html
To remove them, use the UNINSTALL PLUGIN and DROP FUNCTION statements: UNINSTALL PLUGIN version_tokens; DROP FUNCTION version_tokens_set; DROP FUNCTION version_tokens_show; DROP FUNCTION version_tokens_edit; DROP FUNCTION version_tokens_delete; DROP ...To avoid this overhead, do not install it unless you plan to use ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
NDB 8.0 removes the previous 63-byte limit on identifiers for databases and tables. Previously, the only NDB objects synchronized on connection of a new SQL node were databases and tables; MySQL NDB Cluster 8.0 also implements schema synchronization ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
When a database is dropped, all stored routines associated with it are dropped as well. Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”), and ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...