Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
FORMAT_PICO_TIME(time_val) Given a numeric Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. Times under 1 nanosecond are represented as ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
If a TIMESTAMP or DATETIME column definition includes an explicit fractional seconds precision value anywhere, the same value must be used throughout the column definition. TIMESTAMP and DATETIME columns can be automatically initialized and updated ...An auto-updated column remains unchanged if all other columns are set to their current ...
A Quick Guide to Using the MySQL SLES Repository :: A Quick Guide to Using the MySQL SLES Repository
https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/index.html
For example, to enable the innovation track on SLES 15: $> sudo zypper modifyrepo -e mysql-innovation-community $> sudo zypper modifyrepo -e mysql-tools-innovation-community You should only enable a subrepository for one release series at any time.
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
This causes the Event Scheduler to stop the next time it tries to execute a scheduled event, after writing a message to the server error log. Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually ...When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The log_timestamps system variable controls the time zone of timestamps in messages written to the general query log file (as well as to the slow query log file and the error log). The general query log can be very useful when you suspect an error ... The general query log is a general record of what mysqld is ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-management-server-connections.html
ndb_mgm_set_connect_timeout() Description Sets the number of seconds for timeout of network operations; the default is 3 seconds. Signature int ndb_mgm_set_connect_timeout ( NdbMgmHandle handle, unsigned int seconds ) Parameters ... This section ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorprepared.html
import mysql.connector from mysql.connector.cursor import MySQLCursorPrepared cnx = mysql.connector.connect(database='employees') cursor = cnx.cursor(cursor_class=MySQLCursorPrepared) A cursor instantiated from the MySQLCursorPrepared class works ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorprepared.html
import mysql.connector from mysql.connector.cursor import MySQLCursorPrepared cnx = mysql.connector.connect(database='employees') cursor = cnx.cursor(cursor_class=MySQLCursorPrepared) A cursor instantiated from the MySQLCursorPrepared class works ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
Connection Volume Management To control the maximum number of clients the server permits to connect simultaneously, set the max_connections system variable at server startup or at runtime. It implements a thread pool that increases server ... This ...