Re: [Sysadmins] mysql копирование кусков

[Vladimir Karpinsky <vkarpinsky@mail.ru>]

01.03.2012 17:44, Anton Gorlov пишет:

В Солярисе:

> [mysqld]
> federated

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| Engine     | Support | Comment 
              | Transactions | XA  | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| InnoDB     | YES     | Supports transactions, row-level locking, and 
foreign keys     | YES          | YES | YES        |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables 
              | NO           | NO  | NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it 
disappears) | NO           | NO  | NO         |
| CSV        | YES     | CSV storage engine 
              | NO           | NO  | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary 
tables      | NO           | NO  | NO         |
| FEDERATED  | YES     | Federated MySQL storage engine 
              | NO           | NO  | NO         |
| ARCHIVE    | YES     | Archive storage engine 
              | NO           | NO  | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great 
performance         | NO           | NO  | NO         |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+

Если под Линухом не добавлять federated в my.cnf, то этого движка нет:

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment 
              | Transactions | XA   | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great 
performance         | NO           | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables 
              | NO           | NO   | NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it 
disappears) | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine 
              | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary 
tables      | NO           | NO   | NO         |
| InnoDB     | YES     | Supports transactions, row-level locking, and 
foreign keys     | YES          | YES  | YES        |
| ARCHIVE    | YES     | Archive storage engine 
              | NO           | NO   | NO         |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+

А если добавить, то при старте он ругается на unknown option '--federated' 
(см. предыдущее письмо). Отсюда напрашивается вывод, что собрано без...

# mysql -V
mysql  Ver 14.14 Distrib 5.1.56, for alt-linux-gnu (x86_64) using readline 5.2


-- 
	С уважением,
		Владимир.