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/server-options.html
--ignore-db-dir=dir_name Command-Line Format --ignore-db-dir=dir_name Deprecated Yes Type Directory name This option tells the server to ignore the given directory name for purposes of the SHOW DATABASES statement or INFORMATION_SCHEMA tables. When ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
The data file and index file can be moved elsewhere and replaced in the data directory by symlinks. (Bug #32167) myisamchk does not replace a symlink with the data file or index file. This is an extremely good reason not to run mysqld as the root ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Some options, which you might not use initially, help tune InnoDB performance characteristics based on machine capacity and your database workload. On a dedicated database server, you might set the buffer pool size to 80% of the machine's physical ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
In-Place Downgrade Logical Downgrade In-Place Downgrade In-place downgrade involves shutting down the new MySQL version, replacing the new MySQL binaries or packages with the old ones, and restarting the old MySQL version on the existing data ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY clause. (Bug #30753708, Bug #98199) The following clauses work essentially the same way for LOAD XML as they ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
For information about replacing third-party packages with official MySQL packages, see the related APT guide or Yum guide. These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. These trigger_event values are permitted: INSERT: The trigger activates whenever a new row is inserted into the ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. Replace root-password in the examples with the password that you want to use. This section ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
To keep code portable across databases, it is recommended that you use LEFT JOIN instead of RIGHT JOIN. MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: ...
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>', ...