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/mysql-server-side-help.html
The proper operation of this command requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, “Server-Side Help Support”). To make a more specific request, please type 'help <item>', ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
mysqld_safe accepts options on the command line and in option files, as described in the following table. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when ...
https://dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html
This section describes mysql_native_password, which implements authentication against the mysql.user system table using the native password hashing method. The following table shows the plugin names on the server and client sides. MySQL includes ...
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
To tell mysqld to keep open fewer files at a time, you can make the table cache smaller by reducing the value of the table_open_cache system variable (the default value is 64). This may not entirely prevent running out of file descriptors because in ... If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
This section describes mysql_old_password, which implements authentication against the mysql.user system table using the older (pre-4.1) native password hashing method. The following table shows the plugin names on the server and client sides.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
Alternatively, for transactions that consist only of a single SELECT statement, turning on AUTOCOMMIT helps InnoDB to recognize read-only transactions and optimize them. When rows are modified or deleted within a long-running transaction, other ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. However, the content of the tables in the performance_schema database misses events. For example, ...Names ...
https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. Assign passwords to the initial root account in the grant tables, if that was not already ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-sql-mode.html
If you are replicating partitioned tables, using different SQL modes on the source and the replica is likely to cause issues. At a minimum, this is likely to cause the distribution of data among partitions to be different in the source's and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transaction-inconsistencies.html
A transaction which updates non-transactional tables has applied some but not all of its changes. STOP SLAVE when the ongoing transaction updates transactional tables only, in which case it is rolled back and STOP SLAVE stops immediately. The source ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...