Skip to main content
Tweeted twitter.com/StackDBAs/status/1594616620454154240
edited title
Link
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

How do you tune MySqlMySQL for a heavy InnoDB workload?

typo
Link
Riedsio
  • 1.4k
  • 1
  • 14
  • 18

How do you tune MySqLMySql for a heavy InnoDB workload?

Source Link
Riedsio
  • 1.4k
  • 1
  • 14
  • 18

How do you tune MySqL for a heavy InnoDB workload?

Assuming a production OLTP system with predominantly InnoDB tables

  • What are the common symptoms of a mistuned/misconfigured system?
  • What configuration parameters do you most commonly change from their defaults?
  • How do you spot potential bottlenecks before there is a problem?
  • How do you recognize and troubleshoot active problems?

Any anecdotes detailing specific status variables and diagnostics would be appreciated.