Hi EveryBody!
I don't know where to come with my question.. I have self-managed dedicated box in LayeredTech. I am not newbie in *nix and DA, but one thing I can't figure out...
I have powerful box: Dual Xeon 2.4 (2 processors), 2GB RAM, etc..
I am running FreeBSD 6.2 with my custom kernel (I only added few things to be able to use openvpn on it.. And all was fine for a long time with this kerenel)/
I am using MySQL 5.0.22, PHP 4.4.7..
But just a week ago I start suffered from "sudden hangs".. It is happen, when MySQL processing something hardly.. I want to underline, that I not changing anything, and this version of MySQL was working very well, and particularly was working fine on the queries, on which now it hangs the whole box..
All Tables is MyISAM... Working a lot of PHP-Threads with MySQL.. MySQL locking MyISAm, do something and unlocking it.. That's all..
Trouble can happen on every "stage" of working process.. When it all just started (10%), or when is is working for a 10 minutes(50%), for example...
Now MySQL hang the box, when it done search by index in a table with 10M records... Just searching the string on equal match... (On background to this 500 threads, which using the same DB (but not the same table) was running) ..
I know, that it is heavy loads the box, but I don't think that the box have to hang.. I am now using remote reboot, and uptime is hardly coming to 2 days..
I opened /var/log.. And can't found anything strange in logfiles... I think that box is hanged "tightly", in onetime, w/o any notifications....
Can you please give me the way, in which I have to think in order to solve my problem?... I can give you my MySQL configs, logs, etc... Just say, what you wanna see..
Thank a lot for everybody! Your help is deeply appreciated!
Have a Nice Day And Have a Great Year!
I don't know where to come with my question.. I have self-managed dedicated box in LayeredTech. I am not newbie in *nix and DA, but one thing I can't figure out...
I have powerful box: Dual Xeon 2.4 (2 processors), 2GB RAM, etc..
I am running FreeBSD 6.2 with my custom kernel (I only added few things to be able to use openvpn on it.. And all was fine for a long time with this kerenel)/
I am using MySQL 5.0.22, PHP 4.4.7..
But just a week ago I start suffered from "sudden hangs".. It is happen, when MySQL processing something hardly.. I want to underline, that I not changing anything, and this version of MySQL was working very well, and particularly was working fine on the queries, on which now it hangs the whole box..
All Tables is MyISAM... Working a lot of PHP-Threads with MySQL.. MySQL locking MyISAm, do something and unlocking it.. That's all..
Trouble can happen on every "stage" of working process.. When it all just started (10%), or when is is working for a 10 minutes(50%), for example...
Now MySQL hang the box, when it done search by index in a table with 10M records... Just searching the string on equal match... (On background to this 500 threads, which using the same DB (but not the same table) was running) ..
I know, that it is heavy loads the box, but I don't think that the box have to hang.. I am now using remote reboot, and uptime is hardly coming to 2 days..
I opened /var/log.. And can't found anything strange in logfiles... I think that box is hanged "tightly", in onetime, w/o any notifications....
Can you please give me the way, in which I have to think in order to solve my problem?... I can give you my MySQL configs, logs, etc... Just say, what you wanna see..
Thank a lot for everybody! Your help is deeply appreciated!
Have a Nice Day And Have a Great Year!
)