Search Results
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
The PAGE_FREE pointer in the page header points to the first record in the list. The "next" pointer in the record header (specifically, in the record's Extra Bytes) points to the next record in the list. PAGE_DIRECTION and PAGE_N_DIRECTION: It's ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-wait-connected: Time (in seconds) for MySQL server to wait for connection to cluster management and data nodes before accepting MySQL client connections. ndb-wait-setup: Time (in seconds) for MySQL server to wait for NDB engine setup to complete. Ndb_api_wait_exec_complete_count: Number of times thread has been blocked while waiting for operation execution to complete by this MySQL Server (SQL ... The ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-wait-connected: Time (in seconds) for MySQL server to wait for connection to cluster management and data nodes before accepting MySQL client connections. ndb-wait-setup: Time (in seconds) for MySQL server to wait for NDB engine setup to complete. Ndb_api_wait_exec_complete_count: Number of times thread has been blocked while waiting for operation execution to complete by this MySQL Server (SQL ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
import asyncio import os import time from mysql.connector.aio import connect # Global variable which will help to format the job sequence output. global indent indent = 0 # MySQL Connection arguments config = { "host": "127.0.0.1", "user": "root", ... Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating asynchronous MySQL interactions with an ...
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
import asyncio import os import time from mysql.connector.aio import connect # Global variable which will help to format the job sequence output. global indent indent = 0 # MySQL Connection arguments config = { "host": "127.0.0.1", "user": "root", ... Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating asynchronous MySQL interactions with an ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
timeout: An integer specifying a timeout in seconds for transactions that are running on the existing primary when you use the function. You can set a timeout from 0 seconds (immediately) up to 3600 seconds (60 minutes). The current primary becomes ... The following function enables you to set a member of a single-primary replication group to take over as the ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-cluster-log.html
A severity level is stored at position ndb_mgm_clusterlog_level; for example the error level is stored at position NDB_MGM_EVENT_SEVERITY_ERROR. Return value The number of returned severities, or -1 in the event of an error. Return value This ...
https://dev.mysql.com/doc/workbench/en/wb-performance-reports.html
Statements in Highest 5 percent by Runtime – Lists all statements in which the average runtime (in microseconds) is in the highest five percent. Note that for instances with a large number of objects, this report may require extended time to ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete rs.Open "SELECT * FROM my_ado" rs.MoveNext rs.MoveNext rs.Delete rs.Close 'fetch the updated table .. The following ADO (ActiveX Data ...
https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html
First approach to solving the problem: For each salesperson, calculate the maximum sale size, and also find the customer who provided this maximum. A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM ...