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/option-defaults-equals.html
080112 12:53:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var $> After shutting down the server, restart it as follows: $> mysqld_safe --log-error & [1] 11699 $> 080112 12:53:40 mysqld_safe Logging to ...Due to this ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/refman/5.7/en/perl-support.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI, you must install the DBI module, as well as a DataBase Driver (DBD) module ...You can obtain the necessary modules from http://search.cpan.org for Unix, or by using the ActiveState ppm program on ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
For some distribution types (such as binary distributions on Windows, or RPM and DEB distributions on Linux), the installation process initializes the MySQL data directory, including the mysql system database containing the grant tables. (The data ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
Every database change (DDL or DML) that is written to the binary log is assigned a GTID. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
Figure 16.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/5.7/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/5.7/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/5.7/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/5.7/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_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Create Procedure: CREATE ... SHOW CREATE ...