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/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run stops. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-fragments.html
The table_fragments table provides information about the fragmentation, partitioning, distribution, and (internal) replication of NDB tables.
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
The second command line displays a help message specific to the set command. The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named .mylogin.cnf. The file location is the ...
https://dev.mysql.com/doc/refman/5.7/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/doc/refman/5.7/en/which-version.html
When preparing to install MySQL, decide which version and distribution format (binary or source) to use. First, decide whether to install a development release or a General Availability (GA) release. Development releases have the newest features, ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. Section 23.4.6, “The Event Scheduler and MySQL Privileges”, discusses the privileges required to work with events and the ...The following discussion covers the Event Scheduler and is divided into the following sections: Section 23.4.1, “Event Scheduler Overview”, provides an introduction to and conceptual overview of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
Within a mysql client session, you can perform the import using the following SQL statements: SET ndb_use_transactions=0; SET foreign_key_checks=0; source path/to/dumpfile; SET ndb_use_transactions=1; SET foreign_key_checks=1; When performing the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-last-insert-id.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects (see Section 12.15, “Information Functions”). The ...For stored functions and triggers that change the value, the value is restored when the function or trigger ends, so following statements do not see a changed ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reset-to-default.html
Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure execution. row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND ...