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/information-schema-collations-table.html
SORTLEN This is related to the amount of memory required to sort strings expressed in the character set. The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
Attempting to run innochecksum on a tablespace that the server already has open results in an Unable to lock file error. This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
$> mysqld --innodb-buffer-pool-size=9G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; +------------------------------------------+ | @@innodb_buffer_pool_size/1024/1024/1024 | ... You can configure InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
Primary key values are included in secondary indexes, which takes up unnecessary space if the primary key is a long string value. This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be somewhat slower than using memcached by itself. When using the InnoDB memcached plugin, ...
https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html
This section describes how to install MySQL from the latest development source code, which is hosted on GitHub. To obtain the MySQL Server source code from this repository hosting service, you can set up a local MySQL Git repository. On GitHub, ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/5.7/en/language-structure.html
This chapter discusses the rules for writing the following elements of SQL statements when using MySQL: Literal values such as strings and numbers Identifiers such as database, table, and column names Keywords and reserved words User-defined and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-computer-definition.html
Id Version (or later) NDB 7.5.0 Type or units string Default [...] Range ... The [computer] section has no real significance other than serving as a way to avoid the need of defining host names for each node in the system. Restart Type Initial ...