Dominic Amann wrote:
First check if your kernel has LFS (large file support), then run the
following MySQL command:
ALTER TABLE messageblks MAX_ROWS=1000000000 AVG_ROW_LENGTH=33178;
(taking the average row length from dbmail-administrator's handy
output). Hope it works!
Hi Dominic,
at this time I've solved my previous prob using merging table and seem
to works fine ... I mean:
(1) renamed messageblks to messageblks_1
(2) created a messageblks_2 exactly like messageblks_1 but w/o data
(3) created messageblks with TYPE=MERGE
UNION=(messageblks_1,messageblks_2) INSERT_METHOD=LAST;
In another server box I'll try to do as you suggest me.
Many thanks again Dominic.
max
