Skip site navigation (1)Skip section navigation (2)
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>