Time out during database Optimization and Fix and Repair

[RoarinRow]

I posted on SMF, but maybe someone here can help or offer advice. 

Day 1:

Does anyone have an idea why my session times out when I do a forum optimization within SMF or directly on myAdminPHP control panel?

When it times out I can not get back into the forum and I just get a white screen in my IE browser.

I had to do a database restore from my web host control panel, then go back into myAdminPHP and only select the tables that have overhang.

The same thing happens when I try to run a Fix and Repair via my SMF Admin section or directly on myAdminPHP.

The last thing I did before it was working successfully was to enable 'Fulltext index' in the Search options, which added 29048KB to the database, and of course upgrade to 1.1.2

Day 2:

Well I narrowed it down.  The table that is giving me problems is 'smf_messages'.  It has 114k records and is 77MB in size.

I can Optimize and Fix and Repair all other tables except this 'smf_messages' table.  Any suggestions?   When I choose to Analyze table, it says it's o.k.

I'm guessing this is the table that equates to all our posts on the forum.  I definitely don't want to risk messing up this table. 

First Advice Rec'd:

Check with your hosting company to see if they can increase the values for the time_out so that you can optimize your tables.

Any other advice?   Thanks.

[pheasant_plucker]

Which Browser are you using? Try another one!
I have had timeouts in IE7 before.

Gerry

[RoarinRow]

Which Browser are you using? Try another one!
I have had timeouts in IE7 before.

Gerry

Using IE7.  But I believe it related to a table that's corrupted cause it has been consistent for the last couple of days.

[pheasant_plucker]

I presume you have phpMyAdmin available on your server! Try running a repair on the table and if that doesn't work try using Firefox browser.

Gerry

[RoarinRow]

I presume you have phpMyAdmin available on your server! Try running a repair on the table and if that doesn't work try using Firefox browser.

Gerry

Thanks, I tried to run a repair and that had the same result of timing out.  I'll try FF tonight   :up:

[softtouch_ph]

It might be the max_execution_time in the php.ini (default 30). I had issues with that too before (unable to install tp), so I set it higher and all was fine after.

[RoarinRow]

It might be the max_execution_time in the php.ini (default 30). I had issues with that too before (unable to install tp), so I set it higher and all was fine after.

still waiting for my host to get back to me on extending the time out setting.  I'm on a shared hosted server.

[RoarinRow]

Hahaha I tried to use FF for the first time with myadminphp control panel and for some reason I could not see the left frame or bottom frame.  Anyone know the trick to have those show up?

[softtouch_ph]

Maybe you have s script blocker active?