Introduced in MySQL 5.0, federated tables allow access to the tables located on other databases on other servers.
1 Comment
Those are the special tables, data for which is saved into comma-separated values files. They cannot be indexed.
MySQL config variable max_heap_table_size.
HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.
net start MySQL, net stop MySQL
mysqli is the object-oriented version of mysql library functions.
tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command notee.
Yes, and name it ~/.my.conf. You might want to change the permissions on the file to 600, so that it’s not readable by others.
|