PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated CHARACTER_SETS Available character sets ...
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. Because checksum mismatches cause InnoDB to deliberately ...It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
This enables you to specify all tables in a directory by using the pattern *.MYI. You should then ensure that no one is using the tables while you are running myisamchk However, the easiest way to avoid this problem is to use CHECK TABLE instead of ... The myisamchk utility gets information about your database tables or checks, repairs, or optimizes ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
The easiest way to accomplish this is to do a search-and-replace on the file that contains the definitions and replace all instances of TYPE=engine_name or ENGINE=engine_name with ENGINE=NDBCLUSTER. Note The information in this section applies to ...Working with database tables and data in NDB Cluster is not much different from doing so in standard ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
If this option is not given, mysql_install_db searches for mysqld in these locations: In the bin directory under the --basedir option value, if that option was given. Until this is done, the administrative account cannot be used for anything else.
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. This ...
https://dev.mysql.com/doc/refman/5.7/en/perl-support.html
You can obtain the necessary modules from http://search.cpan.org for Unix, or by using the ActiveState ppm program on Windows. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable binlog_gtid_simple_recovery Scope Global Dynamic No Type Boolean Default Value ON This variable controls how binary log files are iterated ...