Hello,
I was looking to my database and I noticed that the size of the table history_uint was almost 17Go which is really big for my environment.
So I looked into the history_uint and lot of old data are still there. Housekeeper is supposed to delete every two days but it didn't do his work.
I tried to find which items are still there. So I'm trying to link the ItemID from "History_uint" and the name in the table "Items". Just to know the source of my problem and then I will clean manually my table.
"SELECT history_uint.itemid FROM history_uint INNER JOIN (SELECT itemid FROM items) as tbl on history_uint.itemid = tbl.itemid where clock < 1362878601 ;"
Is this request is correct ?
Other question ? Is there any way to find thanks to the interface which are these old data ?
Thanks !
I was looking to my database and I noticed that the size of the table history_uint was almost 17Go which is really big for my environment.
So I looked into the history_uint and lot of old data are still there. Housekeeper is supposed to delete every two days but it didn't do his work.
I tried to find which items are still there. So I'm trying to link the ItemID from "History_uint" and the name in the table "Items". Just to know the source of my problem and then I will clean manually my table.
"SELECT history_uint.itemid FROM history_uint INNER JOIN (SELECT itemid FROM items) as tbl on history_uint.itemid = tbl.itemid where clock < 1362878601 ;"
Is this request is correct ?
Other question ? Is there any way to find thanks to the interface which are these old data ?
Thanks !