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/partitioning-limitations-storage-engines.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. If a ... The ...Partitioned InnoDB tables cannot have foreign key references, nor can they have columns referenced by foreign ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
To signal a generic SQLSTATE value, use '45000', which means “unhandled user-defined exception.” The SIGNAL statement optionally includes a SET clause that contains multiple signal items, in a list of condition_information_item_name = ...SIGNAL ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
Note The procedure shown here does not set up any passwords for MySQL accounts. Then perform the following steps as the mysql user, except as noted. Create the directory and go there: $> mkdir bld $> cd bld Configure the build directory. To do this, ... To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
Note InnoDB does not open all user tables and associated data files at startup. InnoDB is a transaction-safe (ACID compliant) storage engine with commit, rollback, and crash-recovery capabilities to protect user data. With regard to InnoDB recovery ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
USER The default user name on Windows when connecting to mysqld. MYSQL_TEST_LOGIN_FILE is the path name of the login path file (the file created by mysql_config_editor). The UMASK and UMASK_DIR variables, despite their names, are used as modes, not ... This section lists environment variables that are used directly or indirectly by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
(Many Linux and other operating system distributions provide their own packages for this library.) A MySQL user account having the necessary privileges. If you do not wish to use an existing account, then creating one using GRANT USAGE ON ...A MySQL ... This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
Such problems can occur if you neglected to create the grant tables by initializing the data directory before proceeding to this step, or if you ran the command that initializes the data directory without the --user option. Start the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. Some conflict resolution functions (NDB$OLD(), NDB$EPOCH(), NDB$EPOCH_TRANS()) require ...The ndb_binlog_index and ndb_apply_status tables are created in the mysql ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
Users can create, modify, and drop scheduled events using SQL statements intended for these purposes. The default definer of an event is the user who created the event, unless the event has been altered, in which case the definer is the user who ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos | RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos | SQL_AFTER_MTS_GAPS } ...