On 2016-10-29 17:53, kragh.thomas@yahoo.com [firebird-support] wrote:
> Hey
>
> I have a database that needs some cleanup, in some tables i need to
> delete millions of rows. I performed the cleanup on a copy of the
> production database in a development environment, using:
>
> delete from table where created < dateadd(-6 month to current_date)
>
> followed by a count(*) on the table
>
> I know that this causes massive garbage collection, however all other
> attachments to the database, and all attachments to other databases on
> the same server stopped working, and no new attachments could be
> created until the count was completed.
>
> So my question is:
>
> Is this considered a bug in Firebird? Especially because users that
> did not access the table, and users of other databases on the server
> was affected?
>
> And how can i perform the delete on the production server without
> affecting users? When the database is used 24/7 and the tables i need
> to delete from are frequently accessed by users?
>
> The server is 2.5.5 running on CentOs - Running super classic.
>
> Best regards Thomas
I use a stored procedure to delete this kind of data. I invoke this SP
daily as a cleanup process.
Regards,
Paul Mercea
Posted by: "paul.mercea-almexa.ro" <paul.mercea@almexa.ro>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment