Thanks. This is the first time we enable innodb.
--- On Fri, 7/22/11, Johan De Meersman <vegivamp@stripped> wrote:
From: Johan De Meersman <vegivamp@stripped>
Subject: Re: Slave receives end packet from master
To: database100@stripped
Cc: "Rick James" <rjames@stripped>, "Replication"
<replication@stripped>, "Prabhat Kumar" <aim.prabhat@stripped>
Date: Friday, July 22, 2011, 9:24 AM
#yiv1353405399 p {margin:0;}
the ib_logfiles are not readable logfiles, they're part of the transaction system and are
preallocated fully; they won't grow with use.
From: "Database System" <database100@stripped>
To: "Prabhat Kumar" <aim.prabhat@stripped>
Cc: "Rick James" <rjames@stripped>, "Johan De Meersman"
<vegivamp@stripped>, "Replication" <replication@stripped>
Sent: Friday, 22 July, 2011 3:32:24 PM
Subject: Re: Slave receives end packet from master
Hi Prabhat,
You have a good point. But after I did that, it didn't help.
In my MySQL 5.0 servers, all the relay_log_space_limit =0, but replications work fine. Is
this something new, have to setup on 5.1? I looked 5.1 manual on setting up
replication, it doesn't mention to setup this variable. Do you know how to use it, is the
size for all the relay log files? or for each relay log file?
By the way, we haven't put data in innodb table yet, but why ib_logfile0 and ib_logfile1
size is very big already? How to read these file?
Thank you so much,
Lisa
--- On Thu, 7/21/11, Prabhat Kumar <aim.prabhat@stripped> wrote:
From: Prabhat Kumar <aim.prabhat@stripped>
Subject: Re: Slave receives end packet from master
To: database100@stripped
Cc: "Rick James" <rjames@stripped>, "Johan De Meersman"
<vegivamp@stripped>, "Replication" <replication@stripped>
Date: Thursday, July 21, 2011, 3:57 PM
try with increasing the 'relay_log_space_limit', might be if connections are made
everytime the slave thread pauses for more space to be freed up.
mysql> SHOW VARIABLES LIKE 'relay_log_space_limit';
Thanks,
On Thu, Jul 21, 2011 at 12:36 PM, Database System <database100@stripped> wrote:
I said that is not my case.
> Subject: Re: Slave receives end packet from master
> To: "Rick James" <rjames@stripped>
> Cc: database100@stripped, "Replication" <replication@stripped>
> Date: Thursday, July 21, 2011, 1:59 PM
> Ooh, that definitely stinks of a
> To unsubscribe: http://lists.mysql.com/replication?unsub=1
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
