on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
the --binlog-do-db option along with it. Databases not named with
--bi
At 18:55 -0600 3/25/04, Moritz von Schweinitz wrote:
hi again!
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
the --bi
Maybe you have my.cnf file in your computer. That can be under
/etc or you home directory. In that file there may be text like this.
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
set-variable= myisam_sort_buffer_size=64M
log-bin
server-id = 1
You
On Mon, May 27, 2002 at 10:31:06AM -0700, jim hopp wrote:
> Greetings,
>
> We plan to use the binary update log plus backups to enable us to
> restore databases and then re-apply updates when necessary. It
> appears to me that the binary update log contains updates to all
> databases on the mysq
On Wed, Sep 19, 2001 at 09:37:29AM -0700, Cameron Watters -- List Subscriptions wrote:
> Just a quick question regarding how (if at all) MySQL's binary update log
> consumes resrouces as it records modifications to various tables in the
> database.
>
> Are there any potential performance issues o
