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/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. You can ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. A setting smaller than the default is generally suitable for most workloads. The ideal settings depend on your ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. If you want to cause the dump file to force a drop of each database before recreating it, use the ... This section ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by means of a user variable, and then check the value of the variable after the procedure returns. When the procedure returns, a client program can also obtain ... CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read does not set any locks on the tables it accesses, and therefore other sessions are free to modify those tables at the same time a consistent read is being performed on the table. SELECT that do not specify FOR UPDATE or LOCK IN ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-thread-by-current-bytes.html
current_count_used The current number of allocated memory blocks that have not been freed yet for the thread. current_allocated The current number of allocated bytes that have not been freed yet for the thread. current_avg_alloc The current number ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
The user-supplied expression is evaluated each time a record is inserted or updated. Note For simplicity, the tables in the examples that follow do not use any keys. You should be aware that, if a table has any unique keys, every column used in the ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-count.html
--ndb-connectstring Command-Line Format --ndb-connectstring=connection_string Type String Default Value [none] Set connect string for connecting to ndb_mgmd. --ndb-nodeid Command-Line Format --ndb-nodeid=# Type Integer Default Value [none] Set node ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...