Anyone know of/have recommendations on a perl script to do
replication (binary) log rotation? I have a master with
multiple slaves. I need to be able to rotate the binary log
of the master and get rid of any old files that the slaves
aren't reading.
I'm looking for a script that will talk
Hi!
Our replication developers have recently fixed a bug that looks
conspiciously like the one you reported.
It will come up in 3.23.53 which should come up in 7 - 10 days.
Would you please be so kind to check it out if it still persists.
If you would like to test code sooner, you can
consists simply of one thread looping through INSERT INTO
testtable VALUES(1), and another doing a RESET MASTER; query.
(based on this, we're also testing a workaround of making log rotation
do FLUSH TABLES WITH READ LOCK; ... ; UNLOCK TABLES; which seems to be
effective)
If there's any particular
. The backtrace
that results also looks the same as in the initial report.
Test case consists simply of one thread looping through INSERT INTO
testtable VALUES(1), and another doing RESET MASTER;.
(based on this, we're also testing a workaround of making log rotation
do FLUSH TABLES WITH READ LOCK
021009 12:56:49 mysqld started
/usr/sbin/mysqld: ready for connections
021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'FIRST' at position 4
021009 12:56:49 Error reading packet from server: Binary log is not open
(read_errno 0,server_errno=2000
On Mon, 2002-10-07 at 17:40, Victoria Reznichenko wrote:
MJF One of the machines is simultaneously slave to one server and master to
MJF two others; on that machine, if a RESET MASTER or PURGE MASTER LOGS
MJF is executed while its slave thread is performing a query, mysqld
MJF reproducibly
Apologies to the list. Apparently the question I asked regarding binary
data dumps is an issue involving a MySQL startup parameter: log-bin.
Apparently this is the redo-log facility of MySQL for all successful
updates. This can be turned on or off. Question answered.
Thanks,
Rob
Robert Fox
Matthew,
Wednesday, October 02, 2002, 5:29:38 PM, you wrote:
MJF My company runs a moderately large and loaded MySQL replication network
MJF across four Solaris machines. While upgrading from a fairly old 3.23.4x
MJF installation to 3.23.52 we've encountered a problem with replication and
MJF
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 12:17 AM
To: Dragos Madalin Popa
Subject: Re: RE: how can I turn on query log on Windows? (mysql-3.23.38)
Your message cannot be posted because it appears to be either spam or
simply
_db_func_ = 0x0
_db_file_ = 0x0
_db_level_ = 0
_db_framep_ = (char **) 0x0
(gdb)
# cat /etc/my.cnf
[mysqld]
server-id = 2002
master-host = 192.168.x.x
master-user = replication
master-password = replication
master-port = 3306
log-bin
log-slave-updates
skip-slave-start
skip
antispam,
Monday, September 16, 2002, 11:25:31 PM, you wrote:
aafdn my log file (hostname.log) was soo large and i just deleted it(back up) and
created a new file called hostname.log but mysql does not stores anything in the log
file.. (i did mysqladmin
aafdn log-flush and server stop
Do not run myisamchk with the server running.
Stephen Sokalski wrote:
version: 3.23.37 running on an RAQ
Problem: I can not log into MySql as root - it hangs after I give it
a password.
Background: MySql was running fine for a year and then just stopped
running.
Symptoms: 1) Mysqld
Stephen, mysqlcheck works while the server is running. P.
Gerald Clark wrote:
Do not run myisamchk with the server running.
Stephen Sokalski wrote:
version: 3.23.37 running on an RAQ
Problem: I can not log into MySql as root - it hangs after I give it
a password
version: 3.23.37 running on an RAQ
Problem: I can not log into MySql as root - it hangs after I give it a
password.
Background: MySql was running fine for a year and then just stopped
running.
Symptoms:
1) Mysqld is running when I reboot the server but can't be shut down
(/usr/share
I don't even have a master.info file to remove.
The master.info file never gets written. It won't start replication at all.
It just keeps writing the same error to the log file:
Slave thread: error connecting to master: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) (0), retry
On Thu, Sep 05, 2002 at 09:52:05AM -0400, Jamie Beu wrote:
I am attempting to setup MySQL replication between the ctiadb1 (master)
server and the ctiadb2 (slave) server.
When I look at the mysql.log file on the slave, I see the following
(repeated every 60 seconds):
020904 12:00:30
: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 11:02 PM
To: Jamie Beu
Cc: [EMAIL PROTECTED]
Subject: Re: Replication problem: slave can't log into master (update)
Pada Thu, 5 Sep 2002 12:35:45 -0400
Jamie Beu [EMAIL PROTECTED] menulis :
I am still having
'@'%' identified by 'replctia';
flush privileges;
Please tell me what I am doing wrong or missing.
The /etc/my.cnf file on the master (ctiadb1) is as follows:
---
[mysqld]
log-bin
server-id=21
max_binlog_size=512M
---
The /etc/my.cnf file on the slave
what I am doing wrong or missing.
The /etc/my.cnf file on the master (ctiadb1) is as follows:
---
[mysqld]
log-bin
server-id=21
max_binlog_size=512M
---
The /etc/my.cnf file on the slave (ctiadb2) is as follows
Pada Thu, 5 Sep 2002 12:35:45 -0400
Jamie Beu [EMAIL PROTECTED] menulis :
I am still having problems with the slave server being able to connect to
the master, but a thought occured to me while we were working another topic.
Please let me know what I'm missing. I can do the following:
Hi,
I tried using the mysqlbinlog from 3.23.52 MAX with no difference in the
output at all from 4.0.2
It seems that whatever happened truely caused the log files to become
corrupted
So my next question would be, is there a way to repair the log files? What
are the formating rules for the log
didn't mean to. I am using mysql 4.0.1 Alpha and some
innodb and some myisam tables.
I have the log files I need to restore my data since I have been running
since the last backup with binlog enabled in my.cnf.
The problem is that mysqlbinlog shows some log files, but other log files
choke.
In VI
and 4.0.3 version already logs drop table into
the MySQL binary log.
Regards,
Monty
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
say there are 2 servers A and B. I have configures replication so that
server A is a master and server B is a slave. so sometimes after
incorrect query replication stops and the error log indicates that I
should correct bin log. I dont know how. any help would be great.
Regards,
--
George
Hi,
I deleted a db I didn't mean to. I am using mysql 4.0.1 Alpha and some
innodb and some myisam tables.
I have the log files I need to restore my data since I have been running
since the last backup with binlog enabled in my.cnf.
The problem is that mysqlbinlog shows some log files
I am having problems with mysql loggin slow queries. I have set up mysql.sh
like this
log_dir=/home/admin/slow_slog.log
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow-queri
es=$log_dir
That is all I have changed and re started mysql. but no slow_slog.log file
has been
Did you check your error logs?
Does mysql have write permissions to /home/admin ?
John Wards wrote:
I am having problems with mysql loggin slow queries. I have set up mysql.sh
like this
log_dir=/home/admin/slow_slog.log
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow
Hi all.
Hello spam filter! sql. query.
I had to restore from a backup and run through part of the day's
transactions from the --log-update option ... I had accidentally deleted
2500 records, and wanted to replay the logs minus that one delete
command :-)
One problem which I encountered
3.23.49a-Replication I can't
explain.
A perl-script which controls whether master- and replication-tables are
equal
showed
me, that a master-table was missing on both slaves (two backups are better
than
one
:-) )
When I controlled the master update-log I saw that the master-table was
renamed
Lutz,
- Original Message -
From: Lutz Maibach [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 5:09 PM
Subject: Re: Rename Table in Replication failed / command missing in slave
log
Hi Heikki,
Lutz' problem looks like somethig different
update-log I saw that the master-table was renamed with
the following command:
ALTER TABLE ad_429_t RENAME adprj_7;
This command was missing in the slave-updatelogs. The sql-statements before and
right after the missing one were present and no error was written down in the
mysql-error-log.
Trying
.
A perl-script which controls whether master- and replication-tables are equal showed
me, that a master-table was missing on both slaves (two backups are better than one
:-) )
When I controlled the master update-log I saw that the master-table was renamed with
the following command:
ALTER TABLE
Is there a way to not have mysql put fulltext searches in the slow query
log?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
At 10:53 -0700 8/9/02, Steven Roussey wrote:
Is there a way to not have mysql put fulltext searches in the slow query
log?
Not FULLTEXT queries specifically. You can bump up long_query_time, but
that applies to all queries.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
Hi Heikki,
Thank you for responding.
(http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
when the log files are full and the buffer pool is checkpointed.
InnoDB does 'fuzzy checkpoints'. That means modified database pages in the
buffer pool are flushed to disk
Pete,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, August 02, 2002 2:40 AM
Subject: Re: InnoDB: Looong pause when log file is full?
On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote:
Hi,
I've read
Hi,
I've read the performance tuning tips for InnoDB
(http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
when the log files are full and the buffer pool is checkpointed.
By 'geting bit', I mean for several minutes the db server basically
stops, and our website stops serving
On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote:
Hi,
I've read the performance tuning tips for InnoDB
(http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
when the log files are full and the buffer pool is checkpointed.
By 'geting bit', I mean for several
Thanks for your feedback (and your general untiring devotion to the
cause...)
On Thu, Aug 01, 2002 at 04:30:10PM -0700, Jeremy Zawodny wrote:
about what we can do to alleviate this? Instead of having three 150mb
log files, would we be better off with 30 15mb log files?
It shouldn't
Description:
If an update is made to a master using the syntax
'INSERT INTO database.table' etc... on a mysql connection
where no 'USE database' command has been given then the updates
are written to the master binary log correctly, and update
the slave
I've set up replication and the slave is updating any changes made to the
master, but these errors keep showing up in the error log. Any ideas??
020716 12:57:26 Slave: Failed reading log event, reconnecting to retry, log
'walt-bin.002' position 265
020716 12:57:26 Slave: reconnected
from server: (server_errno=1159)
020711 17:18:10 Slave: Failed reading log event, reconnecting to retry, log
'rs1-bin.001' position 276
020711 17:18:10 Slave: reconnected to master 'replica@rs1private:3306',replication
resumed in log 'rs1-bin.001' at position 276
eventually (30 seconds
Is there a way of turning on the general query log in the my.cnf file
or do I have to edit the init-script?
Personally, I would very much like to have only one place to set all
the configuration options (preferrably my.cnf). Setting datadir and
other options both in the my.cnf file and the init
Håkon Eriksen wrote:
Is there a way of turning on the general query log in the my.cnf file
or do I have to edit the init-script?
Yes, all command-line options can be specified in my.cnf. Read the
following page for more info:
http://www.mysql.com/doc/O/p/Option_files.html
-myk
Hi,
After reading about the audit log
(http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:95588), which I need; I
looked for the my.cnf and mysql.log file but didn't find any nor any other
related file.
Are these created by default or should I create them ?
Please advise.
TIA.
Jorge Ceballos
You will need to create my.cnf and turn ON the loggin option.
Bhavin.
- Original Message -
From: Jorge Ceballos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 04, 2002 12:30 PM
Subject: Audit - Log
Hi,
After reading about the audit log
(http://lists.mysql.com/cgi-ez
Hi
Paul - Thanks for your suggestion.
Unfortunately the general query log indicates that there is
no hint of any external interference and it still rotates
every few seconds ... there are constant accesses to the DB,
and the bin-log is rotated mid-connection by a querying client.
I have
At 11:43 +0200 6/26/02, Gary Colman wrote:
Hi
Paul - Thanks for your suggestion.
Unfortunately the general query log indicates that there is
no hint of any external interference and it still rotates
You may not see an explict FLUSH LOGS query. Do you seen any
lines that say Refresh after
Hi
Every few seconds, my mysql server generates a new binary log file
with an incremented id number ${hostname}-bin.x
According to the logs, this should happen only when a reload or flush
type command is issued ...
mysql variables:
flush off
log_bin on
max_binlog_size
At 16:31 +0200 6/25/02, Gary Colman wrote:
Hi
Every few seconds, my mysql server generates a new binary log file
with an incremented id number ${hostname}-bin.x
According to the logs, this should happen only when a reload or flush
type command is issued ...
mysql variables:
flush
-bin.xxx
I assume that it's the binary update log, but i haven't that with my old
3.23.48.
So please, how can i disable this log ??
Rgds
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
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
Hello,
i could not understand what is the content of log
files in InnoDB in MySQL...is it the log of the
database,i
mean, the data, or the transaction log??
Thanx in advance..
Ritu Singla
Everything you always
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: ritu singla [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 2:31 PM
Subject: Re: Log Files in InnoDB (MySQL)
Ritu,
the ib log files contain records of every change to database pages in the
ibdata files
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 mysqld-max process, and that there is no way to keep a separate
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 mysqld
in mysql docs, http://www.mysql.com/doc/L/o/Log_file_maintenance.html :
1) shell cd mysql-data-directory
2) shell mv mysql.log mysql.old
3) shell mysqladmin flush-logs
What's happening if there is a query between line 2 and 3, is it logged ?
How could I rotate my files without a query not
Opening a file access it by its inode.
Once it is opened, it can be renamed, or deleted, and this will have no
effect
for the process that has it open.
Flush logs will close the inode, and create a new log, which will assign
a new inode
to be opened.
File names are just handy pointers
On Fri, 19 Apr 2002 16:03:44 -0500 (CDT)
Russell E Glaue [EMAIL PROTECTED] wrote:
I think it would be a good idea to be able to specify the error log on
the command line when starting mysqld. Right now mysql users can only
specify the following logs on the command line:
log (access
I think it would be a good idea to be able to specify the error log on
the command line when starting mysqld. Right now mysql users can only
specify the following logs on the command line:
log (access/activity log)
log bin
log bin index
log update
log isam
Hi all,
I recently upgraded to Perl 5.6.1 and ever since I keep getting these errors
in my log files on my Linux machine every time the pages that get the data
from mysql are accessed:
Argument O_RDONLY isn't numeric in subroutine entry at
/usr/local/lib/perl5/5.6.1/i686-linux/DB_File.pm line
.
Does anybody have an idea how we could automate this procedure, or
should we manage the log-files is another way?
Here's a quick home-grown solution that works well for us. It's not
the smartest approach, but we never let a slave get too far behind
(they're all closely monitored), it works
-Original Message-
From: Marc Prewitt [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2002 14:46
To: [EMAIL PROTECTED]
Cc: paul
Subject: Re: How to automate bin-log clean-up with replicated MySQL
servers?
PFIZER GLOBAL RESEARCH AND DEVELOPMENT
On Thu, Apr 11, 2002 at 09:46:18AM -0400, Marc Prewitt wrote:
We have a slightly smarter script which checks each slave to find
the furthest one behind and purges up to that number. However, it
currently figures out who the slaves are by checking a process
status on the master.
the disk
space will get exhausted: SHOW SLAVE STATUS on the slave, write down
the 'Log_File' name, and pass that to PURGE MASTER LOGS TO 'logname'
on the master.
Does anybody have an idea how we could automate this procedure, or
should we manage the log-files is another way?
Thank you for your
Hello all,
I am having the mysql log file which is having all the queries which
affects the data base.
I have to restore those queries in the table in some remote server.
Is that possible.
Any ideas are welcome.
Thanks in advance
--
Regards,
Charitha
On Thu, 4 Apr 2002 16:05:57 +0530 (IST)
Charitha [EMAIL PROTECTED] wrote:
Hello all,
I am having the mysql log file which is having all the queries which
affects the data base.
I have to restore those queries in the table in some remote server.
Is that possible.
YAP !!! ;-)
Any
Charitha,
Thursday, April 04, 2002, 1:35:57 PM, you wrote:
C I am having the mysql log file which is having all the queries which
C affects the data base.
C I have to restore those queries in the table in some remote server.
C Is that possible.
Yes, you can update database from update logs
I am running Windows XP with MySQL running as a service. When I want to
run MySQL with the option for logging (--log -bin), I have to start the
service MANUALLY and type the --log -bin in the parameters box each time I
restart the server. Is there an easier way to do this?
Thx,
Craig
...
http://www.mysql.com/doc/O/p/Option_files.html
-Original Message-
From: Scalper [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 7:10 AM
To: [EMAIL PROTECTED]
Subject: Binary Log and WinXP Services
I am running Windows XP with MySQL running as a service. When I want
Hello,
We have an 'outgoing' table being used to store email header information
defined as follows:
CREATE TABLE outgoing (
rpath varchar(80) default NULL,
auth varchar(80) NOT NULL default '',
ip varchar(80) default NULL,
hfrom varchar(80) default NULL,
hto varchar(80) default NULL,
perhaps you can run this more frequently, say once an hour if
it does not interfere with your application logic.
-Original Message-
From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 4:57 PM
To: [EMAIL PROTECTED]
Subject: help optimizing log table deletes
= no. of affected rows returned by MySQL
(other processing, perhaps a sleep)
} while (row_count = delete_row_max;
-Original Message-
From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 9:57 AM
To: [EMAIL PROTECTED]
Subject: help optimizing log table deletes
Hello
Pål,
Wednesday, March 20, 2002, 5:52:58 PM, you wrote:
PW I have:
PW mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386)
PW and wonder about the log file /var/log/mysqld.log
PW shouldn't that include failed connections??
You can find mysqlds log in the file 'your_hostname.err
I have:
mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386)
and wonder about the log file /var/log/mysqld.log
shouldn't that include failed connections??
mvh: Pål Wester
høgskoleingenør/programmerer
never.no as, stortingsgt 30, 0161 Oslo
direkte: 22 01 66 34, 906 900 62
tlf: 22 01 66
Hi !
Is it possible to log mysql queries into a fifo created by :
# mkfifo -m660 queries.log
I've search with google but i found only one thread of one email where
somebody is getting an error 29. That's my case too.
Thanks a lot
is here for those
interested:
http://www.cse.fau.edu/~valankar/
I am trying to figure out what is the best way to do a certain query. My
outgoing log table looks like this:
mysql desc outgoing;
+---+--+--+-+-+---+
| Field | Type
To: [EMAIL PROTECTED]
Subject: sql help examining log table
Hello,
We use mysql to store outgoing email headers from our users and do
throttling
on users that appear to be spamming based on some simple queries to this
table. We use the Communigate mail server and this throttling script is a
PERL
of coffee:)
-Original Message-
From: Dan Vande More [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 1:44 PM
To: [EMAIL PROTECTED]
Subject: RE: sql help examining log table
I might be wrong, but this may get you going in the right direction:
select count(subject) as count, subject from
to this
table. We use the Communigate mail server and this throttling script is a PERL
program implemented as a content filter. More information is here for those
interested:
http://www.cse.fau.edu/~valankar/
I am trying to figure out what is the best way to do a certain query. My
outgoing log table
should be replicated for
theses databases
- cross updates should work
- If bin-log-do-db=xxx is set on master
and nothing on slaves, then - as stated somewhere
in the archive - crossupdates doesn't work. In addition,
create database is not recoginzed and drop database is only
recognized
I don't know if this will help you but try this:
# mysqld --help | grep dir:
basedir: /
datadir: /var/lib/mysql/
tmpdir: /tmp/
So, you'll find mysql log files in your datadir (is this case,
/var/lib/mysql/).
my.cnf is usually at /etc/my.cnf
If you don't have it, find
I installed following two files
MySQL-VERSION.i386.rpm
MySQL-client-VERSION.i386.rpm
but I can not fild my.cnf and mysql log files.
Why?
Thanks
Jianping Zhu
Department of Computer Science
Univerity of Georgia
Athens, GA 30602
Tel 706 5423900
The first query shown in the log is the one I actually tells ADO.Open to run...
however just after that one it runs two more (the
two tables includes in the first query) select * queries... Why??
This slows down the ADO a lot. Even Jet4.0 doesn't do that on the same query and is
therefore about
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it says it
couldn't recognize the option. Here's what I have for my.ini file, any
other way I have to type it? Please advise.
slow query log#=c
On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote:
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it
says it couldn't recognize the option. Here's what I have for my.ini
file, any
Never mind with that.. I don't know why it was there, it was created
automatically the 1st time you run the windows gui admin. And I had to
modify it to log-slow-queries=filename and it turned out ok. Thanks anyway.
Regards,
Martin
Hello,
I am using MySQL 3.23.36 on Linux. This is a small gripe about a product
I am otherwise very happy with. I hope I have not missed the obvious or
been stupid some other way.
The problem - I want to log somewhere other than $DATADIR. Things are
set up like ;
| log
Does mysql have permission to write to that location?
-Original Message-
From: alastair [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 10:33 AM
To: [EMAIL PROTECTED]
Subject: Logging problem with --log, my.cnf etc.
Hello,
I am using MySQL 3.23.36 on Linux
.
The problem is that I could not see the '--log' file getting recognised
or used in safe_mysqld. As I said, I would much rather be using
/etc/my.cnf with the log= syntax.
What I did in 'safe_mysqld' was ;
1) Add
--log=/var/log/mysql.log
to the call to safe_mysqld in my mysql init script
2) Add
On Thu, Feb 21, 2002 at 01:47:50PM -0500, Luc Foisy wrote:
maybe the variable you are using is not right
my 'show variables' indicates log with a value of OFF
| log | OFF
yet mysql still generates its standard error file
Hi Luc,
Thanks for the reply (but please
I am reading the documentation about the binary log, in particular
binlog-do-db=database_name
binlog-ignore-db=database_name
(a) Can these be specified in the my.cnf file?
(b) Can multiple databases be specified, either as a list or via multiple entries in
the
configuration?
We're running
Hi!
Heikki == Heikki Tuuri [EMAIL PROTECTED] writes:
Heikki Guilhem,
Heikki this is a known problem and mentioned in the Restrictions section of the
Heikki InnoDB online manual.
Heikki It is not the correct way to run SQL statements in the autocommit mode on
Heikki the slave server, while
are
not written to the binary log. I perfectly understand this if
I have one server. But assume I have a master server, and a
slave server that replicates the master. Let's say I distribute reads.
Let's say I issue the following queries on the master (I use
BEGIN and COMMIT for consistency) :BEGIN
are
not written to the binary log. I perfectly understand this if
I have one server. But assume I have a master server, and a
slave server that replicates the master. Let's say I distribute reads.
Let's say I issue the following queries on the master (I use
BEGIN and COMMIT for consistency) :BEGIN
are
not written to the binary log. I perfectly understand this if
I have one server. But assume I have a master server, and a
slave server that replicates the master. Let's say I distribute reads.
Let's say I issue the following queries on the master (I use
BEGIN and COMMIT for consistency) :BEGIN
i have a log file in which i record every visit of my site, although some
times a visitant came by the morning and by the night or something alike, so
i am trying to create a select command which count the ip every since he
came back a hour afther of his last visit, the command is just like
Hi!
Heikki == Heikki Tuuri [EMAIL PROTECTED] writes:
Heikki Guilhem,
Heikki this is a known problem and mentioned in the Restrictions section of the
Heikki InnoDB online manual.
Heikki It is not the correct way to run SQL statements in the autocommit mode on
Heikki the slave server, while
i have a log file in which i record every visit of my site, although some
times a visitant came by the morning and by the night or something alike, so
i am trying to create a select command which count the ip every since he
came back a hour afther of his last visit, the command is just like
Hello there,
I use MySQL (4.0.1) with InnoDB tables with binary logging on.
I see that the
BEGIN and COMMIT statements that wrap my queries are
not written to the binary log. I perfectly understand this if
I have one server. But assume I have a master server, and a
slave server
901 - 1000 of 1127 matches
Mail list logo
