Ad Widget

Collapse

table history_uint to big

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mulbzh
    Senior Member
    • Nov 2014
    • 115

    #1

    table history_uint to big

    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
Working...