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/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ...This ...The connection string specifies the server name, login credentials, port number and database/table ...The CONNECTION string contains the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
The setup_timers table contains a row with a NAME value of transaction that indicates the unit for transaction event timing. The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction ...These ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
To change the ranges for a subset of partitions defined using VALUES LESS THAN or the value lists for a subset of partitions defined using VALUES IN. Employing MAX_ROWS to force the number of table partitions is deprecated in NDB 7.5.4 and later; ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have write access to MySQL database directories. For files used by tables for other storage engines, you may get strange ...Do ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
The second instructs mysql to prompt for the password value and to use test as the default database. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as ...An ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
Then the BKA algorithm builds keys to access the table to be joined for all rows in the buffer and submits these keys in a batch to the database engine for index lookups. For BKA to be used, the batched_key_access flag of the optimizer_switch system ...Benefits of BKA include improved join performance due to more efficient table ... In MySQL, a Batched Key Access (BKA) Join ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
These variables have three possible values, which differ as follows: When the variable is set to nulls_equal, all NULL values are treated as identical (that is, they all form a single value group). Setting the global value affects statistics ...When ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
To shut down the servers, connect to each using the appropriate port number: C:\> C:\mysql\bin\mysqladmin --port=3307 --host=127.0.0.1 --user=root --password shutdown C:\> C:\mysql\bin\mysqladmin --port=3308 --host=127.0.0.1 --user=root --password ...Enable such connections by starting the server with the shared_memory system variable enabled and specify a unique shared-memory name for each server by setting the shared_memory_base_name system ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-native.html
During installation, the initial database is created, and you are prompted for the MySQL root password (and confirmation). The database tables are automatically created for you, if they do not already exist. You should, however, run ... Many Linux ...Important Native packages are often several versions behind the currently available ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
Users are strongly urged not to use database files that contain Barracuda file format tables with releases of InnoDB older than the MySQL 5.1 with the InnoDB Plugin. All tables using any file format supported by a release can be read or written ...