>
> > > >Description:
> > > Maybe it's HW problem, maybe OS, but maybe MySQL... I
don't know why
> but
> > > MySQL crashin on signal 11 about 2 times a day. the last
core-dump is
> here:
> > > free.xprojekt.cz/mysql/mysql.core. thank you for help.
> > >
> > > >How-To-Repeat:
> > > Sometimes, about two times per day.
> > > >Fix:
> > > You should know it :-)
> >
> > Can you re-compile mysql --with-debug and then backtrace the
core dump.
> Also
> > enable logging and try to catch the query that causes the core
dump. Try
> to
> > create a fully-functional .sql file so that mysql test <
file.sql would
> always
> > cause a core dump if possible.
> Loging is enable. It crashes on any query, and if i try the same
query
> again, it works. It's not on query :-(
> But if i recompile mysql with-debug, compilation crash :-( But
these
> problems i have from 3.23 versions. Never before...
>
> BTW: i tried: 3.23.1, 3.23.3, 3.23.4, 3.23.5, 3.23.8, 3.23.10,
3.23.11...
> the same :-( downgrade to 3.22 is hard, because i'm using new
function and
> MyISAM...
Hi Martin,
Did you try "--low-priority-updates" option? In my case, the option
solved the problem.
Shutdown MySQL, run myisamchk -r, and run MySQL with
low-priority-updates. myisamchk 3.23.11 has a bug, so use 3.23.10.
Good luck!
Masayuki
http://www.teglet.co.jp
