PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
Use --all-databases, --events, and --routines to back up all data, and --master-data=2 to include the current binary log coordinates in the dump file. mysqldump --host=host_name --all-databases --events --routines --master-data=2> dump_file Execute ... By default, mysqlbinlog reads binary log files and displays their contents in text ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld.html
MySQL Server manages access to the MySQL data directory that contains databases and tables. When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients. mysqld, also ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
The following command dumps the contents of the db1 database to files in the /tmp database: $> mysqldump --tab=/tmp db1 The .txt files containing table data are written by the server, so they are owned by the system account used for running the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-tips.html
This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another How to dump stored programs (stored procedures and functions, triggers, and ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-numeric.html
If you are using numeric data, it is faster in many cases to access information from a database (using a live connection) than to access a text file. Information in the database is likely to be stored in a more compact format than in the text file, ... For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/pam-pluggable-authentication.html
There can be multiple applications associated with a single database server instance, so the choice of service name is left to the SQL application developer. Any user who connects using the proxy account is mapped to one of those MySQL accounts, the ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
ndb_sync_excluded_objects: Shows information about NDB database objects for which automatic synchronization has failed due to permanent errors resulting from mismatches which cannot be reconciled without manual intervention; these objects are ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The effect of the default object configuration is to instrument all objects except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. (Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...