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/mysqlbinlog-server-id.html
When invoked with the --read-from-remote-server option, mysqlbinlog connects to a MySQL server, specifies a server ID to identify itself, and requests binary log files from the server. You can use mysqlbinlog to request log files from a server in ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-server.html
The following discussion covers these MySQL server configuration topics: Startup options that the server supports. You can specify these options on the command line, through configuration files, or both. These variables reflect the current state and ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section 7.4.2, “Reloading SQL-Format Backups”. By default, mysqldump writes information as SQL statements to the ...
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/old-native-pluggable-authentication.html
MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of pluggable authentication. This section describes mysql_old_password, which ...
https://dev.mysql.com/doc/refman/5.7/en/opengis-geometry-model.html
The set of geometry types proposed by OGC's SQL with Geometry Types environment is based on the OpenGIS Geometry Model. In this model, each geometric object has the following general properties: It is associated with a spatial reference system, ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Because the InnoDB storage engine performs many of its ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...