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
------=_Part_33088_30899750.1202134745559 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline > > > > 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 ------=_Part_33088_30899750.1202134745559 Content-Type: application/octet-stream; name=PE2950 Content-Transfer-Encoding: base64 X-Attachment-Id: f_fc93vgit0 Content-Disposition: attachment; filename=PE2950 IwojIEdFTkVSSUMgLS0gR2VuZXJpYyBrZXJuZWwgY29uZmlndXJhdGlvbiBmaWxlIGZvciBGcmVl QlNEL2FtZDY0CiMKIyBGb3IgbW9yZSBpbmZvcm1hdGlvbiBvbiB0aGlzIGZpbGUsIHBsZWFzZSBy ZWFkIHRoZSBoYW5kYm9vayBzZWN0aW9uIG9uCiMgS2VybmVsIENvbmZpZ3VyYXRpb24gRmlsZXM6 CiMKIyAgICBodHRwOi8vd3d3LkZyZWVCU0Qub3JnL2RvYy9lbl9VUy5JU084ODU5LTEvYm9va3Mv aGFuZGJvb2sva2VybmVsY29uZmlnLWNvbmZpZy5odG1sCiMKIyBUaGUgaGFuZGJvb2sgaXMgYWxz byBhdmFpbGFibGUgbG9jYWxseSBpbiAvdXNyL3NoYXJlL2RvYy9oYW5kYm9vawojIGlmIHlvdSd2 ZSBpbnN0YWxsZWQgdGhlIGRvYyBkaXN0cmlidXRpb24sIG90aGVyd2lzZSBhbHdheXMgc2VlIHRo ZQojIEZyZWVCU0QgV29ybGQgV2lkZSBXZWIgc2VydmVyIChodHRwOi8vd3d3LkZyZWVCU0Qub3Jn LykgZm9yIHRoZQojIGxhdGVzdCBpbmZvcm1hdGlvbi4KIwojIEFuIGV4aGF1c3RpdmUgbGlzdCBv ZiBvcHRpb25zIGFuZCBtb3JlIGRldGFpbGVkIGV4cGxhbmF0aW9ucyBvZiB0aGUKIyBkZXZpY2Ug bGluZXMgaXMgYWxzbyBwcmVzZW50IGluIHRoZSAuLi8uLi9jb25mL05PVEVTIGFuZCBOT1RFUyBm aWxlcy4KIyBJZiB5b3UgYXJlIGluIGRvdWJ0IGFzIHRvIHRoZSBwdXJwb3NlIG9yIG5lY2Vzc2l0 eSBvZiBhIGxpbmUsIGNoZWNrIGZpcnN0CiMgaW4gTk9URVMuCiMKIyAkRnJlZUJTRDogc3JjL3N5 cy9hbWQ2NC9jb25mL0dFTkVSSUMsdiAxLjQzOS4yLjcgMjAwNS8xMC8yOCAxOToyMToyNyBqaGIg RXhwICQKCm1hY2hpbmUJCWFtZDY0CmNwdQkJSEFNTUVSCmlkZW50CQlQRTI5NTAKCiMgVG8gc3Rh dGljYWxseSBjb21waWxlIGluIGRldmljZSB3aXJpbmcgaW5zdGVhZCBvZiAvYm9vdC9kZXZpY2Uu aGludHMKI2hpbnRzCQkiR0VORVJJQy5oaW50cyIJCSMgRGVmYXVsdCBwbGFjZXMgdG8gbG9vayBm b3IgZGV2aWNlcy4KCm1ha2VvcHRpb25zCURFQlVHPS1nCQkjIEJ1aWxkIGtlcm5lbCB3aXRoIGdk YigxKSBkZWJ1ZyBzeW1ib2xzCgojb3B0aW9ucyAJU0NIRURfVUxFCQkjIFVMRSBzY2hlZHVsZXIK b3B0aW9ucyAJU0NIRURfNEJTRAkJIyA0QlNEIHNjaGVkdWxlcgpvcHRpb25zIAlQUkVFTVBUSU9O CQkjIEVuYWJsZSBrZXJuZWwgdGhyZWFkIHByZWVtcHRpb24Kb3B0aW9ucyAJSU5FVAkJCSMgSW50 ZXJORVR3b3JraW5nCiNvcHRpb25zIAlJTkVUNgkJCSMgSVB2NiBjb21tdW5pY2F0aW9ucyBwcm90 b2NvbHMKb3B0aW9ucyAJRkZTCQkJIyBCZXJrZWxleSBGYXN0IEZpbGVzeXN0ZW0Kb3B0aW9ucyAJ U09GVFVQREFURVMJCSMgRW5hYmxlIEZGUyBzb2Z0IHVwZGF0ZXMgc3VwcG9ydApvcHRpb25zIAlV RlNfQUNMCQkJIyBTdXBwb3J0IGZvciBhY2Nlc3MgY29udHJvbCBsaXN0cwpvcHRpb25zIAlVRlNf RElSSEFTSAkJIyBJbXByb3ZlIHBlcmZvcm1hbmNlIG9uIGJpZyBkaXJlY3RvcmllcwpvcHRpb25z IAlNRF9ST09UCQkJIyBNRCBpcyBhIHBvdGVudGlhbCByb290IGRldmljZQpvcHRpb25zIAlORlND TElFTlQJCSMgTmV0d29yayBGaWxlc3lzdGVtIENsaWVudApvcHRpb25zIAlORlNTRVJWRVIJCSMg TmV0d29yayBGaWxlc3lzdGVtIFNlcnZlcgpvcHRpb25zIAlORlNfUk9PVAkJIyBORlMgdXNhYmxl IGFzIC8sIHJlcXVpcmVzIE5GU0NMSUVOVApvcHRpb25zIAlOVEZTCQkJIyBOVCBGaWxlIFN5c3Rl bQpvcHRpb25zIAlNU0RPU0ZTCQkJIyBNU0RPUyBGaWxlc3lzdGVtCm9wdGlvbnMgCUNEOTY2MAkJ CSMgSVNPIDk2NjAgRmlsZXN5c3RlbQpvcHRpb25zIAlQUk9DRlMJCQkjIFByb2Nlc3MgZmlsZXN5 c3RlbSAocmVxdWlyZXMgUFNFVURPRlMpCm9wdGlvbnMgCVBTRVVET0ZTCQkjIFBzZXVkby1maWxl c3lzdGVtIGZyYW1ld29yawpvcHRpb25zIAlHRU9NX0dQVAkJIyBHVUlEIFBhcnRpdGlvbiBUYWJs ZXMuCm9wdGlvbnMgICAgIEdFT01fTEFCRUwKb3B0aW9ucyAJQ09NUEFUXzQzCQkjIE5lZWRlZCBi eSBDT01QQVRfTElOVVgzMgpvcHRpb25zIAlDT01QQVRfSUEzMgkJIyBDb21wYXRpYmxlIHdpdGgg aTM4NiBiaW5hcmllcwpvcHRpb25zIAlDT01QQVRfRlJFRUJTRDQJCSMgQ29tcGF0aWJsZSB3aXRo IEZyZWVCU0Q0Cm9wdGlvbnMgCUNPTVBBVF9GUkVFQlNENQkJIyBDb21wYXRpYmxlIHdpdGggRnJl ZUJTRDUKb3B0aW9ucyAJQ09NUEFUX0xJTlVYMzIJCSMgQ29tcGF0aWJsZSB3aXRoIGkzODYgbGlu dXggYmluYXJpZXMgCm9wdGlvbnMgCVNDU0lfREVMQVk9NTAwMAkJIyBEZWxheSAoaW4gbXMpIGJl Zm9yZSBwcm9iaW5nIFNDU0kKb3B0aW9ucyAJS1RSQUNFCQkJIyBrdHJhY2UoMSkgc3VwcG9ydApv cHRpb25zIAlTWVNWU0hNCQkJIyBTWVNWLXN0eWxlIHNoYXJlZCBtZW1vcnkKb3B0aW9ucyAJU1lT Vk1TRwkJCSMgU1lTVi1zdHlsZSBtZXNzYWdlIHF1ZXVlcwpvcHRpb25zIAlTWVNWU0VNCQkJIyBT WVNWLXN0eWxlIHNlbWFwaG9yZXMKb3B0aW9ucyAJX0tQT1NJWF9QUklPUklUWV9TQ0hFRFVMSU5H ICMgUE9TSVggUDEwMDNfMUIgcmVhbC10aW1lIGV4dGVuc2lvbnMKb3B0aW9ucyAJS0JEX0lOU1RB TExfQ0RFVgkjIGluc3RhbGwgYSBDREVWIGVudHJ5IGluIC9kZXYKb3B0aW9ucyAJQUhDX1JFR19Q UkVUVFlfUFJJTlQJIyBQcmludCByZWdpc3RlciBiaXRmaWVsZHMgaW4gZGVidWcKCQkJCQkjIG91 dHB1dC4gIEFkZHMgfjEyOGsgdG8gZHJpdmVyLgpvcHRpb25zIAlBSERfUkVHX1BSRVRUWV9QUklO VAkjIFByaW50IHJlZ2lzdGVyIGJpdGZpZWxkcyBpbiBkZWJ1ZwoJCQkJCSMgb3V0cHV0LiAgQWRk cyB+MjE1ayB0byBkcml2ZXIuCm9wdGlvbnMgCUFEQVBUSVZFX0dJQU5UCQkjIEdpYW50IG11dGV4 IGlzIGFkYXB0aXZlLgpvcHRpb25zICAgICBTTVAKCgojb3B0aW9ucyAgICAgSU5WQVJJQU5UUyAK I29wdGlvbnMgICAgIElOVkFSSUFOVF9TVVBQT1JUCgojb3B0aW9ucyAgICAgS0RCCiNvcHRpb25z ICAgICBEREIKI29wdGlvbnMgICAgIEtEQl9VTkFUVEVOREVECiNvcHRpb25zICAgICBCUkVBS19U T19ERUJVR0dFUgoKCiMgV29ya2Fyb3VuZHMgZm9yIHNvbWUga25vd24tdG8tYmUtYnJva2VuIGNo aXBzZXRzIChuVmlkaWEgbkZvcmNlMy1Qcm8xNTApCmRldmljZQkJYXRwaWMJCQkjIDgyNTlBIGNv bXBhdGFiaWxpdHkKCiMgTGludXggMzItYml0IEFCSSBzdXBwb3J0Cm9wdGlvbnMgCUxJTlBST0NG UwkJIyBDYW5ub3QgYmUgYSBtb2R1bGUgeWV0LgoKIyBCdXMgc3VwcG9ydC4KZGV2aWNlCQlhY3Bp CmRldmljZQkJcGNpCgojIEZsb3BweSBkcml2ZXMKZGV2aWNlCQlmZGMKCiMgQVRBIGFuZCBBVEFQ SSBkZXZpY2VzCmRldmljZQkJYXRhCmRldmljZQkJYXRhZGlzawkJIyBBVEEgZGlzayBkcml2ZXMK ZGV2aWNlCQlhdGFwaWNkCQkjIEFUQVBJIENEUk9NIGRyaXZlcwpkZXZpY2UJCWF0YXBpZmQJCSMg QVRBUEkgZmxvcHB5IGRyaXZlcwpvcHRpb25zIAlBVEFfU1RBVElDX0lECSMgU3RhdGljIGRldmlj ZSBudW1iZXJpbmcKCiMgU0NTSSBDb250cm9sbGVycwpkZXZpY2UJCW1wdAkJIyBMU0ktTG9naWMg TVBULUZ1c2lvbgoKIyBTQ1NJIHBlcmlwaGVyYWxzCmRldmljZQkJc2NidXMJCSMgU0NTSSBidXMg KHJlcXVpcmVkIGZvciBTQ1NJKQpkZXZpY2UJCWNoCQkjIFNDU0kgbWVkaWEgY2hhbmdlcnMKZGV2 aWNlCQlkYQkJIyBEaXJlY3QgQWNjZXNzIChkaXNrcykKZGV2aWNlCQlzYQkJIyBTZXF1ZW50aWFs IEFjY2VzcyAodGFwZSBldGMpCmRldmljZQkJY2QJCSMgQ0QKZGV2aWNlCQlwYXNzCQkjIFBhc3N0 aHJvdWdoIGRldmljZSAoZGlyZWN0IFNDU0kgYWNjZXNzKQpkZXZpY2UJCXNlcwkJIyBTQ1NJIEVu dmlyb25tZW50YWwgU2VydmljZXMgKGFuZCBTQUYtVEUpCgojIFJBSUQgY29udHJvbGxlcnMKZGV2 aWNlICAgICAgbWZpCgojIGF0a2JkYzAgY29udHJvbHMgYm90aCB0aGUga2V5Ym9hcmQgYW5kIHRo ZSBQUy8yIG1vdXNlCmRldmljZQkJYXRrYmRjCQkjIEFUIGtleWJvYXJkIGNvbnRyb2xsZXIKZGV2 aWNlCQlhdGtiZAkJIyBBVCBrZXlib2FyZApkZXZpY2UJCXBzbQkJIyBQUy8yIG1vdXNlCmRldmlj ZSAgICAgIGtiZG11eAoKZGV2aWNlCQl2Z2EJCSMgVkdBIHZpZGVvIGNhcmQgZHJpdmVyCgpkZXZp Y2UJCXNwbGFzaAkJIyBTcGxhc2ggc2NyZWVuIGFuZCBzY3JlZW4gc2F2ZXIgc3VwcG9ydAoKIyBz eXNjb25zIGlzIHRoZSBkZWZhdWx0IGNvbnNvbGUgZHJpdmVyLCByZXNlbWJsaW5nIGFuIFNDTyBj b25zb2xlCmRldmljZQkJc2MKCmRldmljZQkJYWdwCQkjIHN1cHBvcnQgc2V2ZXJhbCBBR1AgY2hp cHNldHMKCgpkZXZpY2UJCXNpbwkJIyA4MjUwLCAxNls0NV01MCBiYXNlZCBzZXJpYWwgcG9ydHMK CgpkZXZpY2UJCW1paWJ1cwkJIyBNSUkgYnVzIHN1cHBvcnQKZGV2aWNlICAgICAgYmNlCgpkZXZp Y2UJCWxvb3AJCSMgTmV0d29yayBsb29wYmFjawpkZXZpY2UJCXJhbmRvbQkJIyBFbnRyb3B5IGRl dmljZQpkZXZpY2UJCWV0aGVyCQkjIEV0aGVybmV0IHN1cHBvcnQKZGV2aWNlCQl0dW4JCSMgUGFj a2V0IHR1bm5lbC4KZGV2aWNlCQlwdHkJCSMgUHNldWRvLXR0eXMgKHRlbG5ldCBldGMpCmRldmlj ZQkJbWQJCSMgTWVtb3J5ICJkaXNrcyIKZGV2aWNlCQlnaWYJCSMgSVB2NiBhbmQgSVB2NCB0dW5u ZWxpbmcKI2RldmljZQkJZmFpdGgJCSMgSVB2Ni10by1JUHY0IHJlbGF5aW5nICh0cmFuc2xhdGlv bikKCmRldmljZQkJYnBmCQkjIEJlcmtlbGV5IHBhY2tldCBmaWx0ZXIKCmRldmljZQkJdWhjaQkJ IyBVSENJIFBDSS0+VVNCIGludGVyZmFjZQpkZXZpY2UJCW9oY2kJCSMgT0hDSSBQQ0ktPlVTQiBp bnRlcmZhY2UKZGV2aWNlCQllaGNpCQkjIEVIQ0kgUENJLT5VU0IgaW50ZXJmYWNlIChVU0IgMi4w KQpkZXZpY2UJCXVzYgkJIyBVU0IgQnVzIChyZXF1aXJlZCkKZGV2aWNlCQl1Z2VuCQkjIEdlbmVy aWMKZGV2aWNlCQl1aGlkCQkjICJIdW1hbiBJbnRlcmZhY2UgRGV2aWNlcyIKZGV2aWNlCQl1a2Jk CQkjIEtleWJvYXJkCmRldmljZQkJdW1zCQkjIE1vdXNlCgpkZXZpY2UgICAgICAgICAgY2FycApk ZXZpY2UgICAgICBwZgpkZXZpY2UgICAgICBwZmxvZwpkZXZpY2UgICAgICBwZnN5bmMKCm9wdGlv bnMgRkFTVF9JUFNFQwpkZXZpY2UgY3J5cHRvCgoKZGV2aWNlICAgICAgICAgIGNhcnAKZGV2aWNl ICAgICAgcGYKZGV2aWNlICAgICAgcGZsb2cKZGV2aWNlICAgICAgcGZzeW5jCgpvcHRpb25zICAg ICAgICAgQUxUUQpvcHRpb25zICAgICAgICAgQUxUUV9DQlEgICAgICAgICMgQ2xhc3MgQmFzZXMg UXVldWluZyAoQ0JRKQpvcHRpb25zICAgICAgICAgQUxUUV9SRUQgICAgICAgICMgUmFuZG9tIEVh cmx5IERldGVjdGlvbiAoUkVEKQpvcHRpb25zICAgICAgICAgQUxUUV9SSU8gICAgICAgICMgUkVE IEluL091dApvcHRpb25zICAgICAgICAgQUxUUV9IRlNDICAgICAgICMgSGllcmFyY2hpY2FsIFBh Y2tldCBTY2hlZHVsZXIgKEhGU0MpCm9wdGlvbnMgICAgICAgICBBTFRRX1BSSVEgICAgICAgIyBQ cmlvcml0eSBRdWV1aW5nIChQUklRKQpvcHRpb25zICAgICAgICAgQUxUUV9OT1BDQyAgICAgICMg UmVxdWlyZWQgZm9yIFNNUCBidWlsZAoK ------=_Part_33088_30899750.1202134745559--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?55b8c6fe0802040619m8728e68kbe408ee4a94e591a>