RE: Question on log directory of a derby database

2011-07-20 Thread Bergquist, Brett
...@sbcglobal.net] Sent: Tuesday, July 19, 2011 2:31 PM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database I believe the consistency checker is going to lock each table for the duration of the checking. The time it takes is dependent on size of table. When

Re: Question on log directory of a derby database

2011-07-20 Thread Mike Matrigali
] Sent: Tuesday, July 19, 2011 3:59 PM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database Do you change the size of the Derby buffer cache? One problem Derby can have at these performance levels is that the checkpoint has to compete with I/O from the regular

RE: Question on log directory of a derby database

2011-07-19 Thread Bergquist, Brett
-dev@db.apache.org Subject: Question on log directory of a derby database I have a database in production that has been running fine for a few years. It started out having about 100K inserts per day into it and now is up to about 4.6M inserts per day and this has been working fine. Tonight

Re: Question on log directory of a derby database

2011-07-19 Thread Knut Anders Hatlen
Bergquist, Brett bbergqu...@canoga.com writes: I have a database in production that has been running fine for a few years. It started out having about 100K inserts per day into it and now is up to about 4.6M inserts per day and this has been working fine. Tonight the customer called because

RE: Question on log directory of a derby database

2011-07-19 Thread Bergquist, Brett
To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database Bergquist, Brett bbergqu...@canoga.com writes: I have a database in production that has been running fine for a few years. It started out having about 100K inserts per day into it and now is up to about 4.6M

Re: Question on log directory of a derby database

2011-07-19 Thread Mike Matrigali
shout out. Brett -Original Message- From: Knut Anders Hatlen [mailto:knut.hat...@oracle.com] Sent: Tuesday, July 19, 2011 9:41 AM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database Bergquist, Brett bbergqu...@canoga.com writes: I have a database

Re: Question on log directory of a derby database

2011-07-19 Thread Mike Matrigali
at if I see this happen again, please shout out. Brett -Original Message- From: Knut Anders Hatlen [mailto:knut.hat...@oracle.com] Sent: Tuesday, July 19, 2011 9:41 AM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database Bergquist, Brett bbergqu

RE: Question on log directory of a derby database

2011-07-19 Thread Bergquist, Brett
. This database is receiving about 50 or more inserts per second, 24x7 non-stop. -Original Message- From: Mike Matrigali [mailto:mikem_...@sbcglobal.net] Sent: Tuesday, July 19, 2011 1:10 PM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database

RE: Question on log directory of a derby database

2011-07-19 Thread Bergquist, Brett
...@sbcglobal.net] Sent: Tuesday, July 19, 2011 1:16 PM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database I would suggest you boot the backup database somewhere where you can let it run and let it finish, and then shut it down cleanly with shutdown=true

RE: Question on log directory of a derby database

2011-07-19 Thread Bergquist, Brett
think of that I should look at if I see this happen again, please shout out. Brett -Original Message- From: Knut Anders Hatlen [mailto:knut.hat...@oracle.com] Sent: Tuesday, July 19, 2011 9:41 AM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database

Re: Question on log directory of a derby database

2011-07-19 Thread Mike Matrigali
. -Original Message- From: Mike Matrigali [mailto:mikem_...@sbcglobal.net] Sent: Tuesday, July 19, 2011 1:10 PM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database It is likely the database is corrupt now that you booted without letting recovery do its

RE: Question on log directory of a derby database

2011-07-19 Thread Bergquist, Brett
: Tuesday, July 19, 2011 2:31 PM To: derby-dev@db.apache.org Subject: Re: Question on log directory of a derby database I believe the consistency checker is going to lock each table for the duration of the checking. The time it takes is dependent on size of table. When possible post a directory

Re: Question on log directory of a derby database

2011-07-19 Thread Mike Matrigali
-dev@db.apache.org Subject: Re: Question on log directory of a derby database I believe the consistency checker is going to lock each table for the duration of the checking. The time it takes is dependent on size of table. When possible post a directory listing of the files in log directory

Question on log directory of a derby database

2011-07-18 Thread Bergquist, Brett
I have a database in production that has been running fine for a few years. It started out having about 100K inserts per day into it and now is up to about 4.6M inserts per day and this has been working fine. Tonight the customer called because the system was chewing up disk space. I had