Date: Mon, 4 Feb 2008 14:19:05 +0000 From: "Primeroz lists" <primeroz.lists@googlemail.com> To: "Jeremy Chadwick" <koitsu@freebsd.org> Cc: freebsd-stable@freebsd.org Subject: Re: Crashing repeatedly: 6.2-RELEASE-p5 and MySQL 5.0.41 Message-ID: <55b8c6fe0802040619m8728e68kbe408ee4a94e591a@mail.gmail.com> In-Reply-To: <20080204133832.GA6950@eos.sc1.parodius.com> References: <55b8c6fe0802040450r7ca3e739s931be2d38f499fc2@mail.gmail.com> <20080204133832.GA6950@eos.sc1.parodius.com>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] > > > > There's additional information needed to help with this: > > 1) Contents of /boot/loader.conf empty > > 2) What scheduler you're using in your kernel configuration We using the 4bsd Scheduler (ULE is commented out in kernel conf) > 3) Your kernel configuration in its entirity, if possible :-) attached > > 4) What options you compiled/built mysql50-server with As from Tinderbox log: configure: running /bin/sh './configure' --prefix=/usr/local '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-5.0.41' '--enable-thread-safe-client' '--with-named-thread-libs=-pthread' '--prefix=/usr/local' '--build=amd64-portbld-freebsd6.2' 'CC=cc' 'CFLAGS=-O2 -fno-strict-aliasing -pipe ' 'CXXFLAGS=-O2 -fno-strict-aliasing -pipe -O2 -fno-strict-aliasing -pipe -felide-constructors -fno-rtti -fno-exceptions' 'CXX=c++' 'build_alias=amd64-portbld-freebsd6.2' CFLAGS=' -DDBUG_OFF -O2 -fno-strict-aliasing -pipe ' CXXFLAGS=' -DDBUG_OFF -O2 -fno-strict-aliasing -pipe -O2 -fno-strict-aliasing -pipe -felide-constructors -fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=1000000' --cache-file=/dev/null --srcdir=. This is taken from loader.conf on our production SQL server running > RELENG_6, i386, with 2GB RAM: > > > # Increase maximum allocatable memory on a process to 1536MB. > # We don't choose 2GB (our amount of RAM) since that would > # exhaust all memory, and result in a kernel panic. Maximum > # stack size is still set to 128MB. > # > # dfldsiz = Initial data size limit (bytes) > # maxdsiz = Maximum data size limit (bytes) > # dflssiz = Initial stack size limit (bytes) > # maxssiz = Maximum stack size limit (bytes) > # > kern.maxdsiz="1536M" > kern.dfldsiz="1536M" > kern.maxssiz="128M" > I did not setup anything in the /boot/loader.conf so i guess i'm using default values for all of those settings, > Some other comments: > > > Finally, I will take a moment to urge you to upgrade that box to > RELENG_7. SCHED_ULE was re-written and specifically tested with mysqld > in mind, and are quite impressive. The fact you're using a pair of quad > core CPUs would be reason enough to upgrade. RELENG_6 will soon be on > its way out the door, so it's an inevitable upgrade anyways. > Yes, configuration need fixing especially about InnoDB that is not configured/tuned at all. The one that take my attention more then others options is: set-variable = innodb_buffer_pool_size=512M I'm sure i need to increase that value, i'm using the default that surely is not giving me the expected resaults ... but i wonder if that can lead to such a crash and not just a performance problem as i read on some sources on internet about mysql optimization. We are thinking about an OS Upgrade but what i would really like is to understand what in mysql is triggering this crash before upgrading to new OS/Mysql and maybe mask the problem for long time. thanks for your help. Francesco Ciocchetti [-- Attachment #2 --] # # GENERIC -- Generic kernel configuration file for FreeBSD/amd64 # # For more information on this file, please read the handbook section on # Kernel Configuration Files: # # http://www.FreeBSD.org/doc/en_US.ISO8859-1/books/handbook/kernelconfig-config.html # # The handbook is also available locally in /usr/share/doc/handbook # if you've installed the doc distribution, otherwise always see the # FreeBSD World Wide Web server (http://www.FreeBSD.org/) for the # latest information. # # An exhaustive list of options and more detailed explanations of the # device lines is also present in the ../../conf/NOTES and NOTES files. # If you are in doubt as to the purpose or necessity of a line, check first # in NOTES. # # $FreeBSD: src/sys/amd64/conf/GENERIC,v 1.439.2.7 2005/10/28 19:21:27 jhb Exp $ machine amd64 cpu HAMMER ident PE2950 # To statically compile in device wiring instead of /boot/device.hints #hints "GENERIC.hints" # Default places to look for devices. makeoptions DEBUG=-g # Build kernel with gdb(1) debug symbols #options SCHED_ULE # ULE scheduler options SCHED_4BSD # 4BSD scheduler options PREEMPTION # Enable kernel thread preemption options INET # InterNETworking #options INET6 # IPv6 communications protocols options FFS # Berkeley Fast Filesystem options SOFTUPDATES # Enable FFS soft updates support options UFS_ACL # Support for access control lists options UFS_DIRHASH # Improve performance on big directories options MD_ROOT # MD is a potential root device options NFSCLIENT # Network Filesystem Client options NFSSERVER # Network Filesystem Server options NFS_ROOT # NFS usable as /, requires NFSCLIENT options NTFS # NT File System options MSDOSFS # MSDOS Filesystem options CD9660 # ISO 9660 Filesystem options PROCFS # Process filesystem (requires PSEUDOFS) options PSEUDOFS # Pseudo-filesystem framework options GEOM_GPT # GUID Partition Tables. options GEOM_LABEL options COMPAT_43 # Needed by COMPAT_LINUX32 options COMPAT_IA32 # Compatible with i386 binaries options COMPAT_FREEBSD4 # Compatible with FreeBSD4 options COMPAT_FREEBSD5 # Compatible with FreeBSD5 options COMPAT_LINUX32 # Compatible with i386 linux binaries options SCSI_DELAY=5000 # Delay (in ms) before probing SCSI options KTRACE # ktrace(1) support options SYSVSHM # SYSV-style shared memory options SYSVMSG # SYSV-style message queues options SYSVSEM # SYSV-style semaphores options _KPOSIX_PRIORITY_SCHEDULING # POSIX P1003_1B real-time extensions options KBD_INSTALL_CDEV # install a CDEV entry in /dev options AHC_REG_PRETTY_PRINT # Print register bitfields in debug # output. Adds ~128k to driver. options AHD_REG_PRETTY_PRINT # Print register bitfields in debug # output. Adds ~215k to driver. options ADAPTIVE_GIANT # Giant mutex is adaptive. options SMP #options INVARIANTS #options INVARIANT_SUPPORT #options KDB #options DDB #options KDB_UNATTENDED #options BREAK_TO_DEBUGGER # Workarounds for some known-to-be-broken chipsets (nVidia nForce3-Pro150) device atpic # 8259A compatability # Linux 32-bit ABI support options LINPROCFS # Cannot be a module yet. # Bus support. device acpi device pci # Floppy drives device fdc # ATA and ATAPI devices device ata device atadisk # ATA disk drives device atapicd # ATAPI CDROM drives device atapifd # ATAPI floppy drives options ATA_STATIC_ID # Static device numbering # SCSI Controllers device mpt # LSI-Logic MPT-Fusion # SCSI peripherals device scbus # SCSI bus (required for SCSI) device ch # SCSI media changers device da # Direct Access (disks) device sa # Sequential Access (tape etc) device cd # CD device pass # Passthrough device (direct SCSI access) device ses # SCSI Environmental Services (and SAF-TE) # RAID controllers device mfi # atkbdc0 controls both the keyboard and the PS/2 mouse device atkbdc # AT keyboard controller device atkbd # AT keyboard device psm # PS/2 mouse device kbdmux device vga # VGA video card driver device splash # Splash screen and screen saver support # syscons is the default console driver, resembling an SCO console device sc device agp # support several AGP chipsets device sio # 8250, 16[45]50 based serial ports device miibus # MII bus support device bce device loop # Network loopback device random # Entropy device device ether # Ethernet support device tun # Packet tunnel. device pty # Pseudo-ttys (telnet etc) device md # Memory "disks" device gif # IPv6 and IPv4 tunneling #device faith # IPv6-to-IPv4 relaying (translation) device bpf # Berkeley packet filter device uhci # UHCI PCI->USB interface device ohci # OHCI PCI->USB interface device ehci # EHCI PCI->USB interface (USB 2.0) device usb # USB Bus (required) device ugen # Generic device uhid # "Human Interface Devices" device ukbd # Keyboard device ums # Mouse device carp device pf device pflog device pfsync options FAST_IPSEC device crypto device carp device pf device pflog device pfsync options ALTQ options ALTQ_CBQ # Class Bases Queuing (CBQ) options ALTQ_RED # Random Early Detection (RED) options ALTQ_RIO # RED In/Out options ALTQ_HFSC # Hierarchical Packet Scheduler (HFSC) options ALTQ_PRIQ # Priority Queuing (PRIQ) options ALTQ_NOPCC # Required for SMP build
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?55b8c6fe0802040619m8728e68kbe408ee4a94e591a>