PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: mysqladmin [options] command [command-arg] [command [command-arg]] ... Some of the commands take an argument ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
If this option is given twice (by passing in either "-vv" or "--verbose --verbose"), the output includes comments to indicate column data types and some metadata, and row query log events if so configured. The server's binary log consists of files ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-to-different-version.html
You can check such tables using CHECK TABLE, and then upgrade them to the newer temporal column format, if necessary, using REPAIR TABLE in the mysql client; this must be done prior to taking the backup. The following two sections provide ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-types.html
For information about how MySQL handles assignment of out-of-range values to columns and overflow during expression evaluation, see Section 11.1.7, “Out-of-Range and Overflow Handling”. These types include the exact numeric data types (INTEGER, ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: name The function name as referred to in SQL statements. Permitted values are 0 ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
Queries that normally could retrieve all the result columns from a secondary index, instead look up the appropriate values from the table data. To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
For example: SELECT * FROM t1 WHERE t1.column1 IN (SELECT column1 FROM t2 ORDER BY column1); SELECT * FROM t1 WHERE t1.column1 IN (SELECT DISTINCT column1 FROM t2); SELECT * FROM t1 WHERE EXISTS (SELECT * FROM t2 LIMIT 1); Replace a join with a ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns). A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary ...