ALTER TABLE query keeps timing out

This is a discussion on ALTER TABLE query keeps timing out within the MySQL Database forums, part of the Database Forums category; I have a database that is "moderatley" large, around 11 Million rows. Per the advice in this group, ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 06-28-2007
Derrick Shields
 
Posts: n/a
Default ALTER TABLE query keeps timing out

I have a database that is "moderatley" large, around 11 Million rows.
Per the advice in this group, I am trying to add an index:

ALTER TABLE people ADD FULLTEXT('name');

However whenever I run this query, be it command line via SSH or in a
GUI client such as TOAD or Navicat, I keep getting a "disconnected
from mysql during query" error. This isn't a matter of simply getting
disconnected from the server; I've checked all my server logs and
everything.

It doesn't look like the query is being executed either way. Any tips
on how go get this column full-text indexed? Thanks guys,

Derrick

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:16 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0