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/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. The creator of a routine is the account used to execute the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-multiple-nodes.html
(See next item for an example.) Implementing table locks in NDBCLUSTER can be done in an API application, and ensuring that all applications start by setting LockMode to LM_Read or LM_Exclusive. A LOCK TABLES statement or GET_LOCK() call works only ...The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...row ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
You can access the underlying InnoDB table through SQL for reporting, analysis, ad hoc queries, bulk loading, multi-step transactional computations, set operations such as union and intersection, and other operations suited to the expressiveness and ...Running memcached in the same process space as the MySQL server avoids the network overhead of passing requests back and ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
For permanent failures, the host name remains NULL and the validation flag is set to true. For example, to set the size to 100 at startup, put these lines in the server my.cnf file: [mysqld] host_cache_size=200 To change the size to 300 at runtime, ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
At runtime, these source-side system variables are available: SET GLOBAL rpl_semi_sync_master_enabled = {0|1}; SET GLOBAL rpl_semi_sync_master_timeout = N; On the replica side, this system variable is available: SET GLOBAL ...For general information ... Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-error-reporter.html
Optionally, you can supply the name of a user that is able to access the cluster's data nodes using SSH, to copy the data node log files. ndb_error_reporter also accepts the options listed here: --connection-timeout=timeout Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage.html
Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN statement. Ensure that there are no tables using a storage engine before you unplug the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform their own processing on the ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. Bugs posted in the bugs database at http://bugs.mysql.com/ that are corrected for a given release are noted in the release notes. To ...We ...