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/libmysqld-restrictions.html
The embedded server has the following limitations: No loadable functions. You cannot set this up as a source or a replica (no replication). Very large result sets may be unusable on low memory systems. You cannot connect to an embedded server from ...
https://dev.mysql.com/doc/refman/5.7/en/load-index.html
tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ... | ALL } The LOAD INDEX INTO CACHE statement preloads a table index into the key ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are enabled. Possible destinations for log entries are log files or the general_log and slow_log tables in ...
https://dev.mysql.com/doc/refman/5.7/en/loop.html
[begin_label:] LOOP statement_list END LOOP [end_label] LOOP implements a simple loop construct, enabling repeated execution of the statement list, which consists of one or more statements, each terminated by a semicolon (;) statement delimiter.
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE statements. The -s option (short for --silent) causes ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
The following options to mysqld can be used to change the behavior of MyISAM tables. bulk_insert_buffer_size The size of the tree cache used in bulk insert optimization. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-starting.html
Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in applications that use the NDB Cluster 's data. For these reasons, it is not possible to offer a single configuration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
Each of the node parameter tables lists the parameters for a given type (ndbd, ndb_mgmd, mysqld, computer, tcp, or shm). All tables include the data type for the parameter, option, or variable, as well as its default, mimimum, and maximum values as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration.html
A MySQL server that is part of an NDB Cluster differs in one chief respect from a normal (nonclustered) MySQL server, in that it employs the NDB storage engine. This engine is also referred to sometimes as NDBCLUSTER, although NDB is preferred. To ...