Date: Mon, 11 Mar 2002 22:22:09 +0100 From: "Bob Kersten" <bob@fellownet.org> To: <freebsd-stable@freebsd.org> Subject: crontab and mysql Message-ID: <001e01c1c942$d5f25ea0$0200000a@alpha>
next in thread | raw e-mail | index | archive | help
Hi,
I've got two simple questions, at least, I hope they're simpel :-)
My Crontab file seems to be corrupt. I keep on getting e-mail
messages for user root with the line "root: not found" in it. And it
does this with all the entries in the /etc/crontab file. It's the
crontab file for the user root (/etc/crontab). I've edited this file
and installed it with "crontab crontab" while logged in as root. As of
that point, all entries (even the ones i didn't alter) don't work
anymore. I've included my crontab file at the bottom of this message,
but I don't think you'll find errors in there. There must be something
else wrong, but what?
Second question, my MySQL is extremely slow. I'm running FreeBSD
4.5-Stable on a Pentium-90Mhz with 64 mb ram, so that ought to be
enough, i would think. But when the database grows (like 300 entries
with text) it takes a few seconds for my PHP pages to load. I've seen
MySQL running amazingly fast on a machine far less than mine and
databases much bigger than the ones i use. Phpmyadmin is also pretty
slow and takes over 5 seconds to just show a simple table overview.
All these tests are done on the localhost, so the internet connection
is not an issue here. What is wrong here?
Some system related facts: i've compiled a custom kernel omitting
all the options I don't use or my machine don't have. Both PHP and
MySQL are custom build, as well as my Apache. Finally the crontab file
i use:
# /etc/crontab - root's crontab for FreeBSD
#
# $FreeBSD: src/etc/crontab,v 1.21.2.3 2000/12/08 10:56:07 obrien Exp
$
#
SHELL=/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
HOME=/var/log
#
#minute hour mday month wday who command
#
*/5 * * * * root /usr/libexec/atrun
#
# rotate log files every hour, if necessary
0 * * * * root newsyslog
#
# do daily/weekly/monthly maintenance
1 3 * * * root periodic daily
15 4 * * 6 root periodic weekly
30 5 1 * * root periodic monthly
#
# Maintenance on Fellownet MySQL database
#
30 * * * * bob /usr/bin/perl
/www/maintenance.pl
#
# time zone change adjustment for wall cmos clock,
# does nothing, if you have UTC cmos clock.
# See adjkerntz(8) for details.
1,31 0-5 * * * root adjkerntz -a
Thnx in advance,
Bob Kersten.
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-stable" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?001e01c1c942$d5f25ea0$0200000a>