Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The restart_info table contains the following columns: node_id Node ID ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-performanceschema-category.html
Digests Size The maximum number of rows in the events_statements_summary_by_digest table. Max Digest Length The maximum number of bytes available for computing statement digests. Max Digest Sample Age The query resample age (in seconds) for the ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Server version 8.0.19-commercial Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 11 min 7 sec Threads: 3 Questions: 8 Slow queries: 0 Opens: 146 Flush tables: 3 Open tables: 63 Queries per second avg: ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ...After any port is closed, it remains in a TIME_WAIT status for 120 ...The error (2003) Can't connect to MySQL server ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-blobs-ndbrecord.html
*/ if (-1 == myBlobHandle->setPos(pos)) APIERROR(myBlobHandle->getNdbError()); if (-1 == myBlobHandle->readData(buffer, chunk_length)) APIERROR(myBlobHandle->getNdbError()); int res= myTrans->execute(NdbTransaction::NoCommit); if (-1 == res) ...*/ ... This example illustrates the manipulation of a blob column in the NDB API using the NdbRecord ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Flush Log At Timeout Write and flush the logs every N seconds. Io Capacity The maximum number of I/O operations per second that InnoDB will perform. Lock Wait Timeout The timeout in seconds an InnoDB transaction may wait for a row lock before giving ...Buffer Pool Load At Startup Enabled Specifies that, on MySQL server startup, the InnoDB buffer pool is automatically warmed up by loading the same pages it held at an earlier ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/monitoring-support-advisors-ref.html
To display these graphs, set the target selectors to Global Summaries, select MEM Service Manager from the All Targets menu, and select Timeseries Graphs from the Metrics menu. Checks the timestamps of data collected by the agent to ensure the time ...HTTP Server Performance Service Manager Health Support Diagnostics Unsupported Agent Version Advisor HTTP Server Performance Provides instruments for data that exposes the performance of an HTTP ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
This is stored as seconds: days*24*3600+hours*3600+minutes*60+seconds Example: a TIME column containing '1 02:03:04' (1 day 2 hour 3 minutes and 4 seconds) looks like: hexadecimal 58 6E 01 TIMESTAMP Storage: 4 bytes, low byte first. Stored as unix ...(If they don't fit, that's an error in strict mode.) Trailing spaces are not significant in comparisons ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. The following table lists each built-in (native) function and operator and provides a short description of each one. ->> Return value ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-user-accounts.html
A global automatic password expiration policy is defined using the default_password_lifetime system variable. To have passwords automatically expire after a specified number of days, add an entry similar to this under the [mysqld] option group in ...