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/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/access-control.html
For example: SHOW GRANTS FOR 'joe'@'office.example.com'; SHOW GRANTS FOR 'joe'@'home.example.com'; Internally, the server stores privilege information in the grant tables of the mysql system database. The MySQL server reads the contents of these ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. Other grant tables indicate privileges an account has for ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same time. For a faster count, create a counter table and let your application update it according to the ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data ...Cast Function and Operator Descriptions Character Set Conversions Character Set Conversions for String Comparisons Other Uses for Cast Operations Cast Function and Operator Descriptions BINARY expr The BINARY operator converts the expression to a binary string (a string that has the binary character set and binary ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
The CREATE SERVER statement creates a new row in the servers table in the mysql database. The CREATE SERVER statement creates an entry in the mysql.servers table that can later be used with the CREATE TABLE statement when creating a FEDERATED table.
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
It enables authentication, SSL/TLS, resource-limit, and password-management properties to be established for new accounts, and controls whether accounts are initially locked or unlocked. Plugin names are stored in the plugin column of the mysql.user ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...