PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-visual-studio.html
A newer user interface for displaying query results, where different views are presented from result sets returned by a MySQL Server like: Multiple tabs for each result set returned by an executed query. Designed and developed as a Visual Studio ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. Additional Resources You may find the Stored Procedures User Forum of use when working with stored ...Stored ...A stored routine is a set of SQL statements that can be stored in the ...Once this has been done, clients don't need to keep ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. CURRENT_SCHEMA The default database for the statement, NULL if there is none. The table stores one row per thread showing the current status of ...Of the tables that contain statement event rows, events_statements_current is the most ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
This section describes mysql_old_password, which implements authentication against the mysql.user system table using the older (pre-4.1) native password hashing method. MySQL includes two plugins that implement native authentication; that is, ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
For example: mysql> SET GLOBAL keycache1.key_buffer_size=128*1024; To destroy a key cache, set its size to zero: mysql> SET GLOBAL keycache1.key_buffer_size=0; You cannot destroy the default key cache. Shared access to the key cache improves ...To ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ...row ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
As you gain experience using the daemon_memcached plugin, you can consider relaxing durability settings for non-critical classes of data, at the risk of losing some updated values in the event of an outage, or returning data that is slightly ...By ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
The OBJECT_TYPE column says USER LEVEL LOCK and the OBJECT_NAME column indicates the lock name. When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. A warning is logged if ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
The HANDLER interface is a more natural way to look at data when working with applications that provide an interactive user interface to the database. (See Section 14.21, “InnoDB memcached Plugin” for an alternative way to adapt applications ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
A value of 0 disables caching, which causes a thread to be set up for each new connection and disposed of when the connection terminates. To set a stack size of N bytes for each thread, start the server with thread_stack set to N. By granting the ...