Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-spin_lock_polling.html
On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or rw-lock becomes available during this period, the thread can continue ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. The number of seconds is the elapsed time between the current time and the last time InnoDB Monitor output was printed. This ... The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
MySQL Workbench represents each active data model as an icon in the models view of the home screen tab. Both models derive from MySQL database samples (see https://dev.mysql.com/doc/index-other.html), which you can download and use to explore the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-connection-linux.html
Select Microsoft SQL Server as the source database system and fill out the remaining options as described in this section. Figure 10.43 SQL Server Connection Parameters Example on Linux Source RDBMS connection parameters include: Database System: ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-jdbctemplate.html
Spring makes extensive use of the Template method design pattern (see Template Method Pattern). Our immediate focus will be on the JdbcTemplate and related classes, specifically NamedParameterJdbcTemplate. The template classes handle obtaining and ...
https://dev.mysql.com/doc/internals/en/writing-platform-checks.html
If you modify MySQL source and want to add a new platform check, please read http://www.vtk.org/Wiki/CMake_HowToDoPlatformChecks first. In MySQL, most of the platform tests are implemented in configure.cmake and the template header file, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-overview.html
This connector differs in a number of key respects from most other MySQL Connectors and APIs. In addition, it employs a domain object model for data storage. Applications retrieve data in the form of fully-instantiated objects, rather than as rows ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
A query that fails to parse differs from a query that parses but fails due to an error during execution. Consequently, there is no parsing at runtime and the type of each statement is known by the time it executes. For additional information about ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
(Bug #37602657) If the row size exceeded the maximum allowed size due to innodb_strict_mode=OFF, confusing warning messages similar to "Cannot add field" could appear in certain situations, such as selecting from a table or dropping a column. (Bug ... Audit Log Notes Compilation Notes SQL Function and Operator Notes InnoDB Notes Optimizer Notes Packaging Notes Performance Schema Notes Bugs Fixed Audit Log Notes Fixed an issue related to audit log ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For statements that can be determined at function definition time to return a ...By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine ...