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-cluster-replication-backups.html
This section discusses making backups and restoring from them using NDB Cluster replication. We assume that the replication servers have already been configured as covered previously (see Section 21.7.5, “Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. For information about reloading such dump files, see Section 7.4.4, “Reloading Delimited-Text Format Backups”. If you invoke mysqldump with the --tab=dir_name ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section 7.4.2, “Reloading SQL-Format Backups”. By default, mysqldump writes information as SQL statements to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production version. Then you can dump the database and database object definitions from the production server and load them into the new ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD DATA syntax. Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 ...
https://dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html
MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of pluggable authentication. This section describes mysql_native_password, which ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of pluggable authentication. This section describes mysql_old_password, which ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your server. For example, an application might encounter performance issues if it commits thousands of ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. This updates a value for each index part that indicates ...