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/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. For full instructions to configure and start sources and replicas using GTID-based ...When ...To start a replica using GTID-based replication, you do not include MASTER_LOG_FILE or MASTER_LOG_POS options in the CHANGE MASTER TO statement used to direct the replica to replicate from a given ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates a table format file in the database directory. In such a case, it is possible to set up on the source host a “dummy” replica process whose default storage engine is BLACKHOLE, depicted as ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. (See also Bug #16522.) Each execution of the statements contained in the body of an event takes place in a new connection; thus, these statements have ...The restrictions for stored procedures also apply to the DO clause of Event Scheduler event ...Some of the restrictions ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. If slave_parallel_type is set to DATABASE (rather than ... On a ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. Bugs posted in the bugs database at http://bugs.mysql.com/ that are corrected for a given release are noted in the release notes. To ...We ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. The permitted qualifiers for object ...This statement creates a table using the qualified name db1.t1: CREATE TABLE db1.t1 (i INT); Because db1.t1 includes a database qualifier db1, the statement creates t1 in the database named db1, regardless of the default ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached.html
Instead of formulating queries in SQL, you can use simple get, set, and incr operations that avoid the performance overhead associated with SQL parsing and constructing a query optimization plan. You can also access the same InnoDB tables through ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Batch mode can also be useful while you are developing a query, particularly for multiple-line statements or ...
https://dev.mysql.com/doc/refman/5.7/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ...For example, you might try a setting like this: C:\> set HTTP_proxy=my.proxy.com:3128 Start the PPM program: C:\> C:\perl\bin\ppm.pl If you have not previously done so, install DBI: ppm> install DBI If this succeeds, run the following command: ppm> install DBD-mysql This procedure should work with ActiveState Perl 5.6 or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
When an application or authenticated user wants to access encrypted data, InnoDB uses a master encryption key to decrypt the tablespace key. mysql> ALTER TABLE t1 ENCRYPTION='Y'; To disable encryption for file-per-table tablespace, set ...The ...