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/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the ...
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-init-startup-configuration.html
(The MySQL server changes its current working directory to the data directory when it begins executing.) If you specify innodb_data_home_dir as an empty string, you can specify absolute paths for data files listed in the innodb_data_file_path value.
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-troubleshoot.html
loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, such as a numeric type instead of a string type, attempts to store key-value pairs fail with no specific error code or message. This section ...
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/innodb-online-ddl-operations.html
When you add a primary key using the ALGORITHM=COPY clause, MySQL converts NULL values in the associated columns to default values: 0 for numbers, an empty string for character-based columns and BLOBs, and 0000-00-00 00:00:00 for DATETIME. Online ...
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/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/literals.html
These include strings, numbers, hexadecimal and bit values, boolean values, and NULL. This section describes how to write literal values in MySQL. The section also covers various nuances that you may encounter when dealing with these basic types in ...