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/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/mysqld.html
When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients. For a complete list of options, run this command: mysqld --verbose --help MySQL Server also has a set of ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-relaylog.html
The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log files. The term “relay log file” generally denotes an ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...PARTITION BY KEY are similar to those for creating a table that is partitioned by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
fq_name is a fully qualified database object name in database/schema/name format, such as test/def/t1 or sys/def/10/b$unique. The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests ...Together with the block name, this number can be used to look up a given instance in the threadblocks ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. You can copy the files that correspond to a database table into some other location and perform recovery operations on them there. myisamchk ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html
In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. To help reduce possible confusion, we recommend that you always use the same ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL tries to reduce the number of random disk access for range scans by first scanning the index only and collecting the keys for the relevant rows. The motivation for Disk-sweep MRR is to ... Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config.html
The options returned are tied to the specific compiler that was used when the library was created and might clash with the settings for your own compiler. mysql_config provides you with useful information for compiling your MySQL client and ...It ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. For example: mysql> SELECT * FROM ...Other tables that contain ...