View Source EctoMySQLExtras.TableCache (Ecto MySQL Extras v0.6.2)

InnoDB waits for redolog.

Table cache ratio.

  • cache_ratio: The ratio of table cache usage for all threads. A good value should be less than 80%. Increase the table_open_cache variable until the percentage reaches a good value.
  • hit_ratio: The ratio of table cache hit usage. A good hit ratio value should be 90% and above. Otherwise, increase the table_open_cache variable until the hit ratio reaches a good value.

Data is retrieved from the performance_schema or information_schema database and the global_status table.

Summary

Functions

Callback implementation for EctoMySQLExtras.info/0.

Callback implementation for EctoMySQLExtras.query/1.

Functions

Callback implementation for EctoMySQLExtras.info/0.

Callback implementation for EctoMySQLExtras.query/1.