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/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instance-tables.html
They provide event names and explanatory notes or status information: cond_instances: Condition synchronization object instances file_instances: File instances mutex_instances: Mutex synchronization object instances rwlock_instances: Lock ...There ...
https://dev.mysql.com/doc/refman/5.7/en/row-constructor-optimization.html
For example, these two statements are semantically equivalent: SELECT * FROM t1 WHERE (column1,column2) = (1,1); SELECT * FROM t1 WHERE column1 = 1 AND column2 = 1; In addition, the optimizer handles both expressions the same way. row ...The ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
Instead, you're usually more interested in answering a particular question, in which case you specify some constraints on the information you want. String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', ... As shown in the preceding section, it is easy to retrieve an entire ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
Type The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION. For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. For information about plugin data ...
https://dev.mysql.com/doc/refman/5.7/en/source-thread-states.html
The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. Master has sent all binlog to slave; waiting for more updates The thread has read all remaining updates from the ...If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no replicas are currently ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
These objects are defined in terms of SQL code that is stored on the server for later invocation (see Chapter 23, Stored Objects). A compound statement is a block that can contain other blocks; declarations for variables, condition handlers, and ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines-other.html
For further information, documentation, installation guides, bug reporting or for any help or assistance with these engines, please contact the developer of the engine directly. For more information on developing a customer storage engine that can ... Other storage engines may be available from third parties and community members that have used the Custom Storage Engine ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...