Search Results
https://dev.mysql.com/doc/internals/en/select-special-engines.html
The normal engine can be replaced with such special engines only during the optimization process.
https://dev.mysql.com/doc/internals/en/sleep.html
Example: --connection conn1 LOCK TABLE t1 WRITE; --connection conn2 # This will block in wait_for_lock(). FLUSH TABLE t1; The BIG, BIG problem with 'sleep' is that you need to specify a fixed time. In some cases race conditions can be repeated when ...
https://dev.mysql.com/doc/internals/en/threads.html
Like the old "sync" daemon in unix, this thread occasionally flushes MyISAM tables to disk. Threads in mysqld can run at four different priorities, defined in mysql_priv.h: #define INTERRUPT_PRIOR 10 #define CONNECT_PRIOR 9 #define WAIT_PRIOR 8 ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
LOCK TABLE t1 IN SHARE MODE; --connection conn2 # Acquire the user level lock "mysqltest1". User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
Example: --connection conn1 LOCK TABLE t1 WRITE; --connection conn2 # Get the id of this thread. FLUSH TABLE t1; In conn2 we get the thread ID first. Like 'sleep', this method can also be used, when all but one thread reach a blocked state. If you ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-setup.html
The following table describes the files and folders that define MySQL Installer as a standalone application. Table 2.1 MySQL Installer Configuration Files File or Folder Description Folder Hierarchy MySQL Installer for Windows This folder contains ... Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files When you download MySQL Installer for the first time, a setup wizard guides you through the initial installation of MySQL ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-partitionkey.html
Annotation on a class or member to define the partition key. If annotating a class or interface, either a single column or multiple columns can be specified. If annotating a member, neither column nor columns should be specified.
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-projection.html
Annotation on a type to define it as a projection of a table. Only the columns mapped to persistent fields/methods will be used when performing operations on the table.
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-query-querydomaintype.html
Table 4.118 get(String) Parameter Description propertyName the name of the property return a representation the value of the property 4.3.3.5.3 getType() public abstract Class<E> getType(); Get the domain type of the query. Table 4.119 getType() ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-transaction.html
4.3.1.26.1 Synopsis public interface Transaction {// Public Methods public abstract void begin(); public abstract void commit(); public abstract boolean getRollbackOnly(); public abstract boolean isActive(); public abstract void rollback(); public ...