PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
Important You should not use --replicate-do-db for this purpose when using statement-based replication, since statement-based replication causes this option's effects to vary according to the database that is currently selected. However, it should ... There may be situations where you have a single source and want to replicate different databases to different ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. row *************************** Engine: MEMORY Support: YES Comment: Hash based, stored in memory, useful for temporary tables Transactions: NO XA: NO Savepoints: NO 10 rows in ...This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and ...ndbinfo is included with NDB Cluster support in the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
You can set the level of access control based on the Windows user (or users) running the client as follows: Minimum access to all users (RECOMMENDED). If the minimum-access option is too restrictive for the client software, use this option to reduce ...For first-time installations, the steps of the initial setup proceed directly into the steps of the ...Products ...
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html
On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE statements that create the database if it does exist and make it the default database for the reloaded data.
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
The binary log files provide you with the information you need to replicate changes to the database that are made subsequent to the point at which you performed a backup. Making Backups Using Replicas If you have performance problems with your ...
https://dev.mysql.com/doc/refman/5.7/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...You can reduce this overhead by increasing the number of entries permitted in the table ...
https://dev.mysql.com/doc/refman/5.7/en/permission-optimization.html
The more complex your privilege setup, the more overhead applies to all SQL statements. For example, if you do not grant any table-level or column-level privileges, the server need not ever check the contents of the tables_priv and columns_priv ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql database are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/5.7/en/sql-server-administration-statements.html
...