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/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. As a workaround, refer instead to user-defined variables, which also have session scope; see Section 9.4, “User-Defined Variables”.
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
These functions include FOUND_ROWS(), GET_LOCK(), IS_FREE_LOCK(), IS_USED_LOCK(), LOAD_FILE(), MASTER_POS_WAIT(), PASSWORD(), RAND(), RELEASE_LOCK(), ROW_COUNT(), SESSION_USER(), SLEEP(), SYSDATE(), SYSTEM_USER(), USER(), UUID(), and UUID_SHORT().
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
Renaming an index ALTER TABLE tbl_name RENAME INDEX old_index_name TO new_index_name, ALGORITHM=INPLACE, LOCK=NONE; Adding a FULLTEXT index CREATE FULLTEXT INDEX name ON table(column); Adding the first FULLTEXT index rebuilds the table if there is ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...The CREATE INDEX statement only finishes after all transactions ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
Row-level locking and Oracle-style consistent reads increase multi-user concurrency and performance. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, rollback, and crash-recovery capabilities to ... InnoDB is a general-purpose storage engine that balances high reliability and high ...Unless you have configured a different default storage ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
$> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you have created the NDB native backup using ndb_mgm, you must not make any schema changes before creating the backup of the schema, if you do so. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-formats.html
The logging format in a running MySQL server is controlled by setting the binlog_format server system variable. The rules governing when and how the new setting takes effect are the same as for other MySQL server system variables. Setting the ...The ... Replication works because events written to the binary log are read from the source and then processed on the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. Additional Resources You may find the Stored Procedures User Forum of use when working with stored ...Stored ...A stored routine is a set of SQL statements that can be stored in the ...Once this has been done, clients don't need to keep ...
https://dev.mysql.com/doc/refman/5.7/en/security.html
The security is related to the grants for individual users, but you may also wish to restrict MySQL so that it is available only locally on the MySQL server host, or to a limited set of other hosts. These include choosing good passwords, not ...For ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
--connect-retries=# Command-Line Format --connect-retries=# Type Numeric Default Value 12 Minimum Value -1 Minimum Value -1 Minimum Value 0 Maximum Value 65535 Set the number of times to retry a connection before giving up; 0 means 1 attempt only ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
The default settings represent a combination of high reliability and the fewest surprises for database applications. For example, default settings avoid uncommitted data on the database side, or stale data returned for memcached get requests. You ...