Re: [fw-db] What MySQL Storage Engine to use

i dare not try that ... when i run show processlist; it shows that repair
table has been running for 20k i think seconds or minutes already ...

mbneto wrote:
>
> Hi,
>
> This is probably a mysql-forum question but you could try to repair it
> (with
> the db offline) with myisamchk -r tablename.MYI and/or recreate it with
> the
> InnoDb type.
>
> Can you use the mysqldump?
>
> On Sat, Jun 13, 2009 at 10:37 PM, iceangel89 <comet2005@gmail.com> wrote:
>
>>
>> that seems very true for the company's client db now ... a table which i
>> think probably is the biggest of all is now crashing often ... and
>> recently,
>> it seems like i cannot execute any queries
>>
>> select, show create table, repair, etc
>>
>> it just hangs there
>>
>> what can i do?
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/What-MySQL-Storage-Engine-to-use-tp24011061p24018130.html
>> Sent from the Zend DB mailing list archive at Nabble.com.
>>
>>
>
>

--
View this message in context: http://www.nabble.com/What-MySQL-Storage-Engine-to-use-tp24011061p24022118.html
Sent from the Zend DB mailing list archive at Nabble.com.