All:
I created this script to analyze the tables on a periodic basis. It
accounts for changes in the schema by using a database table called SysTable
in each db to be analyzed.
Create table SysTable
TableName varchar(255) not null
);
We run this once per week now using a CRON job.
is with analyze/check/repair table
mysql analyze table uzivatele;
+-+-+--++
| Table | Op | Msg_type | Msg_text
) | | MUL | n ||
MD | pocet_prihlaseni| int(10) unsigned | | | 0 ||
MD +-+--+--+-+-++
[skip]
MD and next problem is with analyze/check/repair table
MD mysql
