Search Results
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
If you would like MySQL to start automatically, you can copy support-files/mysql.server to /etc/init.d and create a symbolic link to it named /etc/rc3.d/S99mysql.server. If too many processes try to connect very rapidly to mysqld, you should see ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
To enable recursion, set the max_sp_recursion_depth server system variable to a value greater than zero. If you increase the value of max_sp_recursion_depth, it may be necessary to increase thread stack size by increasing the value of thread_stack ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For MySQL Community Edition Server, MySQL Enterprise Edition Server (on-premise), and MySQL HeatWave Service without MySQL ...They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
In situations where clients connect to and disconnect from the server at a high rate, it is possible for all available ports to be used up before closed ports become available again. If this happens, the MySQL server appears to be unresponsive even ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction Managers. For “Internal XA”, storage engines within a MySQL server act as RMs, and the server itself acts as a TM. XA transaction support is ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-binary-log-interface.html
This capability uses the MYSQL_RPL data structure and a small set of functions to manage communication between a client program and the server from which the binary log is to be read. The MySQL client/server protocol includes a client interface for ...The following sections describe aspects of this interface in more ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-next-result.html
Its asynchronous counterpart is mysql_next_result_nonblocking(), for use by applications that require asynchronous communication with the server. If your program uses CALL statements to execute stored procedures, the CLIENT_MULTI_RESULTS flag must ... int mysql_next_result(MYSQL *mysql) Description Note mysql_next_result() is a synchronous ...
https://dev.mysql.com/doc/workbench/en/index.html
MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those later server versions. It documents the MySQL Workbench Community and MySQL Workbench Commercial releases for versions 8.0 ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mysql.html
Perform MySQL server version upgrades to move off older MySQL versions to the latest version. MySQL Schema Transfer Wizard The MySQL Schema Transfer wizard helps you move your data from an older MySQL server version to a different (typically later) ...The standard migration wizard can migrate MySQL to MySQL, and a simpler Schema Transfer Wizard can also be ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install.html
For example, PostgreSQL can be migrated with the psqlodbc ODBC driver; Microsoft SQL Server can be migrated using the native Microsoft SQL Server driver on Windows or with FreeTDS on Linux and macOS. The following figure shows the general components ... The MySQL Workbench Migration Wizard uses ODBC to connect to a source database, except for ...