Tag Info

New answers tagged


Strictly speaking the calculation of the recommended buffer pool size above is not correct. It assumes InnoDB works actively with all data. In practice, InnoDB could only touch a fraction of the database. Check how Innodb_buffer_pool_reads and Innodb_buffer_pool_read_requests changes over time. mysqladmin -r -i 1 ext | grep -e ...


There are no hard-and-fast rules for such Slaves. Let's look at two scenarios SCENARIO #1 Some standardize all DB Servers to have the same configuration. The rationale behind this is promote a Slave to a Master should have to fail over to it. SCENARIO #2 A scaled down Slave being used as a data backup. No reads from that Slave. COMPARISON OF SLAVES For ...

Top 50 recent answers are included