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/handler.html
The HANDLER interface is a more natural way to look at data when working with applications that provide an interactive user interface to the database. (See Section 14.21, “InnoDB memcached Plugin” for an alternative way to adapt applications ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
Before you begin, you should change location to the database directory and check the permissions of the table files. On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are ...This section is for the cases where a table check fails (such as those described in Section 7.6.2, “How to Check MyISAM Tables for Errors”), or you want to use the extended features that myisamchk ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. INET6_NTOA(expr) Given an IPv6 or IPv4 network address ...The ...
https://dev.mysql.com/doc/refman/5.7/en/execute.html
If the prepared statement contains any parameter markers, you must supply a USING clause that lists user variables containing the values to be bound to the parameters. Parameter values can be supplied only by user variables, and the USING clause ...
https://dev.mysql.com/doc/refman/5.7/en/sys-execute-prepared-stmt.html
Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ...Thus, this procedure is useful primarily for executing dynamic statements on a one-time ...
https://dev.mysql.com/doc/refman/5.7/en/thread-information.html
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 1 User: ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
Queries are only added to the replica's slow query log when they are logged in statement format in the binary log, that is, when binlog_format=STATEMENT is set, or when binlog_format=MIXED is set and the statement is logged in statement format. Slow ...The slow query log can be used to find queries that take a long time to execute and are therefore candidates for ... The slow query log consists of SQL statements ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-message-compression.html
Compression for messages sent in the group happens at the group communication engine level, before the data is handed over to the group communication thread, so it takes place within the context of the mysql user session thread. You could use the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
For example, you can set up a source/replica relationship over a dial-up link where the link is up only sporadically and for short periods of time. How can I use replication to improve performance of my system? Set up one server as the source and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If statement-based binary logging format is in use on the source (binlog_format=STATEMENT), the replica evaluates the INSERT operation using the default database, which was set by the USE statement to db1 and has not been changed. The effect of the ... If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table ...