MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 171 to 180 of 189 total results

25.12.10 Performance Schema User-Defined Variable Tables

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-user-variable-tables.html

The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 9.4, “User-Defined Variables”.

25.12.8.3 The users Table

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html

For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 25.12.8, “Performance Schema Connection Tables”. The users table contains a row for each user who has connected to ...

12.21 Precision Math

https://dev.mysql.com/doc/refman/5.7/en/precision-math.html

For example, you can treat a value that is too large for a column as an error rather than having the value truncated to lie within the range of the column's data type. MySQL provides support for precision math: numeric value handling that results ...

8.15.14 Preventing the Use of Optimizer Trace

https://dev.mysql.com/doc/refman/5.7/en/preventing-use-of-optimizer-trace.html

If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...

6.2.2 Privileges Provided by MySQL

https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage ...

8.10.3.1 How the Query Cache Operates

https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html

A table can be changed by many types of statements, such as INSERT, UPDATE, DELETE, TRUNCATE TABLE, ALTER TABLE, DROP TABLE, or DROP DATABASE. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section ...

16.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html

(A truncation warning is issued in all such cases.) The default and maximum value is 1073741824 (1 GB); the minimum is 1024. This section explains the server options and system variables that apply to replicas and contains the following: Startup ...

5.1.9 Server Status Variables

https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html

Innodb_truncated_status_writes The number of times output from the SHOW ENGINE INNODB STATUS statement has been truncated. The MySQL server maintains many status variables that provide information about its operation. You can view these variables ...

11.3.6 The SET Type

https://dev.mysql.com/doc/refman/5.7/en/set.html

A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. SET column values that consist of multiple set members are specified with members ...

5.1.10 Server SQL Modes

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

When strict mode is not enabled, this results in a warning and truncation of the key to the maximum key length. ER_BAD_NULL_ERROR ER_CUT_VALUE_GROUP_CONCAT ER_DATA_TOO_LONG ER_DATETIME_FUNCTION_OVERFLOW ER_DIVISION_BY_ZERO ... The MySQL server can ...

Displaying 171 to 180 of 189 total results