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/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_users_size system ...
https://dev.mysql.com/doc/refman/5.7/en/permission-optimization.html
For example, if you do not grant any table-level or column-level privileges, the server need not ever check the contents of the tables_priv and columns_priv tables. The more complex your privilege setup, the more overhead applies to all SQL ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
A grant table reload affects privileges for each existing client session as follows: Table and column privilege changes take effect with the client's next request. If the mysqld server is started without the --skip-grant-tables option, it reads all ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-checking.html
In that case, the trace will be shown as empty and the INSUFFICIENT_PRIVILEGES column will show "1". In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list entries. The other sources have negative performance consequences because they ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-status-and-maintenance.html
Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. To check whether the query cache is present in your MySQL server, use the following statement: mysql> SHOW VARIABLES LIKE 'have_query_cache'; ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
For example, an error in a collation might have been corrected, necessitating a table rebuild to update the indexes for character columns that use the collation. This section describes how to rebuild or repair tables or indexes, which may be ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
For example, it can be specified as a string expression or table column. Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular expression RLIKE Whether string ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-fractional-seconds.html
There may be problems replicating from a source server that understands fractional seconds to an older replica (MySQL 5.6.3 and earlier) that does not: For CREATE TABLE statements containing columns that have an fsp (fractional seconds precision) ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-triggers.html
A statement invoking a trigger (or function) that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based replication. With statement-based replication, triggers executed on the source also execute on the ...