Pada Thu, 25 Jul 2002 09:28:45 +0200
Simas Cepaitis <[EMAIL PROTECTED]> menulis :
> Hello,
>
> Earlier i posted my message here, but haven't got any real solution.
> So now I'll try to post with some more details. I have a FreeBSD 4.6
> box, dual cpu, runing MySQL. It runs with linuxthreads enabled
> and it is under heavy load all the time. Few weeks ago it started
> to work a little strange. MySQL runs ok for some period of time,
> and then it disallows connections from users, saying 'access not
> allowed for user@localhost'. Root can connect without problems.
> The strange thing is, that MySQL somehow 'loses' it's databases.
> When I connect as root, 'show databases' output gives me one
> database... vi.recover. So I suppose, that MySQL drops it's path
> somewhere, but I'm not sure why. The only workaround I have for
> now is run database check every minute, and restart MySQL if
> needed. After restart everything looks OK for some time ( one - two
> days)... This problem was with 3.23.49, and now I saw this with
> 3.23.51 too. Any ideas what could be wrong?
vi.recover .... isn't it from "VI" application ???
Maybe someone is trying to do something inside your mysql data directory ... and
somehow he damage your DB
Try to investigate it from FILE side ;-)
>From my experiences, mysql never lost the databases ... because it's based on
>directory structure on your filesystem OS. eventhough it's mysql bug and your db
>corrupt, the directory should be still exist and you can see from show databases.
--
printk("??? No FDIV bug? Lucky you...\n");
2.2.16 /usr/src/linux/include/asm-i386/bugs.h
MySQL 3.23.51 : up 34 days, Queries : 354.952 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
