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/enterprise-encryption-functions.html
See Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”.) The underlying SSL library takes care of randomness initialization. For additional examples and discussion, see Section 6.6.2, “MySQL Enterprise Encryption Usage and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
See Section 14.21.3, “Setting Up the InnoDB memcached Plugin” for usage details. For example: Number of doc processed: 1000 For FTS queries, the query parsing tree, word weight, query processing time, and memory usage are printed. Be aware, ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
Account names appear in SQL statements such as CREATE USER, GRANT, and SET PASSWORD and follow these rules: Account name syntax is 'user_name'@'host_name'. MySQL stores account names in grant tables in the mysql system database using separate ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
If transaction T1 holds a shared (S) lock on row r, then requests from some distinct transaction T2 for a lock on row r are handled as follows: A request by T2 for an S lock can be granted immediately. A request by T2 for an X lock cannot be granted ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Alternatively, on any platform, you can reset the password using the mysql client (but this approach is less secure): Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option. Because this is insecure, you might want ... If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
NO_AUTO_CREATE_USER Prevent the GRANT statement from automatically creating new user accounts if it would otherwise do so, unless authentication information is specified. It is preferable to create MySQL accounts with CREATE USER rather than GRANT.
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
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/check-table.html
Before running CHECK TABLE on InnoDB tables, see CHECK TABLE Usage Notes for InnoDB Tables. CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
For information about collecting memory usage data, see Memory Instrumentation Behavior. 11MB is a lower estimate that can occur only if both threads hit the low usage mark at the same time. 14MB is a higher estimate that can occur only if both ...