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.
A
||
MD> | aktivni | char(1) | | MUL | n ||
MD> | pocet_prihlaseni| int(10) unsigned | | | 0 ||
MD> +-+--+--+-+-+----+
[skip]
MD&g
ew version return
nothing!
and next problem is with analyze/check/repair table
mysql> analyze table uzivatele;
+-+-+--++
| Table
