Where exactly SHOULD these be and is it something I need to enable in my.cnf
the generic /var/log/mysqld.log has this each time the process dies: Number of processes running now: 0 040203 22:21:08 mysqld restarted Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html /usr/libexec/mysqld: ready for connections libgcc_s.so.1 must be installed for pthread_cancel to work until I enabled skip-innodb and now i get : Number of processes running now: 0 040204 14:31:18 mysqld restarted /usr/libexec/mysqld: ready for connections libgcc_s.so.1 must be installed for pthread_cancel to work libgcc_s.so.1 is in /lib as a symlink: [EMAIL PROTECTED] lib]# ls -al libgcc_s* -rwxr-xr-x 1 root root 30324 Feb 25 2003 libgcc_s-3.2.2-20030225.so.1 lrwxrwxrwx 1 root root 28 Jul 25 2003 libgcc_s.so.1 -> libgcc_s-3.2.2-20030225.so.1 On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote: > Have you looked in the hostname.err logs for the MySQL server? > > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > On 2/4/04, 2:00:53 PM, Daniel Powell <[EMAIL PROTECTED]> wrote > regarding Mysql ECHILD resets on Queries: > > > > Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update > > from APT seems to have destroyed mysql somehow. > > > Mysql Version is 3.23.58-1.9 > > > Any query kills the child process of mysqld and it has to respawn. This > > does not seem to be the proper behaviour and it is causing many issues > for > > the php scripts that talk to mysql. > > > php is version 4.3.3-2 apache is 2.0.47-6 > > > i cant even get a dump of the databases because of the respawning child > > process. Ive been searching google and the arcives here for the last 24 > > hours and I've found nothing of the like.. > > > an strace of the safe_mysqld shows this. > > I'm at my witts end here. any insight or way to get a better dump of what > > is really killing it? > > > > --- SIGCHLD (Child exited) @ 0 (0) --- > > waitpid(-1, 0xbfffef24, WNOHANG) = -1 ECHILD (No child processes) > > sigreturn() = ? (mask now []) > > rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 > > pipe([3, 4]) = 0 > > rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0 > > clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11, > > <ignored>, <ignored>, 0x4015c0c8) = 2134 > > rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0 > > close(4) = 0 > > close(4) = -1 EBADF (Bad file descriptor) > > rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0 > > clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11, > > <ignored>, <ignored>, 0x4015c0c8) = 2136 > > rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0 > > close(3) = 0 > > rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0 > > rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0 > > rt_sigaction(SIGINT, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, {SIG_IGN}, > > 8) = 0 > > waitpid(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], 0) = 2134 > > waitpid(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], 0) = 2136 > > rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0 > > rt_sigaction(SIGINT, {SIG_IGN}, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, > > 8) = 0 > > close(3) = -1 EBADF (Bad file descriptor) > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > --- SIGCHLD (Child exited) @ 0 (0) --- > > waitpid(-1, 0xbffff1e4, WNOHANG) = -1 ECHILD (No child processes) > > sigreturn() = ? (mask now []) > > rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > stat64("/bin/rm", {st_mode=S_IFREG|0755, st_size=26780, ...}) = 0 > > access("/bin/rm", X_OK) = 0 > > rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0 > > clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11, > > <ignored>, <ignored>, 0x4015c0c8) = 2137 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > --- SIGCHLD (Child exited) @ 0 (0) --- > > waitpid(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], WNOHANG) = 2137 > > waitpid(-1, 0xbfffef64, WNOHANG) = -1 ECHILD (No child processes) > > sigreturn() = ? (mask now []) > > rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 > > rt_sigaction(SIGINT, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, {SIG_IGN}, > > 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > rt_sigaction(SIGINT, {SIG_IGN}, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, > > 8) = 0 > > rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > stat64("/usr/bin/nohup", {st_mode=S_IFREG|0755, st_size=2129, ...}) = 0 > > access("/usr/bin/nohup", X_OK) = 0 > > rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0 > > clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11, > > <ignored>, <ignored>, 0x4015c0c8) = 2138 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 > > rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 > > rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 > > rt_sigaction(SIGINT, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, {SIG_IGN}, > > 8) = 0 > > waitpid(-1, <unfinished ...> > > > > > -- > > ================================================================= > > Daniel Powell A+ [EMAIL PROTECTED] > > Networkgeek MCP http://networkgeek.org > > ================================================================= > > And Trogdor smote the Kerrek, and all was laid to Burnination. > > ================================================================= > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- ================================================================= Daniel Powell A+ [EMAIL PROTECTED] Networkgeek MCP http://networkgeek.org ================================================================= And Trogdor smote the Kerrek, and all was laid to Burnination. ================================================================= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]