Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-handleractivity-category.html
If this value is high, it is a good indication that your tables are properly indexed for your queries. This value is high if you are doing a lot of queries that require sorting of the result. Lists the Handler Activity metrics and provides a brief ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-to-a-single-mysqld-node-setup.html
In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its password. string usr = prompt("Username:"); string pwd = prompt("Password:"); ...You are prompted to enter the user name and password in this ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
The following table shows a comparison between each DBMS product supported by the Migration Wizard and MySQL. Table 10.1 Conceptual equivalents between supported DBMS products and MySQL Concept MS SQL Server Sybase ASE PostgreSQL MySQL Note ...
https://dev.mysql.com/doc/internals/en/error-messages-old-versions.html
In practice, no new error messages should be added to error message files for versions of MySQL prior to 5.0.3. Before MySQL 5.0.3, error messages are stored in errmsg.txt files in the language directories under sql/share. For each new error ...
https://dev.mysql.com/doc/internals/en/debug-sync-facility.html
MySQL supports a Debug Sync Facility, which - in spite of the "debug" in its name - is completely independent from the DBUG facility (except that it uses DBUG to trace its operation, if DBUG is also configured in the server). The documentation here ...When the signal thread notifies the wait thread, the signal name is copied into global list and the wait thread is signalled to wake up and proceed with further ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-java.html
A NDB Cluster is defined as one or more MySQL Servers providing access to an NDBCLUSTER storage engine—that is, to a set of NDB Cluster data nodes (ndbd processes). There are three main access paths from Java to NDBCLUSTER, listed here: JDBC and ...Unlike JDBC, JPA provides an object view of the data in the ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
Basic information about the join buffer cache: The size of each join buffer is determined by the value of the join_buffer_size system variable. This buffer is used only when the join is of type ALL or index (in other words, when no possible keys ...
https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
00 2b 79 44 26 2f 5a 5a 33 30 35 5a 47 00 6d 79 .+yD&/ZZ305ZG.my 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 sql_native_passw 6f 72 64 00 ord Note The auth-plugin-data is the concatenation of strings auth-plugin-data-part-1 and ...
https://dev.mysql.com/doc/internals/en/error-injection.html
This means each of them will never execute twice within one SQL statement. Note: The ERROR_INJECT framework has been removed in an early 6.0 version. The error injection method is based on the DBUG framework just like the Dbug Sleep method. In the ...
https://dev.mysql.com/doc/workbench/en/wb-model-reporting.html
Note This functionality is only available in the MySQL Workbench Commercial Editions. The DBDoc - Model Reporting dialog is found by opening a model, selecting Model from the menu, and then DBDoc - Model Reporting. Use the DBDoc- Model Reporting ...