FYI,
I got this answer from another source earlier that supposedly works w/
7.3.0 and above
dbmcli -d <db> -u < dbmuser>,<password>
util_connect < dbmuser>,<password>
util_execute suspend logwriter
...
util_execute resume logwriter
util_release
|---------+---------------------------->
| | "John L. |
| | Singleton" |
| | <[EMAIL PROTECTED]|
| | gleton.com> |
| | |
| | 05/20/2004 02:12 |
| | PM |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: "David W Grantham" <[EMAIL PROTECTED]>
|
| cc: [EMAIL PROTECTED]
|
| Subject: Re: autosave_on/off commands
|
>------------------------------------------------------------------------------------------------------------------------------|
David,
If you're just trying to turn off the log writer -- you can do it like
this:
dbmcli -d <db> -u <dbmuser,dbmpass>
> db_admin
> util_connect
> util_execute SET LOG WRITER OFF
> util_release
Obviously then, you can turn your logs back on with
>db_admin
>util_connect
>util_execute SET LOG WRITER ON
> util_release
Do not, I repeat, do not, operate your database in production like this.
You should only temporarily disable the redo log management.
Cheers,
JLS
David W Grantham wrote:
>
>
>Hey,
>
>I was wondering about these commands... they werent really documented in
>the dbmcli commands, but i found them on another website. Just confirming
>what im thinking... these commands will stop the logwriter from writing
>redo logs (sorry if my terminology is off). Any more info would be
>helpful.
>
>Thanks
>
>
>
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
