From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <birukov@vladinfo.ru>
X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on sa.int.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-1.4 required=5.0 tests=AWL, BAYES_00, UPPERCASE_50_75
	autolearn=no version=3.2.4
Message-ID: <48A11320.2080703@vladinfo.ru>
Date: Tue, 12 Aug 2008 08:35:44 +0400
From: "Aleksey E. Birukov" <birukov@vladinfo.ru>
User-Agent: Thunderbird 2.0.0.6 (X11/20070804)
MIME-Version: 1.0
To: Sysadmins@lists.altlinux.org
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-AV-Checked: ClamAV
Subject: [Sysadmins] =?utf-8?b?bXlzcWw0IC0tPiBteXNxbDUuINCc0LXQtNC70LU=?=
 =?utf-8?b?0L3QvdCw0Y8g0LLRi9Cz0YDRg9C30LrQsCDQsdCw0LfRiy4=?=
X-BeenThere: sysadmins@lists.altlinux.org
X-Mailman-Version: 2.1.10b3
Precedence: list
Reply-To: ALT Linux sysadmin discuss <sysadmins@lists.altlinux.org>
List-Id: ALT Linux sysadmin discuss <sysadmins.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/listinfo/sysadmins>,
	<mailto:sysadmins-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/sysadmins>
List-Post: <mailto:sysadmins@lists.altlinux.org>
List-Help: <mailto:sysadmins-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/sysadmins>,
	<mailto:sysadmins-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Tue, 12 Aug 2008 04:35:53 -0000
Archived-At: <http://lore.altlinux.org/sysadmins/48A11320.2080703@vladinfo.ru/>
List-Archive: <http://lore.altlinux.org/sysadmins/>

Дамп, сделанный на mysql4 при загрузке его в mysql5 грузится в несколько 
раз дольше чем дамп, сделанный на mysql5 при загрузке его тоже в mysql5.

Разница там есть во всяких:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES cp1251 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

LOCK TABLES `lyra_blocks_shout` WRITE;
/*!40000 ALTER TABLE `lyra_blocks_shout` DISABLE KEYS */;

Как такое может быть?