PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/MySQLInstallerConsole.html
MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL Installer. This reference includes: MySQL Product Names Command Syntax Command Actions The console is installed when MySQL Installer is initially executed and ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
$> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you have created the NDB native backup using ndb_mgm, you must not make any schema changes before creating the backup of the schema, if you do so. It is ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html
The FIXED synonym is available for compatibility with other database systems. For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 11.1.6, ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-benchmarking.html
For benchmarking, sometimes you must simulate a heavy database workload to get an accurate picture. To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
Since the performance requirements to retrieve and display a BLOB value might be very different from other data types, you could put the BLOB-specific table on a different storage device or even a separate database instance. When storing a large ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
This also gives better performance with most database systems, because the row locking manager in this case has less to do. Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
In addition, changing the character set or collation for a given database, table, or column after such a table is created may cause changes in how rows are distributed. Range columns partitioning is similar to range partitioning, but enables you to ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
The PARTITIONS table in the INFORMATION_SCHEMA database provides information about partitions and partitioned tables. Note As of MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is removed in MySQL 8.0, when the ...