PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
Figure 19.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. The above ... As ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Figure 19.1 Using Replication to Improve Performance During ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary log. In a failover situation, all the ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
The binary log is saved in the MySQL database directory with the name hostname-bin.NNNNNN. FTP the tables and the binary log to our bugs database using the instructions given in Section 1.5, “How to Report Bugs or Problems”. For information ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
This gives anyone with access to the server unrestricted access to all databases. --skip-show-database Command-Line Format --skip-show-database System Variable skip_show_database Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html
It requires the EVENT privilege for the database from which the event is to be shown. Database Collation is the collation of the database with which the event is associated. SHOW CREATE EVENT event_name This statement displays the CREATE EVENT ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html
row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...
https://dev.mysql.com/doc/refman/8.0/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily ...The pattern is useful for restricting statement output to matching ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 17.6.1.2, “Creating Tables ...
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. (If you are the administrator, you need to consult the relevant portions of this manual, such as Chapter 7, ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...