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/symbolic-links-to-databases.html
On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create a soft link to it from the MySQL data directory. $> mkdir /dr1/databases/test $> ln -s /dr1/databases/test ...
https://dev.mysql.com/doc/refman/5.7/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 8.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html
For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
You can also query the tables in the ndbinfo information database for real-time data about many NDB Cluster operations. This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. It is always enabled and attempting to disable it (--skip-secure-auth, --secure-auth=0) produces an ... The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-build-configuration.html
One indication of this issue is the presence of messages such as the following in the error log: [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table ...It is possible to exclude certain parts ...
https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. With this plugin-loading method, the option must be given each time the server starts. For example: mysql> SELECT PLUGIN_NAME, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-remarks.html
REORGANIZE PARTITION (or the execution of any other DDL statement), it is not possible to restart cluster data nodes. The creation of the node group is rolled back If the execution of CREATE NODEGROUP has reached the internal commit point: When ...
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
Log flushing occurs when you issue a FLUSH LOGS statement; execute mysqladmin with a flush-logs or refresh argument; or execute mysqldump with a --flush-logs option. You can control the general query and slow query logs during runtime. MySQL Server ...