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/innodb-memcached-ddl.html
If this option is set to a value greater than 1, use READ UNCOMMITTED queries to find rows that were just inserted. If this option is set to a value greater than 1, changes made to the table using SQL are not immediately visible to memcached ... You ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-restrictions.html
As of MySQL 5.7.8, the default value for this directory can be set at build time with the INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR CMake option. You cannot set this up as a source or a replica (no replication). Very large result sets may be unusable on ... The embedded server has the following limitations: No loadable ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
If you already created some InnoDB tables, also delete the corresponding .frm files for these tables, and any .ibd files if you are using multiple tablespaces, from the MySQL database directories. The troubleshooting steps for InnoDB I/O problems ...Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
For more information, see Section 4.5.4, “mysqldump — A Database Backup Program”. For InnoDB, all tables in all databases are stored in the system tablespace files, unless you have the innodb_file_per_table option enabled. The following files ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
Invalid values for ENUM and SET columns are handled as described in Section 1.6.3.4, “ENUM and SET Constraints”. You can select stricter treatment of input values by using the STRICT_TRANS_TABLES or STRICT_ALL_TABLES SQL modes: SET sql_mode = ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-overview.html
The MySQL pluggable storage engine architecture enables a database professional to select a specialized storage engine for a particular application need while being completely shielded from the need to manage any specific application coding ...The ...The MySQL server architecture isolates the application programmer and DBA from all of the low-level implementation details at the storage level, providing a consistent and easy application model and ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create.html
Create the table on the local server with an identical table definition, but adding the connection information that links the local table to the remote table. You can either create the local table and specify the connection string (containing the ...
https://dev.mysql.com/doc/refman/5.7/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
https://dev.mysql.com/doc/refman/5.7/en/drop-trigger.html
DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use IF EXISTS to prevent an error from occurring for a trigger that does not exist. A NOTE is generated for a nonexistent trigger when using IF EXISTS. Triggers ... DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-examples-of-use-case-scenarios.html
The following examples are typical use cases for Group Replication. Autonomic Systems - Additionally, you can deploy MySQL Group Replication purely for the automation that is built into the replication protocol (described already in this and ...