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/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to ...A ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
Although historically big redo log files caused lengthy recovery times, recovery is now much faster and you can confidently use large redo log files. Consider the following guidelines for optimizing redo logging: Make your redo log files big, even ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
If explicit COLLATE Y and COLLATE Z occur, raise an error. MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-plugins-table.html
The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. PLUGIN_STATUS The plugin status, one of ACTIVE, INACTIVE, DISABLED, or DELETED. PLUGIN_TYPE The type of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition-direct.html
Setting up a cluster using direct connections between data nodes requires specifying explicitly the crossover IP addresses of the data nodes so connected in the [tcp] section of the cluster config.ini file. In the following example, we envision a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. Each server within a replication topology must be configured with a unique server ID, which ...
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
This is true even for the second string; the _latin1 introducer does not affect escape processing. Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default ...