PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizing-server.html
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
We call this value V; it can be calculated as: V = POWER(2, CEILING(LOG(2, num))) (Suppose that num is 13. MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
Summary tables that depend on the connection table are implicitly truncated, as described later in this section. When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table lists the available instruments: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-configuration-table.html
This table shows the configuration parameters that affect transactions applied by the replica. The replication_applier_configuration table has these columns: CHANNEL_NAME The replication channel which this row is displaying. Parameters stored in ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Exceptions to this truncation behavior are noted in individual summary table sections. The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
This means that if the new statement contains an error and cannot be prepared, an error is returned and no statement with the given name exists. PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
This means that the threads table can be used to monitor thread activity the other sources cannot. For SHOW PROCESSLIST, this value contains only the first 100 characters of the statement. The following discussion enumerates the sources of process ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
This is because prefixes can cause problems when new options are implemented for programs and a prefix that is currently unambiguous might become ambiguous in the future. Some implications of this change: The --key-buffer option must now be ... Many ...