Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-threads-table.html
row *************************** NAME: thread/performance_schema/setup ENABLED: YES HISTORY: YES PROPERTIES: singleton VOLATILITY: 0 DOCUMENTATION: NULL ... row *************************** NAME: thread/sql/main ENABLED: YES HISTORY: YES PROPERTIES: ...It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci SHOW CREATE TABLE displays ... SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named ...
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
Not all storage engines update this time, in which case, the value is always NULL. For views, most columns displayed by SHOW TABLE STATUS are 0 or NULL except that Name indicates the view name, Create_time indicates the creation time, and Comment ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
If all arguments are NULL or the aggregate result is empty, the return value is NULL. The result is the narrowest MultiXxx or GeometryCollection value possible, with the result type determined from the non-NULL geometry arguments as follows: If all ... MySQL supports aggregate functions that perform a calculation on a set of ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
See that section for descriptions of these functions: ST_Envelope(g) ST_StartPoint(ls) ST_EndPoint(ls) ST_PointN(ls, N) ST_ExteriorRing(poly) ST_InteriorRingN(poly, N) ST_GeometryN(gc, N) Unless otherwise specified, functions in this section handle ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
While a NULL itself does not require any storage space, NDB reserves 4 bytes per row if the table definition contains any columns allowing NULL, up to 32 NULL columns. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type ...
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-descriptions.html
In the descriptions here, a parameter or return value of NULL means NULL in the sense of the C programming language, not a MySQL NULL value. Unless specified otherwise, functions returning a pointer return a non-NULL value to indicate success or a ... This section describes C API functions other than those used for prepared statements, the asynchronous interface, or the replication stream ...