Hi,
Can anyone give an idea as to how long this kind of query will take to run? Its a 5million link directory (ya, big - I know - thats why I'm having to set it up with indexing)
Id User Host db Command Time State Info
56 dmoz localhost glinks_dmoz Query 3849 Repair with keycache ALTER TABLE glinks_Links ADD FULLTEXT ft_Title ( Title )
..but its been running for about an hour now - and still going (the CPU has calmed down now).
Will this take a few hours, days, any ideas? Just wondering if its still doing anything useful, or if I should just kill the process :P
TIA
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Can anyone give an idea as to how long this kind of query will take to run? Its a 5million link directory (ya, big - I know - thats why I'm having to set it up with indexing)
Code:
SHOW FULL PROCESSLIST; Id User Host db Command Time State Info
56 dmoz localhost glinks_dmoz Query 3849 Repair with keycache ALTER TABLE glinks_Links ADD FULLTEXT ft_Title ( Title )
..but its been running for about an hour now - and still going (the CPU has calmed down now).
Will this take a few hours, days, any ideas? Just wondering if its still doing anything useful, or if I should just kill the process :P
TIA
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates