Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
The maximum permitted size of any one row is 30000 bytes. In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for ... Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Number of database ...
https://dev.mysql.com/doc/refman/8.4/en/replica-sql-thread-states.html
Monitoring tools that work with these instrumentation names might be impacted. This enables monitoring tools that rely on the old names to continue working until they can be updated to use the new names. Making temporary file (append) before ... The ...
https://dev.mysql.com/doc/internals/en/rnd-pos.html
This is like rnd_next, but you are given a position to use to determine the row. Usage Locate row based on position value and return in buffer provided. Synopsis virtual int rnd_pos ( buf, pos); byte * buf ; byte * pos ; Description This is the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
@output: output parameter that includes the list of tables and databases considered for generating the SQL query, Model ID of the Large Language Model (LLM) used for generating the query, the generated SQL query, and whether the generated SQL query ...The routine also runs the generated SQL statement and displays the result ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. This rules out, for example, a table column ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-check.html
It first checks all index entries for errors and then reads through all rows. It calculates a checksum for all key values in the rows and verifies that the checksum matches the checksum for the keys in the index tree. It does a check-read of every ... To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-diskpagebuffer.html
row *************************** node_id: 1 thr_no: 1 block_name: PGMAN thread_name: rep pages_written: 0 pages_written_lcp: 0 pages_read: 1 log_waits: 0 page_requests_direct_return: 4 page_requests_wait_queue: 0 page_requests_wait_io: 1 1 row in set ... The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-cluster.html
While the order in which the items are listed does not affect whether the create cluster command succeeds, we suggest that you follow this convention for readability, as well as compatibility with other MySQL NDB Cluster management tools such as ...
https://dev.mysql.com/doc/workbench/en/wb-mforms.html
The window will be sized automatically to fit its contents, but can also be sized statically. In the direction perpendicular to the layout, for example vertical in a horizontal layout, the smallest possible size that can accommodate all child ...