Ask Your Question
0

Performance problem with keystone tokens.

asked 2013-08-28 12:04:39 -0500

tongda gravatar image

I built a testing environment with a controller(4 cores, 8GB RAM, installing kestone, glance, quantum-server, cinder, nova-api), a database server(4 cores, 8GB RAM, installing mysql), a network node(4 cores, 8GB RAM, installing quantum agents), and 5 compute nodes(4x2 cores, 96GB RAM). Databases of all modules are installed on the database server.

When openstack has been running for some days, the latency of dashboard response becomes longer and longer. After checking the softwares, I found that the bottleneck was the database. The I found that, every "SELECT ... FROM token" would take more than 7 seconds. The "SELECT count(*) from token;" returns more than 170,000 records. I think this is the key point of the performance problem.

I tried to delete the expired tokens and the latency shortened. But this is not the solution. So is this a bug or not? I think more than 1 million tokens is very normal in the practical environment, but the performance is unbearable.

What should I do to speed it up?

edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted
0

answered 2013-08-28 12:26:26 -0500

tongda gravatar image

Thanks Tiantian Gao, that solved my question.

edit flag offensive delete link more
0

answered 2013-08-28 12:11:24 -0500

gtt116 gravatar image

Hi Tong,

I suggest using memcache rather than mysql to store token. The guide to config keystone to using memcache is here: http://pic.dhe.ibm.com/infocenter/tivihelp/v48r1/index.jsp?topic=%2Fcom.ibm.sco.doc_2.2%2Ft_memcached_keystone.html (http://pic.dhe.ibm.com/infocenter/tiv...)

Hoping that help you.

regards, gtt

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2013-08-28 12:04:39 -0500

Seen: 80 times

Last updated: Aug 28 '13