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/docker-mysql-getting-started.html
Among other instructions discussed there, it is especially important to back up your database before the upgrade. Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
Before downgrading to a previous version, it is recommended that you drop the sys schema: DROP DATABASE sys; If you are downgrading to a release that includes the sys schema, mysql_upgrade recreates the sys schema in a compatible form. The effect ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking is not a replacement for the table definition cache, and its mutexes and locks differ from the LOCK_open mutex. Metadata ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
While many standard MySQL schemas and applications can work using NDB Cluster, it is also true that unmodified applications and database schemas may be slightly incompatible or have suboptimal performance when run using NDB Cluster (see Section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-binary.html
Since the "world" database takes up # only about 500KB, this should be more than enough for # this example Cluster setup. Instead, you must either escape each backslash character with a second backslash (\\), or replace the backslash with a forward ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
(One use of this is in the NDB implementation of the REPLACE SQL statement.) The tot_key_refs column shows the number of key operations refused by the LDM. The operations_per_fragment table provides information about the operations performed on ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
Database administrators should use the following guidelines to keep passwords secure. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) or the my.cnf file that specifies the plugin directory location ...MySQL stores passwords for user accounts in the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Consider these statements: SELECT * FROM orders WHERE customer_id=10 AND quantity>20 SELECT * FROM orders WHERE customer_id = 20 AND quantity > 100 To normalize these statements, the parser replaces data values by ? and adjusts whitespace. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
uuid: hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh h: [0-9|A-F] interval: n[-n] (n >= 1) mysql.gtid_executed Table GTIDs are stored in a table named gtid_executed, in the mysql database. To save space, the MySQL server compresses the mysql.gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
An example use case for this action is when you are restoring a backup of one or more databases on a server, but you do not have the relevant binary logs containing the transactions on the server. The MySQL Server system variables described in this ...