Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Trouble for repair table

Quote Reply
Trouble for repair table
Hi,

I have just import a DMOZ World category. It have 1,400,000 links and 150,000 sub-category. I do a repair table using

nphup perl nph-build.cgi --repair &

It have runing near 20 hours, but the script do nothing for the glinks_Category table. I using phpMyadmin to monitor the database. It always do a "SELECT COUNT( * ) FROM glinks_CatLinks, glinks_Category, glinks_Links
WHERE glinks_CatLinks.LinkID = gli" query. Pirate


Is there a BUG or somthing ? anyone know?

I'm using a P4 2.4 with 1G ram.

209 processes: 204 sleeping, 5 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 92.8% 0.0% 6.9% 0.0% 0.0% 0.1% 0.0%
Mem: 1017312k av, 981296k used, 36016k free, 0k shrd, 62564k buff
683372k actv, 130912k in_d, 14408k in_c
Swap: 2048276k av, 399384k used, 1648892k free 278512k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
10849 mysql 25 0 166M 147M 2688 R 98.7 14.8 1151m 0 mysqld
24498 admin 15 0 1248 1248 884 R 0.3 0.1 0:01 0 top
27435 root 15 0 45576 28M 2024 S 0.1 2.9 3:59 0 perl
24748 qmailr 16 0 964 964 768 S 0.1 0.0 0:00 0 qmail-remote
1 root 15 0 460 428 400 S 0.0 0.0 0:08 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
4 root 15 0 0 0 0 SW 0.0 0.0 0:15 0 kapmd
5 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
6 root 15 0 0 0 0 SW 0.0 0.0 1:03 0 kswapd
7 root 15 0 0 0 0 SW 0.0 0.0 2:14 0 kscand
9 root 15 0 0 0 0 SW 0.0 0.0 0:10 0 kupdated
10 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
14 root 15 0 0 0 0 SW 0.0 0.0 5:31 0 kjournald
69 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 khubd
1369 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1992 root 15 0 512 492 432 R 0.0 0.0 1:50 0 syslogd
1996 root 15 0 428 372 368 S 0.0 0.0 0:00 0 klogd
2050 root 15 0 668 624 540 S 0.0 0.0 0:17 0 xinetd
2064 named 15 0 2600 2252 1364 S 0.0 0.2 0:00 0 named
2076 named 15 0 2600 2252 1364 S 0.0 0.2 3:45 0 named
2077 named 15 0 2600 2252 1364 S 0.0 0.2 0:01 0 named
2078 named 15 0 2600 2252 1364 S 0.0 0.2 1:23 0 named

Please help!Unsure
TheFox
Quote Reply
Re: [TheFox] Trouble for repair table In reply to
Hi,

Doyou have Setup > Misc Options > debug set to "Enabled" ? If so, try turning it off.. and then try again. Does that make a difference?

NB, the World category is *huge*.. so you need to expect it to take a while =)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Trouble for repair table In reply to
Hi Andy,

I have already turn it off. I have repair when I have 300,000 links. It repair just using 5 mins.Pirate

thanks
TheFox
Quote Reply
Re: [TheFox] Trouble for repair table In reply to
Are you on a dedicated server, or "shared" ?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Trouble for repair table In reply to
Hi,

It sure is dedicated server. I can do every under root.
TheFox
Quote Reply
Re: [TheFox] Trouble for repair table In reply to
Hi,

Mmm.. when running that, what does "top" show?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Trouble for repair table In reply to
After a second day. the "Top" show

198 processes: 193 sleeping, 5 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 90.6% 0.0% 9.3% 0.0% 0.0% 0.0% 0.0%
Mem: 1017312k av, 989392k used, 27920k free, 0k shrd, 76508k buff
652824k actv, 125872k in_d, 16400k in_c
Swap: 2048276k av, 277352k used, 1770924k free 253680k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
10849 mysql 25 0 166M 146M 2684 R 92.4 14.7 2317m 0 mysqld
14595 popuser 24 0 376 376 304 R 2.9 0.0 0:00 0 qmail-local
27435 root 15 0 63328 44M 1972 S 0.3 4.4 8:00 0 perl
26514 admin 15 0 1224 1196 840 R 0.3 0.1 5:18 0 top
14592 popuser 22 0 316 316 260 S 0.1 0.0 0:00 0 qmail-local
1 root 15 0 460 428 400 S 0.0 0.0 0:09 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
4 root 15 0 0 0 0 SW 0.0 0.0 0:19 0 kapmd
5 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
6 root 15 0 0 0 0 SW 0.0 0.0 1:07 0 kswapd
7 root 15 0 0 0 0 SW 0.0 0.0 2:30 0 kscand
9 root 15 0 0 0 0 SW 0.0 0.0 0:13 0 kupdated
10 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
14 root 15 0 0 0 0 SW 0.0 0.0 5:38 0 kjournald
69 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 khubd
1369 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1992 root 15 0 512 492 432 R 0.0 0.0 1:56 0 syslogd
1996 root 15 0 428 372 368 S 0.0 0.0 0:00 0 klogd
2050 root 15 0 668 628 540 S 0.0 0.0 0:22 0 xinetd
2064 named 15 0 2588 2204 1352 S 0.0 0.2 0:00 0 named
2076 named 15 0 2588 2204 1352 S 0.0 0.2 4:16 0 named
2077 named 15 0 2588 2204 1352 S 0.0 0.2 0:01 0 named

Still nothing happen.... the nph-build.cgi not insert or alter anything with the table.... just doing it select job.

The Mysql doing over 180,000 "select count" jobUnsure
TheFox

Last edited by:

TheFox: Dec 15, 2005, 2:28 AM
Quote Reply
Re: [TheFox] Trouble for repair table In reply to
Hi,

Mmm.. what "spec" is this machine?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Trouble for repair table In reply to
P4 2.4 with 1G ram Redhat linux enterprise 3 Mysql 4

I think it is the time for GT download the DMOZ world part and test it using Glink3. I have never seen that happen in linksql 2.

Maybe it is a BUG.

Thanks
TheFox

Last edited by:

TheFox: Dec 15, 2005, 2:41 AM
Quote Reply
Re: [TheFox] Trouble for repair table In reply to
Mmm, it should be ok then :/

If you can send over root access, I don't mind taking a look for you. Not a lot I can really debug from it "just not working" :(

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Trouble for repair table In reply to
Hi andy,

I just send the root access info to you using PM.
TheFox