MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 301 to 310 of 320 total results

https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html

The result is georeferenced: Each point maps to a place on the globe. A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial reference systems: A projected SRS ...

Chapter 18 Alternative Storage Engines

https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html

row *************************** Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO XA: NO Savepoints: NO *************************** 2. row *************************** Engine: InnoDB Support: DEFAULT Comment: ...

27.8 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html

Prepared statement scope is the current session, not the stored program, so the statement could be executed after the program ends, at which point the variables would no longer be in scope. Some of the restrictions noted here apply to all stored ...

27.7 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html

These events bring databases up to date from the point of the backup. The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications.

15.2.15 Subqueries

https://dev.mysql.com/doc/refman/8.0/en/subqueries.html

All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...

2.9.3 Testing the Server

https://dev.mysql.com/doc/refman/8.0/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 ...

7.6.3.4 Thread Pool Tuning

https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html

You may need to adjust the value from this starting point to suit a given workload; a reasonable upper bound for this value is the maximum number of concurrent connections expected; the value of the Max_used_connections status variable can serve as ... This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per ...

13.2.3 The TIME Type

https://dev.mysql.com/doc/refman/8.0/en/time.html

The only delimiter recognized between a time part and a fractional seconds part is the decimal point. By default, values that lie outside the TIME range but are otherwise valid are clipped to the closest endpoint of the range. MySQL retrieves and ...

3.5 Changes in MySQL 8.0

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

Nearly all production installations have the binary log enabled as it is used for replication and point-in-time recovery. Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/en/user-variables.html

User variables can be assigned a value from a limited set of data types: integer, decimal, floating-point, binary or nonbinary string, or NULL value. You can store a value in a user-defined variable in one statement and refer to it later in another ...

Displaying 301 to 310 of 320 total results