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.


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!
TheFox

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!

Hi Andy,

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

thanks
TheFox

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!

Hi,

It sure is dedicated server. I can do every under root.
TheFox

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!

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" job
TheFox

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!

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

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!

Hi andy,

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