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/create-tablespace.html
When setting EXTENT_SIZE or INITIAL_SIZE, you may optionally follow the number with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. If the directory specified does not exist, NDB attempts to create it; the ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
User lock The thread is going to request or is waiting for an advisory lock requested with a GET_LOCK() call. It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables. It is ...Many of these are useful only for finding bugs in the ... The following list describes thread State values that are associated with general query ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ...IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and ... Support for IPv6 in MySQL ...
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/installing-mysql-shell-starting.html
On the same system where the server instance is running, open a terminal window (command prompt on Windows) and start MySQL Shell with the following command: mysqlsh --uri user@localhost You are prompted to input your password and then this ... You ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html
If you enable setuid() core files for the current user, they are generated using mode 600, and are owned by the superuser. MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. A setting smaller than the default is generally suitable for most workloads. The ideal settings depend on your ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-names.html
For example, utf8_general_ci and latin1_swedish_ci are collations for the utf8 and latin1 character sets, respectively. For example, utf8_turkish_ci and utf8_hungarian_ci sort characters for the utf8 character set using the rules of Turkish and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. The VALUE column is empty if there is no user-defined ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 9.4, “User-Defined Variables”.