hi,

i have a big problem. i did not maintain new submissions for apx 4 months, and since i started to validate new links - my installation will not build, and kills mysql after a few minutes.. i have not changed a thing since the installation was running without problems a few months ago..

does anybody have an idea what i can do to get back up ?



Dane

Did you try using build staggered?

yes, tried build staggered - still gets stuck at the first message " building....."

Did you try doing a repair of the tables and the search before building?

yes, repair done - no effect

Well that was my level of knowledge...I am sure that others will post some ideas soon for you as well.

Good luck!

ok, thanks for the try :)

What does mysql say?


Try turning on debugging and post the results here so we help you.

mysql doesn't say anything, it just gets stuck (no response)

1) are you running on a shared or dedicated server?

2) does mySQL die, or just seem to hang?

3) Did you check the "mysql status" to see if anything was going on?

4) When it seems to hang, did you do a ps -ef (or ps -aux) to see if the process is consuming any resources?

5) Did you try to repair the MySQL install, using ISAMCHK ? (that needs to be done as root, so you would probably need your ISP to do that if you are on a shared machine).

Just some things to test.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

1) are you running on a shared or dedicated server?

dedicated

2) does mySQL die, or just seem to hang?

hang

Did you check the "mysql status" to see if anything was going on?

where ?

4) When it seems to hang, did you do a ps -ef (or ps -aux) to see if the process is consuming any resources?

i'm afraid it beyond me, what i'm looking for there


5) Did you try to repair the MySQL install, using ISAMCHK ? (that needs to be done as root, so you would probably need your ISP to do that if you are on a shared machine).



no, but several other programs are using mysql without any problems

PS: It's also impossible to Repair Tables..Started at Mon Aug 19 04:13:30 2002.Checking category stats ... Done (3.00 s)Resetting hits and rates ... and there it gets stuck again

Run ISAMCHK on your lsql db. One database can get screwed whilst others remain okay. Try it.

Ok,

I hope you have telnet access to the machine.

Telnet in, and while the system is "hung" type "top" and see if the mysql process is consuming resources, or if it's just sitting.

and yes... one database can be corrupted when others are not.

I'd like to give you the commands for running isamchk, but apparantly my version is out of sync with my version of mysql....


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

dammed i think i fixed it.. found 110megs in Links_ClickTrack and emtied it, after that no problems.. does anyone know what that was and why it became so large ?