- Am 1. Apr 2016 um 21:56 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Correct. MyISAM is not a transactional storage engine. It has no concept
> of COMMIT or ROLLBACK. Changes to it are controlled by a full table lock
> and as soon as the change is complete, the table is unlocked and
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> Is the mix of MyISAM and InnoDB a problem with Row-Based-Logging or
>> with Statement-Based-Logging or with both ?
>>
>>
>
> Both.
>
>
>>
>> I don't understand the example:
>> Does "begin transaction" and
Am 01.04.2016 um 21:09 schrieb Lentes, Bernd:
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
You said, "This is done on the master, written in the log and then
replicated to the slave, "
The INSERT would not appear in the Binary log until after session 1
hat rolled back contained statements that
> changed MyISAM tables, then the entire transaction (all of the work it
> did) needs to be written into the Binary Log and REDO log just to have
> the very last command be "ROLLBACK". What that will do is create the
> same sequen
- Am 1. Apr 2016 um 17:52 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> What is true ? when the transaction started or when the first read is
>> performed ?
> Until you need to establish a snapshot of the data, then you don't need
> a snapshot position.
>
> The transaction
On 4/1/2016 10:08 AM, Lentes, Bernd wrote:
- On Apr 1, 2016, at 3:12 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
Btw:
i read about isolation levels. REPEATABLE READ is the default for InnoDB.
http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:
On 4/1/2016 9:12 AM, Lentes, Bernd wrote:
- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
"Unsafe" in that sense replies to the fact that certain commands can
have a different effect when processed from the Binary Log than they did
when they were executed
- On Apr 1, 2016, at 3:12 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
Btw:
i read about isolation levels. REPEATABLE READ is the default for InnoDB.
http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:
"...so that all queries within a transaction
- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
> "Unsafe" in that sense replies to the fact that certain commands can
> have a different effect when processed from the Binary Log than they did
> when they were executed originally on the system that wrote the
On 3/30/2016 1:26 PM, Lentes, Bernd wrote:
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
So i should use the default (autocommit=1)?
no, you should what is appropriate for your application
if you don't care about inserts/updates triggered by let say a
Am 30.03.2016 um 19:26 schrieb Lentes, Bernd:
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
So i should use the default (autocommit=1)?
no, you should what is appropriate for your application
if you don't care about inserts/updates triggered by let say a
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
>> So i should use the default (autocommit=1)?
>
> no, you should what is appropriate for your application
>
> if you don't care about inserts/updates triggered by let say a
> webrequest are half written due a crash
Am 30.03.2016 um 18:56 schrieb Lentes, Bernd:
- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
I read that the converting is not difficult. But has the code of our webapp to
be changed ? It's written in php and perl.
What i understand is that
- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
>>
>> I read that the converting is not difficult. But has the code of our webapp
>> to
>> be changed ? It's written in php and perl.
>> What i understand is that inserts/updates/deletions in InnoDB tables have to
Am 28.03.2016 um 21:36 schrieb Lentes, Bernd:
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors
Hello Bernd,
On 3/28/2016 3:36 PM, Lentes, Bernd wrote:
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
> Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
>>> You would be better served by first converting your MyISAM tables to
>>> InnoDB to stop mixing storage engine behaviors (transactional and
>>> non-transactional)
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors (transactional and
non-transactional) within the scope of a single transaction. But if you
cannot convert them, using MIXED will be
- Am 25. Mrz 2016 um 21:54 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Hello Bernd,
>
> Sorry for the delay, I wanted to make sure I had enough time to address
> all of your points.
>> He proposed to have two hosts, and on each is running a MySQL instance
>> as master AND slave.
Hello Bernd,
Sorry for the delay, I wanted to make sure I had enough time to address
all of your points.
On 3/22/2016 7:07 AM, william drescher wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know
- On Mar 23, 2016, at 11:11 AM, william drescher will...@techservsys.com
wrote:
>>
>> Hi William,
>>
>> thanks for the try. Good idea !
>> Did you change anything ?
>>
>>
>> Bernd
>
> Yes, in the original document there were some characters that
> were put on the screen as asian
On 3/22/2016 7:49 AM, Lentes, Bernd wrote:
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
> sent for Bernd, and to see if it works from another sender
> --
> Lentes, Bernd wrote:
> Hi,
>
> i know that there is a list dedicated to replication, but when
>
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list dedicated to replication, but when
you have a look in the archive it's nearly complete empty. Really
not busy.
So i hope it's ok if i
- On Mar 19, 2016, at 3:28 PM, Reindl Harald h.rei...@thelounge.net wrote:
> Am 19.03.2016 um 15:23 schrieb Reindl Harald:
>>
>>
>> Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
>>> one further question:
>>> if some of my e-mails get through (like this one) and others don't, it
>>> does not
Dear list admin,
i need your help. I'm trying to write an e-Mail to the list for already one
week. I always get it back because it's classified as spam.
The mail is formatted as plain-text, include neither links nor attachments. I
don't understand why it's classified as spam. Neither our domain
Am 18.03.2016 um 14:56 schrieb Chris Knipe:
Blah blah blah...
Delivery to the following recipient failed permanently:
mysql@lists.mysql.com
Technical details of permanent failure:
Your message was rejected by the server for the recipient domain
lists.mysql.com by lists-mx.mysql.com.
On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd <
bernd.len...@helmholtz-muenchen.de> wrote:
> i need your help. I'm trying to write an e-Mail to the list for already
> one week. I always get it back because it's classified as spam.
>
Ditto. I've pretty much given up on this list...
Am 19.03.2016 um 15:23 schrieb Reindl Harald:
Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
one further question:
if some of my e-mails get through (like this one) and others don't, it
does not depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that
Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
one further question:
if some of my e-mails get through (like this one) and others don't, it does not
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail?
both
a spamfilter is typically
Am 19.03.2016 um 15:08 schrieb Lentes, Bernd:
Ok. I tried again:
pc53200:~ # nslookup 20.103.107.146.score.senderscore.com.
Server: 146.107.8.88
Address:146.107.8.88#53
Non-authoritative answer:
Name: 20.103.107.146.score.senderscore.com
Address: 127.0.4.62
My result is
Hi,
one further question:
if some of my e-mails get through (like this one) and others don't, it does not
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail ?
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer
- Am 18. Mrz 2016 um 15:34 schrieb Reindl Harald h.rei...@thelounge.net:
> Am 18.03.2016 um 15:25 schrieb Lentes, Bernd:
>>
>> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be:
>>
>
> as i already told you offlist
> senderscore.com LISTED 127.0.4.67
>
> this
ent: Friday, 18 March, 2016 14:46:26
Subject: Re: need help from the list admin
Ditto. I've pretty much given up on this list...
Neither our outgoing mailserver
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#)
nor our domain
(http://mxtoolbox.com/SuperTo
e :-)
>>>
>>> - Original Message -
>>>
>>>> From: "Chris Knipe" <sav...@savage.za.org>
>>>> To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
>>>> Cc: "MySql" <mysql@lists.mysql.com&g
spam, that's
> usually caused by something on your side :-)
>
> - Original Message -
>> From: "Chris Knipe" <sav...@savage.za.org>
>> To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
>> Cc: "MySql" <mysql@lists.mysql.c
"Chris Knipe" <sav...@savage.za.org>
> > To: "Lentes, Bernd" <bernd.len...@helmholtz-muenchen.de>
> > Cc: "MySql" <mysql@lists.mysql.com>
> > Sent: Friday, 18 March, 2016 14:46:26
> > Subject: Re: need help from the list admin
>
37 matches
Mail list logo
