From owner-freebsd-stable@FreeBSD.ORG Tue May 1 01:38:40 2007 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4C10D16A404 for ; Tue, 1 May 2007 01:38:40 +0000 (UTC) (envelope-from ken73.chen@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.251]) by mx1.freebsd.org (Postfix) with ESMTP id E9ADC13C459 for ; Tue, 1 May 2007 01:38:39 +0000 (UTC) (envelope-from ken73.chen@gmail.com) Received: by an-out-0708.google.com with SMTP id c24so1561935ana for ; Mon, 30 Apr 2007 18:38:39 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=JEWQV6e5aUWg03poi/ilZJnOuZ5vnW0R0d6GeUrKj4/oSHynbym+PcbGmRyXkK8+CB7w26GjNet5RjYkpsdCQ5bDUFU9MdNpSUNLmuoNMhh+Vk2RNUfeClS+O/c2q1GyGHYRZ7XEGuJZt1pC6F0QBrntNj5fnRdLMrMMMH2Fjls= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=k+9hwrHChQAzgJw2O+ZuYXMiWSHQGH4oaW33DbbK3GYcjPXlucj1mrbWGN9n6XkMizRBoeTHURdJ2wv8ELIeCE1zTSXkpw8Lpxanx1lY5sAw04QiggYUmp7Ohoxzr8ss50nyHGc7o7ad5/JEUIOxpR4E+rdVgpYzNGggMoNpXRY= Received: by 10.114.156.1 with SMTP id d1mr2187966wae.1177981888113; Mon, 30 Apr 2007 18:11:28 -0700 (PDT) Received: by 10.114.76.14 with HTTP; Mon, 30 Apr 2007 18:11:28 -0700 (PDT) Message-ID: Date: Tue, 1 May 2007 09:11:28 +0800 From: "Ken Chen" To: freebsd-stable@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: mysql frequently crash on 6.2 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 01 May 2007 01:38:40 -0000 After moving the database from Linux 2.4 to FreeBSD 6.2, the mysqld crash very frequently! I think the problem is on FreeBSD when myusql is heaving loading. I have another same machine with lower loading, the mysql is stable. ===== 8< ================ Version: '5.0.37-log' socket: '/tmp/mysql2.sock' port: 3307 MySQL Community Server (GPL) mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 max_used_connections=69 max_connections=130 threads_connected=53 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1191414 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. ===== 8< ================ db1# limits Resource limits (current): cputime infinity secs filesize infinity kB datasize 2621440 kB stacksize 524288 kB coredumpsize infinity kB memoryuse infinity kB memorylocked infinity kB maxprocesses 5547 openfiles 11095 sbsize infinity bytes vmemoryuse infinity kB db1# ===== 8< ================ The configuration in my.cnf: [mysqld2] port = 3307 socket = /tmp/mysql2.sock character-set-server = utf8 datadir = /db/data2 max_connections = 130 interactive_timeout = 20 nice=-15 thread_concurrency = 8 skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 400 sort_buffer_size = 4M read_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 32 query_cache_size= 64M join_buffer_size = 4M server-id = 233 log-bin = mysql-bin skip-bdb innodb_data_home_dir = /db/data2/ innodb_data_file_path = ibdata1:2G:autoextend innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 8M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M innodb_log_buffer_size = 6M ##innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 30 replicate-ignore-table=friend.SendVKiss replicate-wild-ignore-table=friend.fc_% replicate-wild-ignore-table=friend._search_result_% ===== 8< ================ Last, the FreeBSD boot message: Copyright (c) 1992-2007 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD is a registered trademark of The FreeBSD Foundation. FreeBSD 6.2-RELEASE #0: Thu Apr 26 15:13:29 CST 2007 root@db3.topfong.com:/usr/src/sys/i386/compile/db3 Timecounter "i8254" frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 2.80GHz (2791.78-MHz 686-class CPU) Origin = "GenuineIntel" Id = 0xf27 Stepping = 7 Features=0xbfebfbff real memory = 4160684032 (3967 MB) avail memory = 4078329856 (3889 MB) ACPI APIC Table: FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 6 ioapic0 irqs 0-23 on motherboard ioapic1 irqs 24-47 on motherboard ioapic2 irqs 48-71 on motherboard ioapic3 irqs 72-95 on motherboard ioapic4 irqs 96-119 on motherboard kbd1 at kbdmux0 acpi0: on motherboard acpi0: Power Button (fixed) Timecounter "ACPI-fast" frequency 3579545 Hz quality 1000 acpi_timer0: <24-bit timer at 3.579545MHz> port 0x408-0x40b on acpi0 cpu0: on acpi0 acpi_throttle0: on cpu0 cpu1: on acpi0