“No Bugs” Bunny
Real-World 802.11ac Wi-Fi Testing: 7x6 Routers-x-Adapters Matrix. Part I. Routers.
November 7, 2017 by • “No Bugs” Bunny
Quote:
"Whatever throughput numbers are promised by router manufacturers, in real world should be divided by the factor of 2.5x-5x
Another Quote:
"Each router was tested with each of the cards/adapters, which gives us 42 tests on 2.4GHz band and 42 tests on 5GHz
Filed under: On.HardwareWi-Fi
Read moreOLTP Database Optimization 102 – DIY Heterogeneous Replication (Part II)
October 31, 2017 by • “No Bugs” Bunny
Quote:
The point of Super-Replica is that it is a replica Slave DB which is larger than original Master DB
Another Quote:
this “don’t write some HISTORICAL data to Master DB” approach can easily allow to reduce the load on the Master OLTP DB by a factor of 2x-3x
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations
Read moreOLTP Optimization 102: DYI Heterogeneous Replication. Part I (Basics)
October 24, 2017 by • “No Bugs” Bunny
Quote:
there are still several Big Fat Reasons™ to use DIY replicas
Another Quote:
With the Replication Messages described above, it is ok to apply Replication Messages to Slave DB which is newer than exactly necessary.
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations
Read moreOLTP DB Optimizations 102 – Group Commits
October 17, 2017 by • “No Bugs” Bunny
Quote:
if we can commit several transactions at the same time – RDBMS needs to fsync() our DB logs to physical disks only once
Another Quote:
if going our preferred way of single-writing-DB connection – make sure NOT to use RDBMS-level Group Commit
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations
Read more





