Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it contains. This chapter provides a tutorial introduction to MySQL by showing how to use the ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. The MySQL client/server protocol provides for the use of prepared statements. This ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-conversions.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. Prepared statements transmit data between the client and server using C language ...