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