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-plugin.html
Alternatives include loading plugins at server startup using the --plugin-load or --plugin-load-add option, or at runtime using the INSTALL PLUGIN statement. It provides an alternative to manually specifying the --plugin-load option at server ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server.html
Copy the script to the /etc/init.d directory with the name mysql and make it executable: cp mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql After installing the script, the commands needed to activate it to run at system startup depend on ... MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
Without this option, mysqldump treats the first name as a database name and those following as table names. To dump only specific tables from a database, name them on the command line following the database name: $> mysqldump test t1 t3 t7 > ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-stored-programs.html
The other options are disabled by default and must be specified explicitly to dump the corresponding objects. To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ... When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production ...
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
The current set of valid short phrases for use with commands is shown in the following table. Alternatively, you can pass in the exact version and architecture (x86 or x64) after the product keyword using the --silent option.
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Typically this is value+1, where value is the ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: name The function name as referred to in SQL statements. dl The name of the function ...Permitted values are 0 (STRING), 1 (REAL), 2 (INTEGER), 3 (ROW), or 4 ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-benchmarking.html
With simple tests, you usually test how changing one aspect (a configuration setting, the set of indexes on a table, the SQL clauses in a query) affects performance. The two most important features to try with each workload are the MySQL query ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
See also Section 8.2.2, “Optimizing Subqueries, Derived Tables, and View References”. Use x = ANY (table containing (1,2)) rather than x=1 OR x=2. Development is ongoing, so no optimization tip is reliable for the long term. The following list ...