Search Results
https://dev.mysql.com/doc/refman/8.4/en/do.html
For example, DO id FROM t1 is invalid because it references a table. In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
The log_error_verbosity system variable controls verbosity based on which priorities to permit for messages written to the log, as shown in the following table. The log_filter_internal log filter component implements a simple form of log filtering ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-event-buffer.html
There is one such buffer for each Ndb object subscribing to table events, which means that there are usually two buffers for each mysqld performing binary logging (one buffer for schema events, and one for data events). NDB uses one or more memory ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-start-phases.html
These start phases are also reported in the start_phase column of the ndbinfo.nodes table. NDB Cluster connections are set up, inter-block communications are established, and heartbeats are started. This section provides a simplified outline of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
rehash, \# Rebuild the completion hash that enables database, table, and column name completion while you are entering statements. mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
A set of quick-reference tables providing basic information about these options and variables is also included. The following sections contain information about mysqld options and server variables that are used in replication and for controlling ...
https://dev.mysql.com/doc/refman/8.4/en/scheduler-component.html
At startup, the scheduler component registers the performance_schema.component_scheduler_tasks table, which lists the currently scheduled tasks and some runtime data about each one. Note The scheduler component is included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
For the current user, the SELECT privilege for the mysql.user system table is required for display of the password hash in the IDENTIFIED AS clause; otherwise, the hash displays as <secret>. Password hash values displayed in the IDENTIFIED WITH ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-index-optimization.html
MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, and so forth). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...