… fully correct. Here’s why: you can’t write an equation for it. The most popular equation, … enough. Staying with InnoDB, we also need to count the data dictionary. This can take many gigabytes …(but no bigger than max_allowed_packet). And keys for user locks! I set my max_allowed_packet bigger and …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk IO estimation. … min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 98 1753697 # Exec time 52 4337s 71us 466ms 2ms 12ms 7ms 176us # Lock time …
