Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the amount of overhead on the database server. This section describes the performance considerations for backing up a ...When measuring backup performance, consider: The limits imposed by your backup ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
The second example shows how you can retrieve the same value using a standard SELECT LAST_INSERT_ID() query. The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method.
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-entity-framework-winform-data-source.html
You can also find details on how to install the database on the same page. As the next figure shows, you are then presented with a tree structure of the database. Adding a New Data Source You will now add a new Data Source to your project and see ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-entity-framework-winform-data-source.html
You can also find details on how to install the database on the same page. As the next figure shows, you are then presented with a tree structure of the database. Adding a New Data Source You will now add a new Data Source to your project and see ...
https://dev.mysql.com/doc/internals/en/mysql-test-directory.html
The directory has a README file which explains how to run the tests, how to make new tests (in files with the filename extension *.test), and how to report errors. Primarily these are SQL scripts which try out a feature, output a result, and compare ...
https://dev.mysql.com/doc/internals/en/cmake-howto-quick.html
This section briefly describes how to build MySQL in a release or debug configuration. It also describes how to build using the same options as used for MySQL official releases. For more details about the build process, see Section 4.4, “Detailed ...The following discussion assumes that your initial current working directory is the top-level MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
Table creation and drop operations for any storage engine modify data dictionary tables in the mysql system database, but those tables use the InnoDB storage engine and cannot be modified when innodb_read_only is enabled. Section 17.8.1, “InnoDB ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
Data definition language (DDL) statements that define or modify database objects. CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
We could calculate tomorrow by calling a database function, but for clarity we do it in Python using the datetime module. Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage ...