What thread or post is being processed during upgrade to 3.6.x ?

[SaN-DeeP]

There are 2 alterations made to thread table and 2 alterations made to posts table for upgrading from 3.5.x to 3.6.x gold release.

Since this process shall take a long time for us, I would like to know how can I trace via ssh, phpmyadmin what thread or post record is currently being altered ?
This shall be handy to understand how long my upgrade process might take..

(Please note, it is important for me cause I am running couple of vbulletin forums on my server)

Thank You.

[Colin F]

The only similiar thing I know about is SHOW PROCESSLIST: http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html

[SaN-DeeP]

thanks colin,
But show processlist wont give me exact details (what I needed to view)
I am changing search type on of the forums with more then 2,044,448 posts, this is the current status as per phpmyadmin:

Command - Query
time - 99660
Query - Repair with keycache
Info - CREATE FULLTEXT INDEX title ON vb3_post (title,pagetext)

I am very much unsure, what row or post is getting updated, its been more then 24 hours now.

Can you possibly suggest something ?

[SaN-DeeP]

this is the showprocesslist status as of now:

mysql> SHOW FULL PROCESSLIST\G
*************************** 1. row ***************************
Id: 35134
User: username
Host: hostname
db: dbane
Command: Query
Time: 135670
State: Repair with keycache
Info: CREATE FULLTEXT INDEX title ON post (title,pagetext)

Its annoying but have to wait, its going to make me happy if I can know what record is been modified (create indexed) to confirm how long this might take.

If I am killing the process, entire post table will get crashed for sure.