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
--
С уважением,
Владимир.
_______________________________________________
Sysadmins mailing list
[email protected]
https://lists.altlinux.org/mailman/listinfo/sysadmins
