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/user-resources.html
Only statements that modify databases or tables count against the update limit. An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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/5.7/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. If the session is currently in row-based replication mode and has open temporary tables. Switching the replication format at runtime is ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
If you did not make a deliberate decision about the storage engine, and you want to preview how certain tables work when created using InnoDB, issue the command ALTER TABLE table_name ENGINE=InnoDB; for each table. Alternatively, to run test queries ...Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, editing, and querying features ... If InnoDB is not the default ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
For Red Hat Enterprise Linux/Oracle Linux/CentOS systems: $> sudo yum install mysql-community-{client,common,libs}-* mysql-5.* A standard installation of MySQL using the RPM packages result in files and resources created under the system ... The ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. The following examples use HEX() to display the INET6_ATON() result in printable form: mysql> SELECT ...The function ...