Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-start-transaction.html
If the server is older than MySQL 5.6.5, it does not support setting the access mode and Connector/Python raises a ValueError. It accepts arguments indicating whether to use a consistent snapshot, which transaction isolation level to use, and the ...
https://dev.mysql.com/doc/internals/en/optimizer-code.html
The first part of mysql_select() is JOIN::prepare() which is for context analysis, metadata setup, and some subquery transformations. This diagram shows the structure of the function handle_select() in /sql/sql_select.cc (the server code that ...*/ ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
With --upgrade=NONE, the server upgrades nothing (skips steps 1 and 2), but also exits with an error if the data dictionary must be upgraded. If both versions indicate an upgrade is needed, the data dictionary upgrade must occur first. If the server ...System tables (that is, the remaining non-data dictionary tables), which are used for other operational ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-event-handling.html
The source code for this program may be found in the NDB Cluster source tree, in the file storage/ndb/ndbapi-examples/ndbapi_event/ndbapi_event.cpp. #include <NdbApi.hpp> // Used for cout #include <stdio.h> #include <iostream> #include <unistd.h> ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
There could be inconsistencies in both InnoDB and non-InnoDB data if any changes are made while those files are being backed up. Warning This option can cause an incomplete or inconsistent backup if, during the backup operation, DDL operations are ...--sleep=MS Command-Line Format --sleep=MS Type Numeric Default Value 0 Unit millisecond Specify the number in milliseconds to sleep after copying a certain amount of data from InnoDB ... These ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-prepared-statements.html
In case of not being possible to prepare new server-side prepared statements, it depends on the value of 'emulateUnsupportedPstmts' to whether return an error or fall back to client-side emulated prepared statements. Default Value true Since Version ...Default Value false Since Version 3.1.0 useStreamLengthsInPrepStmts Honor stream length parameter in 'PreparedStatement/ResultSet.set*Stream()' method calls? Default Value true Since Version ...
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
However, it is possible to place InnoDB data and log files on different physical disks. You can also set the parameters for the file system that the database uses: If you do not need to know when files were last accessed (which is not really useful ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...For ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-mysql-instances-permissions.html
Administer is also required by the Database File I/O, which requires the sys schema. MySQL Instances: grants access to the data collected on the monitored MySQL Instances. Possible values are: None: No access to MySQL Instances or the data collected ...That is, if Server Group is set to Read-Only, or higher, MySQL Instances must be set to Read-Only at ...
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-30.html
Log files now are managed with log4j2, which is configured using log4j2.xml rather than log4j.properties. In case of an upgrade, the old log4j.properties file is kept for reference. Functionality Added or Changed Bugs Fixed Functionality Added or ...Bugs Fixed MySQL Enterprise Service Manager has been updated to use Apache Log4J 2.17.1, which has been publicly reported as not vulnerable to ...
https://dev.mysql.com/doc/internals/en/zlib-directory.html
zlib is a data compression library used to support the compressed protocol and the COMPRESS/UNCOMPRESS functions under Windows. On Unix, MySQL uses the system libgz.a library for this purpose. Zlib is a variation of the famous "Lempel-Ziv" method, ...Zlib --- which presumably stands for "Zip Library" --- is not a MySQL ...