From: Pavel Stoliarov <mylinux02@mail.ru> To: community@lists.altlinux.org Subject: [Comm] Падает MySQL Date: Thu, 06 Jul 2006 16:31:19 +0500 Message-ID: <44ACF487.70309@mail.ru> (raw) Система Compact 3.0 Иногда MySQL падает : Version: '5.0.22' socket: '/mysql.sock' port: 3306 ALT Linux MySQL RPM 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=8388600 read_buffer_size=131072 max_used_connections=53 max_connections=100 threads_connected=35 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0xb53a5290 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... frame pointer (ebp) is NULL, did you compile with -fomit-frame-pointer? Aborting backtrace! Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xb3d134b8 is invalid pointer thd->thread_id=2075 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 2006-Jul-06 00:50:13 :: execution failed 2006-Jul-06 00:50:13 :: shutdown Советы , приведеные в вышеуказаной ссылке по тестированию и оптимизации базы итд, к успеху не привели. Может быть mysql 5.0.x еще сыровата ? Есть смысл откатиться на 4.1.x ? ---------- С уважением Столяров Павел
next reply other threads:[~2006-07-06 11:31 UTC|newest] Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top 2006-07-06 11:31 Pavel Stoliarov [this message] 2006-07-07 6:15 ` Alexey S. Kuznetsov 2006-07-07 9:04 ` Pavel Stoliarov
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=44ACF487.70309@mail.ru \ --to=mylinux02@mail.ru \ --cc=community@lists.altlinux.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux Community general discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 community community/ http://lore.altlinux.org/community \ mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com public-inbox-index community Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.community AGPL code for this site: git clone https://public-inbox.org/public-inbox.git