Hello,
The history_uint table is much too large (28GB).
As I do not need to keep history, can I delete the table to recreate another ?
Like this in MySQL :
CREATE TABLE history_uint_new LIKE history_uint;
ALTER TABLE history_uint RENAME history_uint_old;
ALTER TABLE history_uint_new RENAME history_uint;
I test that it works. Finally, I delete the old table:
DROP TABLE history_uint_old;
Will it work?
Thank you
The history_uint table is much too large (28GB).
As I do not need to keep history, can I delete the table to recreate another ?
Like this in MySQL :
CREATE TABLE history_uint_new LIKE history_uint;
ALTER TABLE history_uint RENAME history_uint_old;
ALTER TABLE history_uint_new RENAME history_uint;
I test that it works. Finally, I delete the old table:
DROP TABLE history_uint_old;
Will it work?
Thank you