mysql kresuje

[Jindra Fucik]

----- Original Message ----- 
From: "Martin Zdrazil" <zdrazil at atlas.cz>


> Dobry den panove,
>
> Zacalo se mi stavat ze na mem FreeBSD mi kresuje mysql a bohuzel nemohu
> zjistit proc. Dole je log co zapise mysql pri padu. Nemate nekdo nejakou
> radu, co se vlastne deje nebo jak to nejlepe zjistit ?
> Musim dodat, ze jsem na ten server uz drahnou dobu nic noveho neinstaloval

Zacel bych tim, ze bych si udelal checklist s tim, co pise v tom duvodu 
opusteni pameti, ale sel bych od konce.

1) mas dost pameti na to, aby si samo MySQL vzalo ctvrt giga a jeste zustalo 
na InnoDB?
2) mas v poradku hardware?
3) mas v poradku integritu dat? Inno to celkem ustoji, takze asi mas
4) pokus se kontaktovat autora

Jindra


> mysqld got signal 10;
> 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=101
> max_connections=100
> threads_connected=55
> 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.
>
> 060418 11:31:03  mysqld restarted
> 060418 11:31:03  InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the doublewrite
> InnoDB: buffer...
> 060418 11:31:03  InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 332873.
> InnoDB: Doing recovery: scanned up to log sequence number 0 332873
> InnoDB: Last MySQL binlog file position 0 0, file name
> 060418 11:31:03  InnoDB: Started; log sequence number 0 332873
> 060418 11:31:03 [Note] /usr/local/libexec/mysqld: ready for connections.
> Version: '5.0.16'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port:
> mysql-server-5.0.16
>
>
> -- 
> FreeBSD mailing list (users-l at freebsd.cz)
> http://www.freebsd.cz/listserv/listinfo/users-l