network profile
| bio | website | blog.shlomoid.com |
|---|---|---|
| location | Israel | |
| age | 30 | |
| visits | member for | 2 years, 4 months |
| seen | Feb 26 at 0:25 | |
| stats | profile views | 6 |
|
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 |
