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/structured-system-variables.html
(You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that has a size of 128KB, with the size of block buffers for caching table index blocks set to 2048 bytes. For ...A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Be careful with the medium setting and especially the full setting, which has a large performance impact. Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. Regardless of the statement ...You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
For the binary log, you can set the expire_logs_days system variable to expire binary log files automatically after a given number of days (see Section 5.1.7, “Server System Variables”). To rename the general query log or slow query log at ...On ... As described in Section 5.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-compared.html
Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB Cluster. See Section 21.2.6.3, “NDB and InnoDB Feature Usage Summary”, for a comparison of the relative ...While ... MySQL Server offers a number of choices in storage ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
The automatic row-level locking makes these tables suitable for your busiest databases with your most important data, while also simplifying application logic since you do not need to lock and unlock tables. For this storage engine, avoid using the ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/5.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. Many MySQL APIs (such as PHP) enable you to treat the result returned from a SHOW statement as you would a result set from a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the database that contains the table being queried. --ndb-connectstring Command-Line Format ... ndb_index_stat ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
For example, MeCab tokenizes “データベース管理” (“Database Management”) into “データベース” (“Database”) and “管理” (“Management”). To install and configure the MeCab parser plugin, perform the following ...To ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-cluster-connection-pool-nodeids: Comma-separated list of node IDs for connections to cluster used by MySQL; number of nodes in list must match value set for --ndb-cluster-connection-pool. ndb-mgmd-host: Set host (and port, if desired) for ...For ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...