Tag Info

New answers tagged

2

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 ...


1

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