Hi folks,
With the master Ceilometer installed, and use mysql backend, the
event-list command met a heavy time cost. if we have a bit large number
of events stored, it is easy to cause event list API request timeout,
the rally people told me that this issue has broken the
gate-rally-dsvm-rally job, see[1], there is a bug they reported to track
this[3]. As we konw, the admin roled uers can only query thire own
events(the project trait value can match the project id) and events
without project_id trait, this is implemented in event-rbac feature[2],
before this change, the job is OK. maybe we have mistake in sql query ?
I will dig more.
FYI, some testing infomation in my devstack environment:
root@szxbzci0007:/opt/stack/ceilometer# time ceilometer event-list |wc -l
109
real 0m51.780s
user 0m0.354s
sys 0m0.060s
mysql> select count(*) from event;
+----------+
| count(*) |
+----------+
| 1540 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from trait_text;
+----------+
| count(*) |
+----------+
| 3097 |
+----------+
1 row in set (0.01 sec)
[1]
http://logs.openstack.org/35/222435/1/check/gate-rally-dsvm-rally/aa38d0f/rally-plot/results.html.gz#/CeilometerEvents.create_user_and_get_event/failures
[1] https://review.openstack.org/#/c/218706/
[2] https://bugs.launchpad.net/ceilometer/+bug/1494440
Best regards
Liu sheng
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
