Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/internals/en/transaction-overview.html
Transactions are not explicitly started on the storage engine level, but are instead implicitly started through calls to either start_stmt() or external_lock(). If the preceding methods are called and a transaction already exists the transaction is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-database-processes.html
Important This report retrieves data from the processlist view of the sys schema. If the sys schema, version 1.5.1 or higher, is not installed on the monitored MySQL server, the report is not populated. Table 3.1 Database Processes Dashboard Name ...
https://dev.mysql.com/doc/internals/en/running-mysql-test-run-out-of-source.html
When building out of source (see Section 4.4.1, “Create the Build Directory”), use mysql-test-run.pl in the mysql-test directory under the build directory. It is a wrapper script that calls mysql-test-run.pl in the source directory and tells it ...
https://dev.mysql.com/doc/internals/en/transformations-all-any.html
ALL/ANY/SOME use the same algorithm (and the same method of Item_in_subselect) as scalar IN, but use a different function instead of =. ANY/SOME use the same function that was listed after the left expression. ALL uses an inverted function, and all ...
https://dev.mysql.com/doc/internals/en/listing-configuration-options.html
After the initial configuration step completes, you can examine the configuration options. -LH Long form (lists lots of options, including internal and advanced ones): cmake . -LA If you have cmake-gui installed, you can do this to see or change ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
You can load data into a MySQL HeatWave Cluster by using the Auto Parallel Load feature. Auto Parallel Load, which can be run manually from any MySQL client or connector, is implemented as a stored procedure named heatwave_load, which resides in ...
https://dev.mysql.com/doc/internals/en/transactions-notes-on-ddl-and-normal-transaction.html
DDL statements and operations with nontransactional engines do not "register" in thd->transaction lists, and thus do not modify the transaction state. Besides, each DDL statement in MySQL begins with an implicit normal transaction commit (a call to ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-statements.html
The Statements dashboard displays information on the various types of statement executed on the monitored server. Table 5.7 Statements Performance Page Regions GraphDescriptionDML Statements Graphs the number and type of DML statements. The ...
https://dev.mysql.com/doc/workbench/en/wb-mac-uninstalling.html
To uninstall MySQL Workbench for macOS, locate MySQL Workbench in the Applications folder, right-click, and select Move to Trash. What Is Not Removed By default, uninstalling MySQL Workbench does not remove your Workbench configuration directory.