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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. These events bring databases up to date from the point of the backup. The term “binary log file” generally denotes ...It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes originate) writes updates and changes as “events” to the binary ...Each replica receives a copy of the entire contents of the binary ...