Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
The asynchronous C API functions cover operations that might otherwise block when reading to or writing from the server connection: The initial connection operation, sending a query, reading the result, and so forth. Asynchronous Function Calling ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
For the RETURNED_SQLSTATE, MESSAGE_TEXT, and MYSQL_ERRNO values for particular errors, see Server Error Message Reference. SQL statements clear and set the diagnostics area as follows: When the server starts executing a statement after parsing it, ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
Text in this style indicates the names of executable programs and scripts, examples being mysql (the MySQL command-line client program) and mysqld (the MySQL server executable). Example: “The --host option (short form -h) tells the mysql client ...
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
Most MySQL programs that support option files handle the following options. On Windows, if the server is started with the --defaults-file and --install options, --install must be first. Exceptions: Even with --defaults-file, mysqld reads ...Because ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
Both caches store table definitions but serve different parts of the MySQL server. The stored_program_definition_cache option sets a limit for the number of stored program definition objects that can be stored in the dictionary object cache. The ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. The file can be read later by MySQL client programs to obtain authentication credentials ...The methods you can use to specify your password when you run client programs are listed here, along with an assessment of the risks of each ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. It can also generate result sets to be returned to the client program. Event: An object created with CREATE EVENT ...Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
This program illustrates how to use secondary indexes in the NDB API with the aid of the NdbRecord interface. * In this program, the same row offsets are used for columns * specified as part of a key, and as part of an attribute or * result. The ...
https://dev.mysql.com/doc/refman/8.4/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...The effect of this default is: d: Enable output for all debug macros t: Trace function calls and exits i: Add PID to output lines o,/tmp/mysqld.trace, O,\mysqld.trace: Set the debug output ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
To enable the launchd service, you can either: Open macOS system preferences and select the MySQL preference panel, and then execute Start MySQL Server. Uninstall uninstalls MySQL Server and optionally the MySQL preference panel and launchd ...