[MonetDB-users] db log shrink
Is there any method, besides restarting the database, of shrinking the sql log file?
When I am performing a large set of large inserts (via COPY INTO) the log file gets very large. I wish there was a way to cycle the log file.
Also during these large batches of inserts the database server becomes less and less responsive until I am forced to restart the server. Upon restart and the normal recovery monet returns to a very responsive state.
was there any response to this? I am having the same issue.
Colin Foss wrote:
Is there any method, besides restarting the database, of shrinking the sql log file?
When I am performing a large set of large inserts (via COPY INTO) the log file gets very large. I wish there was a way to cycle the log file.
Also during these large batches of inserts the database server becomes less and less responsive until I am forced to restart the server. Upon restart and the normal recovery monet returns to a very responsive state.
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Wed, Apr 16, 2008 at 07:00:11PM -0700, mobigital1 wrote:
was there any response to this? I am having the same issue.
There is no other method for shrinking the sql log file. They are needed and are cleanup on the next start (and once every 5 idle minutes).
Niels
Colin Foss wrote:
Is there any method, besides restarting the database, of shrinking the sql log file?
When I am performing a large set of large inserts (via COPY INTO) the log file gets very large. I wish there was a way to cycle the log file.
Also during these large batches of inserts the database server becomes less and less responsive until I am forced to restart the server. Upon restart and the normal recovery monet returns to a very responsive state.
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://www.nabble.com/db-log-shrink-tp11104591p16737324.html Sent from the monetdb-users mailing list archive at Nabble.com.
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (3)
-
Colin Foss
-
mobigital1
-
Niels Nes