PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
See MySQL Cluster Manager 1.4.8 User Manual, for more information about this tool. When I run the SHOW command in the NDB Cluster management client, I see a line of output that looks like this: A.10.8. The loading process terminates prematurely and ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
Some basic information about XPath syntax and usage is provided later in this section; however, an in-depth discussion of these topics is beyond the scope of this manual, and you should refer to the XML Path Language (XPath) 1.0 standard for ...Note ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
You can force client programs to use specific character set as follows: [client] default-character-set=charset_name This is normally unnecessary. However, when character_set_system differs from character_set_server or character_set_client, and you ... The MySQL server has a compiled-in default character set and ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
In this case, you must remove any remaining files or directories manually and issue the DROP DATABASE statement again. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. DROP {DATABASE | SCHEMA} ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
Because you can access the underlying data through SQL, you can produce reports, search or update across multiple keys, and call functions such as AVG() and MAX() on memcached data. You do not need to manually load data into memcached at startup.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
If you set this option on a server s1, then when server s2 is establishing a connection to s1 for the purpose of engaging group communication, s1 first checks the allowlist before accepting the connection from s2. This address is not the same as the ... The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System connection can be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
In this case, manually remove the .isl file from the schema directory. Replicating the path in this case would cause the source and replica to create the table in same location. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = ... There are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
In this case, you could manually rename the tablespace file and restart crash recovery, or you could restart the server in recovery mode using the innodb_force_recovery option. To achieve point-in-time recovery after restoring a backup, you can ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
This backup should be updated regularly—perhaps even hourly—depending on your needs. Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the ...
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: ...