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.com
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!
Custom Toolbar for IE and Firefox! - 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.com
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!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates