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/replication-multi-source-configuration.html
If you create an account solely for the purposes of replication, that account needs only the REPLICATION SLAVE privilege. You can use the same account on all the sources, or a different account on each. A multi-source replication topology requires ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. This state occurs after ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is not needed for account management statements such as GRANT or REVOKE, which take effect ...| ...
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/repair-table-optimization.html
For key_buffer_size, you must take into account that the buffer is shared with those users. Setting a session value limits the effect of the change to your current session and does not affect other users. Changing a global-only variable ... REPAIR ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Log in to the OCR with your Docker client (the docker command) using the docker login command: # docker login container-registry.oracle.com Username: Oracle-Account-ID Password: password Login successful. Other platforms are not supported, and users ... Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. In the example, the trigger body is a simple ...Here is a simple example that associates a trigger with a table, to activate for INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
The following sections describe how to add user-defined collations of the first two types to existing character sets. Summary of the procedure for adding a new user-defined collation: Choose a collation ID. The instructions here cover only ... A ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir Logical Downgrade Logical downgrade involves using mysqldump to dump all tables from the new MySQL version, and then loading the dump file into ... This section describes how to downgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
For example, Oracle Database users are familiar with querying tables in the Oracle data dictionary. INFORMATION_SCHEMA and Privileges For most INFORMATION_SCHEMA tables, each MySQL user has the right to access them, but can see only the rows in the ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...