*statements you don't want logged*
On Mon, Feb 8, 2010 at 4:40 PM, Aodhan Cullen <aodhan@stripped> wrote:
> Hi Folks,
> For our application we use a lot of CREATE TEMPORARY TABLE statements to
> generate temporary reports. We never use a temporary table to insert or
> update data in another table.
> However all our CREATE TEMPORARY TABLE statements get recorded to the
> log, which gives our slaves a problem with catching up. They execute all
> these statements and there is no need to do so. They could simply ignore
> We get around this normally by sending the CREATE TEMPORARY TABLE
> to the slave, so they never go to the master (and never end up in the
> log then). The problem is when we only have one copy on the master, and the
> slave is getting in sync the master's binary log gets filled up with these
> unnecessary statements.
> My question is there a way I can stop all CREATE TEMPORARY TABLE statements
> from being logged to the binary log?
> Many thanks for your time on this.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel