Hi guys i have a problem, 3 big tables: item_instance about 15KK rows, character_inventory 15KK rows, guild_bank_item 2KK rows.
And i need i clean on item_instance how this query: DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM `character_inventory`) AND guid NOT IN(SELECT item_guid FROM `guild_bank_item`) AND guid NOT IN(SELECT item_guid FROM `mail_items`) and guid NOT IN(SELECT itemguid FROM `auctionhouse`); Well atm is running about 13 hours, State = Sending Data. I will be a better option ? Thanks all ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
