Juju Charms Collection
percona-cluster package

  1. Bug #1402586
  2. Comment #3

Comment 3 for bug 1402586

Revision history for this message
Mario Splivalo (mariosplivalo) wrote :

Nobuto, do you have any tests to prove that table_cache needs to be larger?

Can you provide output of 'mysqladmin status' from a busy/large OpenStack deployment? Also, I'd be intereste in output of this command:

SHOW GLOBAL STATUS LIKE 'Opened_tables';

possibly repeated few times with 5-10 minutes of delay.

While 512 may seem low, default can safely be set to 4k or even 8k, but rarely need to go over it. There is usually less than 300 tables in typical OpenStack deployment, therefore 512 should be ok.