PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Then you can answer different sorts of questions about your animals by retrieving data from the tables. A menagerie distribution containing some of the ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are reading from the table. After finding the data, most modern disks can read the ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
System Variable server_uuid Scope Global Dynamic No SET_VAR Hint Applies No Type String When starting, the MySQL server automatically obtains a UUID as follows: Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir ...For servers that are used in a replication topology, you must specify a unique server ID for each replication server, in the range from 1 to 232 − ...Options and variables ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
When CMake starts, it looks for that file and reads its contents if it exists, on the assumption that the information is still correct. However, you may want to remove old object files from previous builds first because they were compiled using ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
Example: INSTALL COMPONENT 'file://component1', 'file://component2'; A component is named using a URN that begins with file:// and indicates the base name of the library file that implements the component, located in the directory named by the ...A ...[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...Beginning with MySQL 8.0.30, information about generated invisible primary keys is visible by default in all INFORMATION_SCHEMA tables describing table columns, keys, or both, such as the COLUMNS and STATISTICS ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or contains a * or ** wildcard. An error occurs if the json_doc argument is not a valid JSON document or any path argument is ... The functions in this section modify JSON values and return the ...Synonym for JSON_MERGE_PRESERVE(); ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. The Event Scheduler writes information about event execution that terminates with an error or warning ...See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an ...For ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file name suffix differs per platform (for example, .so for Unix and Unix-like systems, ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
pattern_database The database used to match unqualified table names in statements. Qualified table names in statements match qualified names in the pattern if corresponding database and table names are identical. Unqualified table names in ...Users ...This column may be useful if you are trying to determine why some statement fails to be ...