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/rename-user.html
Attempts to access such objects may produce an error if they execute in definer security context. An error occurs for old accounts that do not exist or new accounts that already exist. RENAME USER old_user TO new_user [, old_user TO new_user] ...
https://dev.mysql.com/doc/refman/5.7/en/thread-information.html
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 1 User: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-disk-write-speed-aggregate-node.html
The disk_write_speed_aggregate_node table provides aggregated information per node about the speed of disk writes during LCP, backup, and restore operations.
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
At startup, and at runtime when FLUSH PRIVILEGES is executed, the server checks user table rows. As of MySQL 5.7.18, for any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't » have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
A buffer pool that is too small may cause excessive churning as pages are flushed from the buffer pool only to be required again a short time later. For each concurrent thread, a table structure, column structures for each column, and a buffer of ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. For column values calculated as ...An ORDER BY with and without LIMIT may return rows in different orders, as discussed in Section 8.2.1.17, “LIMIT Query ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-file-context.html
For example: semanage fcontext -a -t mysqld_db_t "/path/to/my/custom/datadir(/.*)?" restorecon -Rv /path/to/my/custom/datadir semanage fcontext -a -t mysqld_db_t "/path/to/my/custom/logdir(/.*)?" restorecon -Rv /path/to/my/custom/logdir Setting the ... The MySQL Server reads from and writes to many ...