Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
For example, if a DROP DATABASE statement follows a DROP USER of a distributed user, the drop of the database cannot take place until the drop of the user has completed on all SQL nodes. Privilege synchronization is the mechanism used by NDB ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance drops. Too much ... Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
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 MySQL Workbench modeling interface. Figure 9.1 Data Models on the Home Screen The sakila database sample ... MySQL Workbench represents each active data model as an icon in the models view of the home screen ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-jdbc-url-format.html
This is the generic format of the connection URL: protocol//[hosts][/database][?properties] The URL consists of the following parts: Important Any reserved characters for URLs (for example, /, :, @, (, ), [, ], &, #, =, ?, and space) that appear in ... This section explains the syntax of the URLs for connecting to ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-architecture.html
The DSN is a configuration string that identifies a given database driver, database, database host and optionally authentication information that enables an ODBC application to connect to a database using a standardized reference. Because the ...
https://dev.mysql.com/doc/connectors/en/connector-python-connectargs.html
A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...An asterisk (*) following an argument indicates a synonymous argument name, available only for compatibility with other Python MySQL ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-architecture.html
The DSN is a configuration string that identifies a given database driver, database, database host and optionally authentication information that enables an ODBC application to connect to a database using a standardized reference. Because the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...An asterisk (*) following an argument indicates a synonymous argument name, available only for compatibility with other Python MySQL ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-sessionfactory.html
Actual connections to the database are managed in a global connection pool, and may be shared by several session factories; each connection will be closed when the last session factory using it is closed. Since 7.5.7 4.3.1.23.7 getSession() public ...4.3.1.23.3 currentState() public abstract State currentState(); Get the current state of this session ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
It also enables you to review all alterations made to your database. It also enables you to review all alterations made to your database. Binary logging can be limited to specific databases with the --binlog-do-db and the --binlog-ignore-db options.