Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
rows (JSON name: rows) The rows column indicates the number of rows MySQL believes it must examine to execute the query. Scanned N databases (JSON property: message) This indicates how many directory scans the server performs when processing a query ...possible_keys (JSON name: possible_keys) The possible_keys column indicates the indexes from which MySQL can choose to find the rows in this ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-parameters.html
The same query written using a parameter for user input is: string sql = "SELECT Name, HeadOfState FROM Country WHERE Continent = @Continent"; Note The parameter is preceded by an '@' symbol to indicate it is to be treated as a parameter. Although ... This part of the tutorial shows you how to use parameters in your MySQL Connector/NET ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-parameters.html
The same query written using a parameter for user input is: string sql = "SELECT Name, HeadOfState FROM Country WHERE Continent = @Continent"; Note The parameter is preceded by an '@' symbol to indicate it is to be treated as a parameter. Although ... This part of the tutorial shows you how to use parameters in your MySQL Connector/NET ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Whether the item is available in the corresponding MySQL Server release series. A value of Varies indicates that the scope varies across versions. Dyn: Whether the ...Intr: The version or versions in which the item was ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisor-intro-thresholds-ref.html
The following thresholds, listed in order of severity, can be defined for most Advisors: Notice: issues which do not affect the performance of the server, but can be used to indicate minor configuration problems. Warning: issues which do not affect ...These are used to monitor such values as system uptime and, if the value for uptime drops below a certain value, indicating a restart, trigger an ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-monitoring.html
A number of lifecycle events that can indicate an issue if they occur frequently are logged as warning messages, including a member becoming unreachable and then reachable again, and a member starting distributed recovery by state transfer from the ... You can use the MySQL Performance Schema to monitor Group ...These Performance Schema tables display information specific to Group Replication: replication_group_member_stats: ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-events.html
Current Displays an icon indicating the current status of the event. Worst Displays an icon indicating the worst status of the event. Critical events indicate that a serious problem has occurred or is about to occur. Warning: The event is something ... Advisors generate events if one, or more, of the defined thresholds are crossed by the monitored ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-usage.html
To examine sys schema object definitions, use the appropriate SHOW statement or INFORMATION_SCHEMA query. For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW ...Most ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-linux.html
For information about making a Microsoft SQL Server connection using the MySQL Workbench migration wizard, see Section 10.5.3.2, “Linux”. Additionally, the FreeTDS version provided by distributions may also be compiled for the wrong ODBC library ...Many distributions ship older versions of FreeTDS, so it may need to be installed ...
https://dev.mysql.com/doc/internals/en/open.html
For instance when a request comes in for a select on the table (tables are not open and closed for each request, they are cached). The server opens all tables by calling ha_open() which then calls the handler specific open(). A handler object is ...