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/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. On Windows, you can create a ... On ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
DEFINER The account of the user who created the view, in 'user_name'@'host_name' format. This column has most of what you see in the Create Table column that SHOW CREATE VIEW produces. Suppose that the original statement was: CREATE VIEW v AS SELECT ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-data-directories.html
It has the default set of MySQL accounts and no user data. Copy an Existing Data Directory With this method, any MySQL accounts or user data present in the data directory are carried over to the new data directory. There are different methods of ...
https://dev.mysql.com/doc/refman/5.7/en/assignment-operators.html
Causes the user variable on the left hand side of the operator to take on the value to its right. Section 9.4, “User-Defined Variables”, explains why you should avoid doing this. Within a SET statement, = is treated as an assignment operator ...
https://dev.mysql.com/doc/refman/5.7/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-thread-pool.html
It is designed to cache idle connections in the MySQL client for use by other users as they are needed. If you are using the innodb_thread_concurrency to limit the number of concurrently executing statements, you should find that the Thread Pool ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine lacks. For example, a user searching for “database” may really mean that “MySQL”, ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Important The mysql.session ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
This is not like user tables, where the data changes only when application-initiated updates occur. Because InnoDB must temporarily stall while the transaction and locking data is collected, too frequent queries of these tables can negatively impact ... The data exposed by the transaction and locking tables (INNODB_TRX, INNODB_LOCKS, and INNODB_LOCK_WAITS) represents a glimpse into fast-changing ...