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/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ... my_print_defaults displays the options that are present in option groups of option ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your login name on Unix, and ODBC on Windows. The default password is “no password.”) If you cannot connect to the ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
For example, on Windows, you can set the USER variable to specify your MySQL account name. To do so, use this syntax: SET USER=your_name The syntax on Unix depends on your shell. If your shell is tcsh, add the following line to your .tcshrc file: ...
https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
Locate the following key in the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters On the Edit menu, click Add Value, and then add the following registry value: Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534 ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
For results consisting of multiple values, a temporary table may be created and you might see <temporary table> instead. <in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is ... For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. For an example specific to full-text indexing, see Section 12.9.7, “Adding a User-Defined Collation for Full-Text ...You can ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, ... InnoDB is a general-purpose storage engine that balances high reliability and high ...