Gossamer Forum
Home : General : Databases and SQL :

ALTER TABLE glinks_Links ADD FULLTEXT ft_Title ( Title )

Quote Reply
ALTER TABLE glinks_Links ADD FULLTEXT ft_Title ( Title )
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)

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!