PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
ddl_log.log file: The file contained records of metadata operations generated by data definition statements such as DROP TABLE and ALTER TABLE. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables.
https://dev.mysql.com/doc/refman/8.0/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
The same restriction applies to any operation that modifies data dictionary tables, such as ANALYZE TABLE and ALTER TABLE tbl_name ENGINE=engine_name. You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as identifiers if you quote them as described in Section 11.2, ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
In this case, you can try to change the storage engine to another engine by using ALTER TABLE on a repaired copy of the table. If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT ...The preceding means that normally you should not get corrupted tables unless one of the following happens: The MySQL server or the server host was killed in the middle of an ...
https://dev.mysql.com/doc/refman/8.0/en/full-disk.html
Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ALTER TABLE statement. The exception is that for ALTER TABLE, the old table is left unchanged. Other threads might be waiting for the table that caused the disk-full ... This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-multiple-nodes.html
ALTER TABLE is not fully locking when running multiple MySQL servers (SQL nodes). Stored procedures, stored functions, triggers, and scheduled events are all supported by tables using the NDB storage engine, but these do not propagate automatically ...The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
Alternatively, use SSH to get an encrypted TCP/IP connection between a MySQL server and a MySQL client. Running mysqld as a Unix user other than root does not mean that you need to change the root user name in the user table. This includes the ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object body. p2 fails if the invoker lacks the EXECUTE privilege for p2 or the UPDATE privilege for the table t1. To redefine ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored ...