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-status-monitoring.html
Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be created. If the server cannot create a given instrumented mutex instance, it increments Performance_schema_mutex_instances_lost. INSTALL PLUGIN ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
The audit log plugin can also control which audited events are written to the audit log file, based on event content or the account from which events originate. For best security, write the audit log to a directory accessible only to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
To discuss problems with other users, you can use the MySQL Community Slack. If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. The information helps us create a ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You might have to run commands as the MySQL root user on the new machine until you have the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_users_lost The number of times a row could ...Performance_schema_digest_lost The number of digest instances that could not be instrumented in the events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
If you modify the grant tables indirectly using an account-management statement, the server notices these changes and loads the grant tables into memory again immediately. Any user can connect and perform any operation, which is insecure. If the ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), g VARCHAR(6000)) ENGINE=InnoDB CHARACTER SET latin1; ERROR 1118 (42000): Row size too large. You have to change some ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
CREATE TABLE Failure Due to Orphan Table A symptom of an out-of-sync data dictionary is that a CREATE TABLE statement fails. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
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 ...