From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-1.5 required=5.0 tests=AWL,BAYES_00,SPF_PASS autolearn=ham version=3.2.5 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru; s=mail; h=Content-Transfer-Encoding:Content-Type:In-Reply-To:References:Subject:To:MIME-Version:From:Date:Message-ID; bh=oZCx+0L8y1PNJ8iQlf/tM83TjIOlANCvK2V4XPd+hW0=; b=tzwKXP0hWxC/bYnzHY6nBZU7q2+EiLfiihwHZqOKR5aelD2Nq6xbLIN3bYz6ZQxUihi/OEvHsamGuQ2nwn9yoQ9RlK6QOETVWL1fGg4/OwHlgIqyEJeatzu7qEXqUUPm; Message-ID: <4F4F973C.4060705@mail.ru> Date: Thu, 01 Mar 2012 19:35:24 +0400 From: Vladimir Karpinsky User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: sysadmins@lists.altlinux.org References: <4F4F1556.8050805@mail.ru> <4F4F1988.7090800@altlinux.ru> <4F4F2019.4060204@mail.ru> <4F4F2BF5.6070208@altlinux.ru> <4F4F382C.6030001@mail.ru> <4F4F5699.10506@altlinux.ru> <4F4F7C3B.8000206@mail.ru> <4F4F7D54.5080401@altlinux.ru> In-Reply-To: <4F4F7D54.5080401@altlinux.ru> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 8bit X-Antivirus: avast! (VPS 120301-0, 01.03.2012), Outbound message X-Antivirus-Status: Clean X-Spam: Not detected X-Mras: Ok Subject: Re: [Sysadmins] =?koi8-r?b?bXlzcWwgy8/QydLP18HOycUgy9XTy8/X?= X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.12 Precedence: list Reply-To: ALT Linux sysadmins' discussion List-Id: ALT Linux sysadmins' discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 Mar 2012 15:35:30 -0000 Archived-At: List-Archive: 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 -- С уважением, Владимир.