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/mysqld-safe.html
The actual locations are determined from the values configured into the distribution at the time it was built. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump db1 > dump.sql On Server 2: $> mysqladmin create db1 $> mysql db1 < dump.sql You can specify a different database name in this case, so omitting --databases from the mysqldump command enables you to dump data from one ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
* and ? characters are converted into SQL % and _ wildcard characters. The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. The same information can be obtained by using those ...
https://dev.mysql.com/doc/refman/5.7/en/nested-loop-joins.html
For example, if 10 rows are read into a buffer and the buffer is passed to the next inner loop, each row read in the inner loop can be compared against all 10 rows in the buffer. MySQL executes joins between tables using a nested-loop algorithm or ...
https://dev.mysql.com/doc/refman/5.7/en/null-values.html
The NULL value means “no data.” NULL can be written in any lettercase. Treatment of \N as a synonym for NULL in SQL statements is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0; use NULL instead. Be aware that the NULL value is ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table and referencing it with a join query when needed. When storing a large blob ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. For character and ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-multi-tables.html
When the number of tables runs into the thousands or even millions, the overhead of dealing with all these tables becomes a new performance consideration. Some techniques for keeping individual queries fast involve splitting data across many tables.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Moving purge operations (a type of garbage collection) into a background thread. Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of ...