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/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ...If mysql_upgrade finds that a table has a possible incompatibility, it performs a table check and, if problems are found, attempts a table ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
The --parallel-schemas option also affects parallelism and can be used to override the default number of threads. With --default-parallelism=0 and no --parallel-schemas options, mysqlpump runs as a single-threaded process and creates no queues. To ... 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 statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
A schema mismatch error is reported if the clauses do not match. Otherwise, a schema mismatch error is reported when you attempt the import operation. (You can obtain the table definition using SHOW CREATE TABLE syntax.) If the table definition does ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Similar schema object hierarchy information is available in other ndbinfo tables. Since not all schemas or rows have a variable-sized part, var_elem_count can be less than fixed_elem_count. memory_per_fragment Table: Notes memory_per_fragment ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
System and status variable information is now available in Performance Schema tables, in preference to use of INFORMATION_SCHEMA tables to obtain these variable. See Section 25.20, “Migrating to Performance Schema System and Status Variable ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
This may be desirable when backing up and restoring between different schema versions with primary key changes on one or more tables, and it appears that performing the restore operation using ndb_restore is simpler or mor efficient than issuing ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
CREATE EVENT requires the EVENT privilege for the schema in which the event is to be created. The minimum requirements for a valid CREATE EVENT statement are as follows: The keywords CREATE EVENT plus an event name, which uniquely identifies the ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. To view available MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
For example, suppose that jon@ghidora has the EVENT privilege for myschema. Suppose also that this user has the SELECT privilege for myschema, but no other privileges for this schema. If you inspect the MySQL error log (hostname.err), you can see ...