Ask Your Question
0

Keystone database size

asked 2014-01-13 09:15:33 -0500

Y Sertdemir gravatar image

updated 2014-01-13 10:00:02 -0500

larsks gravatar image

Hello,

My little grizzly openstack environment has a keystone database with more than 400 gb size. Is it logical? Other services databases are really small.

+--------------------+---------------+
| DB Name            | DB Size in MB |
+--------------------+---------------+
| cinder             |           0.5 |
| glance             |           0.3 |
| information_schema |           0.0 |
| keystone           |         459.5 |
| mysql              |           0.7 |
| nova               |           3.7 |
| performance_schema |           0.0 |
| quantum            |           0.8 |
+--------------------+---------------+
edit retag flag offensive close merge delete

Comments

You're off by a factor of 1024. That says 459 MB, not 459 GB.

larsks gravatar imagelarsks ( 2014-01-13 10:00:45 -0500 )edit

1 answer

Sort by ยป oldest newest most voted
0

answered 2014-01-13 11:21:14 -0500

There is a problem with networking service that request every 1-2 second a new token to keystone. If you access to keystone DB you can view that the big table is "tokens".

There are two solutions for resolve this issue:

  1. Use ADMIN_TOKEN for quantum service
    You have to edit _/etc/quantum/api-paste.ini_, remove admin_user admin_tenant_name and admin_password and add admin_token=your_admin_token
  2. Add a script that cleanup expired tokens
    http://www.sebastien-han.fr/blog/2012/12/12/cleanup-keystone-tokens/

Bye.

edit flag offensive delete link more

Comments

Is it the same problem continue with neutron ?

dheeru gravatar imagedheeru ( 2014-01-28 05:23:03 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-01-13 09:15:33 -0500

Seen: 1,402 times

Last updated: Jan 28 '14