Search Results
https://dev.mysql.com/doc/refman/8.4/en/grant.html
CREATE TABLESPACE Enable tablespaces and log file groups to be created, altered, or dropped. To create or drop a trigger, you must have the TRIGGER privilege for the table, not the trigger. (GRANT does not create such rows when ...(Alternatively, if ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your table. If you start the MySQL server with external locking ...The output from these commands is explained later in this ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
Dictionary::createIndex() Description This method creates an index given an instance of Index and possibly an optional instance of Table. Signature This method can be invoked with or without a reference to a table object: int createIndex ( const ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...Note ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
To create an NdbInterpretedCode object, invoke the constructor, optionally supplying a table for the program to operate on, and a buffer for program storage and finalization. Description NdbInterpretedCode represents an interpreted program for use ... This section provides information about the NdbInterpretedCode class, which can be used to prepare and execute an NDB API interpreted ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. ALGORITHM=INPLACE can be used to perform online ADD ... MySQL NDB Cluster supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
I .ibd file Each InnoDB tablespace created using the file-per-table setting has a filename with a .ibd extension. .ibz file When the MySQL Enterprise Backup product performs a compressed backup, it transforms each tablespace file that is created ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, ...This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM (SELECT SUM(column1) AS sum_column1 FROM t1 GROUP BY column1) AS t1; Notice that the column name used within the subquery (sum_column1) is recognized in the outer ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
Previously, these tables were created in individual tablespace files in the mysql database directory. Note Like the mysql.func system table, the Performance Schema user_defined_functions table lists loadable functions installed using CREATE FUNCTION. This table is created only if the server is built with NDBCLUSTER ...It contains ...The server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
--replicate-do-table=db_name.tbl_name Command-Line Format --replicate-do-table=name Type String Creates a replication filter by telling the replication SQL thread to restrict replication to a given table. You can also create such a filter by issuing ...On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 ... This section explains the server options and system variables that apply to replica servers and contains the following: ...