So here's the "resolution". Consider the following grid for explanation:
| ndb-log-bin MYS01 | ndb-log-bin MYS02 | overloaded kernel
----------------------------------------------------
| 0 | 0 | No
----------------------------------------------------
| 0 | 1 | Yes
----------------------------------------------------
| 1 | 0 | Yes
----------------------------------------------------
| 1 | 1 | Yes
----------------------------------------------------
Looks familiar (http://en.wikipedia.org/wiki/OR_gate)
I tried all different combos and tried tweaking the values of
binlog_cache_size, max-binlog-size, turning off/on slow-query-log and
log-queries-not-using-indexes and log-slave-updates, etc to no avail.
Pretty much have to just turn off ndb-log-bin (on each mysqld node
connected to the cluster) so that tables that are ENGINE=NDB don't get
logged in the binary log.
Someone maybe want to change "1218 'Send Buffers overloaded in NDB
kernel'" to something like "Try turning off ndb binary logging"? :)
Are there possibly other undocumented parameters I can tweak on the
binlog to help?
-Matthew
> -----Original Message-----
> From: Robert Klikics [mailto:server@stripped]
> Sent: Wednesday, November 11, 2009 9:08 AM
> To: Boehm, Matthew
> Cc: cluster@stripped
> Subject: Re: Send Buffers overloaded in NDB kernel
>
> Well, thats not exactly the kind of "documentation" I was searching
for
> ;-)
> But thanks, I'll have a look of that.
>
> What about compiling --without-ndb-binlog ? Maybe this helps?
>
> Regards,
> Robert
>
>
> Am 11.11.2009 um 16:02 schrieb Boehm, Matthew:
>
> > I found them "documented" here:
> >
> > http://forge.mysql.com/tools/tool.php?id=212
> >
> > Which is the giant patch from 5.1.34 to 7.0.
> >
> > Look at lines 4080 through 4087.
> >
> > Both show GET_BOOL so I can only guess their values can be either 1
> or 0
> > (ON or OFF).
> >
> > I'm continuing my experiments today to determine if turning on/off
> ndb
> > binlogging is the 'culprit' behind the overloaded kernel error.
> >
> > I'm hoping that tweaks to the binlog itself will help.
> >
> > -Matthew
> >
> >> -----Original Message-----
> >> From: Robert Klikics [mailto:server@stripped]
> >> Sent: Wednesday, November 11, 2009 8:15 AM
> >> To: cluster@stripped
> >> Subject: Re: Send Buffers overloaded in NDB kernel
> >>
> >> Hello,
> >>
> >> just a short question:
> >>
> >>> I set in my.cnf:
> >>> ndb-log-bin = 0
> >>> ndb-log-binlog-index = 0
> >>
> >>
> >> I could not find any documentation of these var's...
> >> Do they really disable cluster binlog? If not, how can I do that?
> >>
> >> Regards,
> >> Robert
> >>
> >> --
> >> MySQL Cluster Mailing List
> >> For list archives: http://lists.mysql.com/cluster
> >> To unsubscribe:
> >> http://lists.mysql.com/cluster?unsub=1
> >
