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/linux-installation-sles-repo.html
The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux Server. Instructions for using the MySQL SLES repository are available in A Quick Guide to Using the ...
https://dev.mysql.com/doc/refman/5.7/en/lz4-decompress.html
The lz4_decompress utility decompresses mysqlpump output that was created using LZ4 compression. Invoke lz4_decompress like this: lz4_decompress input_file output_file Example: mysqlpump --compress-output=LZ4 > dump.lz4 lz4_decompress dump.lz4 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-startup-messages.html
Possible startup messages with descriptions are provided in the following list: Initial start, waiting for %s to connect, nodes [ all: %s connected: %s no-wait: %s ] Waiting until nodes: %s connects, nodes [ all: %s connected: %s no-wait: %s ] ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-server.html
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-lock-tables.html
The Performance Schema exposes lock information through these tables: metadata_locks: Metadata locks held and requested table_handles: Table locks held and requested The following sections describe these tables in more detail.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: host_cache: Information from the internal host cache.
https://dev.mysql.com/doc/refman/5.7/en/programs-installation.html
The programs in this section are used when installing or upgrading MySQL.