Re: MySql table disappears at random after multiple TRUNCATE queries
Posted by:
A I
Date: September 23, 2014 10:29PM
This looks like a great workaround, however I am getting "new" data constantly in real time and don't have a full control over it. The reason I am emptying table every few seconds is because it is used by other php script to store entire webpages in every row, sizes of those tables quickly jump into gigabytes and make it impossible to process that amount of data, so I am forced to empty and parse that data as fast as I can. I think it will complicate things to try to change the tables on the fly in the second script while doing your table switch operation in the first.
Anyway, I changed TRUNCATE for DELETE, its perfect for my situation since my tables don't have too many rows so the performance is not affected in anyway.
I will take a note of your code for a future reference though! thx
Subject
Written By
Posted
September 23, 2014 05:45PM
September 23, 2014 09:25PM
September 23, 2014 10:15PM
Re: MySql table disappears at random after multiple TRUNCATE queries
September 23, 2014 10:29PM
September 24, 2014 12:13AM
September 23, 2014 10:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.