PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the source table on the source and the replicated table on the replica use different engine ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
If slave_parallel_type is set to DATABASE (rather than LOGICAL_CLOCK), this value is always zero. On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Today, MySQL Server and many other modern database systems offer a wide range of outer join types. Sometimes there are other ways to test membership in a set of values than by using a subquery. Also, on some occasions, it is not only possible to ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being modified. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate ...
https://dev.mysql.com/doc/refman/5.7/en/server-administration.html
MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation.
https://dev.mysql.com/doc/refman/5.7/en/server-loadable-functions.html
MySQL Enterprise Edition includes a firewall capability that implements an application-level firewall to enable database administrators to permit or deny SQL statement execution based on matching against patterns for accepted statement. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
See Section 13.7.6.3, “FLUSH Statement”, Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”, and Section 4.5.4, “mysqldump — A Database Backup Program”. MySQL Server has several logs that can help you find out what ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
MySQL Enterprise Edition includes a firewall plugin that implements an application-level firewall to enable database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
The following characteristics are relevant for this purpose: READ ONLY READ WRITE ISOLATION LEVEL WITH CONSISTENT SNAPSHOT Available Session State Trackers To support the session-tracking activities, notification is available for these types of ...A ...