Hi!
On Oct 07, Dathan Vance Pattishall wrote:
I have to drop the FULLTEXT INDEX added to a set of dbs containing a
TEXT field with an average of 6K of text added to each row, at a growth
of 250K rows added a day to a set of 100 tables. The reason for the drop
is due to table corruption and non-related query slowdown.
If mysql.com is interested in this issue, I can send a copy the table
format etc. In the meantime I have to drop the FULL TEXT INDEX.
Yes, sure, we're interested!
We even have a public bug database on http://bugs.mysql.com/
where one can report a bug, and follow the progress of his bugreport.
Actually http://bugs.mysql.com/ is The preferred place to report a bug.
DELETES and Frequent UPDATES of a FULLTEXT INDEX column, IMO are the
root cause of table corruption and query slow down time.
Can you create a test case for this ?
The reason for this opinion is based on the situation where after adding
the FULL TEXT INDEX to the body of each user's message, table corruption
occurred everyday, and query time of non related queries to a full text
What are these non-related queries ?
column multiplied by 10 or more. The application made frequents updates
to a table and a batch job or a user action would cause deletes.
Here are the corruption errors.
Can't open file: 'messages_06.MYI'. (errno: 145)
% perror 145
145 = Table was marked as crashed and should be repaired
So, unfortunately, it does not say anything about the reason of
corruption.
The fix
REPAIR TABLE messages_06;
What does REPAIR say ?
I would see dead lock queries as well: Explanation below.
Prior to the FULL TEXT INDEX queries normally took no more then a
second. These same queries took nearly 5 min before I killed them.
What queries ?
The stuck state was either waiting for table (btw no alter/flush
change was going on) or Locked, but not locked on any particular
query. The second granularity that show full processlist displays
did not indicate which query was the problem.
What does SHOW PROCESSLIST show ?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
