- Original Message -
> From: "Brent Clark"
>
> 'Statement may not be safe to log'
Heh. Some of those statements weren't particularly safe in previous versions,
either, but they didn't whine :-p
Roughly, what it comes down to is that statements that contain things that may
be differe
Hiya
I run master - master replication for my MySQL replication setup.
Ive just upgraded to Mysql 5.1 and as a result im seeing the following
in my syslog.
'Statement may not be safe to log'
Ive been reading up on the following.
http://dev.mysql.com/doc/refman/5.1/en/replication-sbr-rbr.htm
Hi,
I can convert the binlogs to text using mysqlbinlog and that works fine.
However; I have queries that span several lines e.g. :
SELECT blah
FROM t1
WHERE some condition
ORDER BY something
Does anyone know of any utilities to reformat binlogs so that the
queries are all on a singl
Does anyone know of a programming library/module (C or PERL or ?) to interface
with the MySQL binary logs?
Preferably a PERL module which wraps some C library to gain a PERL OO api
interface to manipulating MySQL Binary Logs.
If this does not exist, can someone point me at the API documentation
Hello.
It seems like a documented bug. Switch to 4.1.12. See:
http://dev.mysql.com/doc/mysql/en/replication-features.html
Markus Benning <[EMAIL PROTECTED]> wrote:
> Hello,
>
> i have a problem with my replication setup and SET statments.
> The SET statments seem to be not logge
On Jun 24, 2005, at 10:56 AM, Markus Benning wrote:
i have a problem with my replication setup and SET statments.
The SET statments seem to be not logged with the queries.
This is a replication limitation in versions prior to 4.1:
Update statements that refer to user variables (that is, varia
Hello,
i have a problem with my replication setup and SET statments.
The SET statments seem to be not logged with the queries.
An example:
CREATE TABLE blablub (ID INT NOT NULL auto_increment PRIMARY KEY, bla text,
blub text);
SET @bla='bla';
SET @blub='blub';
INSERT INTO blablub VALUES(NULL, @
Hi All,
I have some doubts regarding Mysqlbinlog. Does Mysqlbinlog support this
usage?
mysqlbinlog --user=root --host=127.0.0.1 master-bin.001.
I am repeatedly getting errors like master-bin.001 file not found in
Linux . When I give the full path of the master-bin.001 its working.
There is a m
Hi
Are out there tools to extract stats of different query types per
table/database basis? Like if I want to know which one is the most
accessed table and stuff like that. Having log-bin enabled.
Thanks
Mihai RUSU
Disclaimer: Any views or opinions presented within
