95 reputation
110
bio website blog.shlomoid.com
location Israel
age 31
visits member for 3 years, 7 months
seen Feb 26 '13 at 0:25

Apr
10
awarded  Popular Question
Apr
4
awarded  Popular Question
Jan
11
awarded  Notable Question
Apr
16
awarded  Popular Question
Aug
7
comment Recommended page file size for SQL 2008R2 on Windows 2008R2
Very interesting... How does it work then when you set a swap file smaller than the RAM in the machine? If indeed we need to reserve the space in the pagefile for every memory allocation, we wouldn't be able to use more than the page file size's worth of memory? I am not sure this is how it works in practice.
Aug
7
comment Is MySQL Replication Affected by a High-Latency Interconnect?
Yes, of course we are using MySQL 5.5, but this is not the default replication type. You need to go through a whole configuration procedure, install plugins and such, to get it working in the semi-synchronous way.
Aug
6
comment Is MySQL Replication Affected by a High-Latency Interconnect?
Also, we're using the default asynchronous replication in MySQL, not the asynchronous type - which needs to be enabled on purpose by installing plugins and the likes. What I'm trying to understand is whether events are piped net-cat style into the slave from the starting position in the log, or is there back and forth exchange between the master and slave for each event, which could suffer from such latency.
Aug
6
comment Is MySQL Replication Affected by a High-Latency Interconnect?
I am not sure about the last stage of the asynchronous replication - I don't think the master knows how far every slave has come. They can ask for any part of the binary log they want, as far as I know - do you have some reference for this?
Aug
5
comment Is MySQL Replication Affected by a High-Latency Interconnect?
Yep... It goes up and down throughout the day.
Aug
4
awarded  Student
Aug
4
asked Is MySQL Replication Affected by a High-Latency Interconnect?
Jul
21
comment MySQL Slave lag in SHOW SLAVE STATUS does not match SHOW PROCESSLIST
"How long ago did this query start on the Master" actually makes the best sense... Thanks for clearing it up. Is there a documentation somewhere pointing to it as well? Because I couldn't find any...
Jul
20
accepted MySQL Slave lag in SHOW SLAVE STATUS does not match SHOW PROCESSLIST
Jul
19
awarded  Supporter
Jul
19
awarded  Editor
Jul
19
awarded  Citizen Patrol
Jul
19
revised SQL Server 2005, Large Binary Storage
added 22 characters in body
Jul
18
awarded  Teacher
Jul
18
awarded  Commentator
Jul
18
comment MySQL Slave lag in SHOW SLAVE STATUS does not match SHOW PROCESSLIST
@RolandoMySQLDBA let us continue this discussion in chat