PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
The OBJECT_TYPE column says USER LEVEL LOCK and the OBJECT_NAME column indicates the lock name. When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. Also, if it is important ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
The server caches information in memory as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. This memory is not released by the corresponding REVOKE, DROP USER, DROP SERVER, and UNINSTALL PLUGIN statements, so for a ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that contains the grant tables. To shut down the servers, connect to each using the appropriate port number: C:\> C:\mysql\bin\mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. Note Statements that update the information in the mysql system database, such as GRANT, REVOKE and the manipulation of triggers, ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the proc table exists. In such a setup, applications and users would have no access to the database tables directly, but can only ...A ...
https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html
Note When using the MySQL Installer to install MySQL Server, it creates the my.ini in the default location, and the user executing MySQL Installer is granted full permissions to this new my.ini file. In other words, be sure that the MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. row *************************** OBJECT_TYPE: LOCKING SERVICE OBJECT_SCHEMA: ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-unicode-uca.html
It is not possible to create user-defined UCA collations for utf16le; there is no utf16le_unicode_ci collation that would serve as the basis for such collations. Table 10.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set ... This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml ...
https://dev.mysql.com/doc/refman/5.7/en/alter-server.html
For example, to update the USER option: ALTER SERVER s OPTIONS (USER 'sally'); ALTER SERVER causes an implicit commit. ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the ...