Audit events ( /v2/events )

[Mark Kropf]

Dear Loving Community,

We are searching for a method of improving /v2/events performance by adding an index that was missed when the feature was originally implemented. As a part of this work, we've come across a series of very inconvenient constraints that is driving us to truncate the `events` table prior to performing this migration. Thus far the use of this table is very limited with cli support just recently being added.

If the data in the `events` table of the ccdb is important to you, you will need to export it prior to deploying v176. 

Mark

[Doug Davis]

Hi Mark,
  this would seem to imply that the data that's causing an issue (and will be dropped) is data that will no longer be generated in the future since it would violate those constraints - do I have the right?  If so, what kind of data is no longer going to be generated?  We have tooling that uses that data in the events tables so I'd like to know if we're going to be negatively impacted by this data no longer being available us.

thanks
-Doug
________________________________________________________
STSM |  Standards Architect  |  IBM Software Group
(919) 254-6905  |  IBM 444-6905  |  d...@us.ibm.com
The more I'm around some people, the more I like my dog.

Mark Kropf ---07/17/2014 01:45:05 PM---Dear Loving Community, We are searching for a method of improving /v2/events performance by adding

--
You received this message because you are subscribed to the Google Groups "Cloud Foundry Developers" group.
To view this discussion on the web visit https://groups.google.com/a/cloudfoundry.org/d/msgid/vcap-dev/96ab4b43-9dd3-4fb1-92cb-2772f6b173ac%40cloudfoundry.org.

To unsubscribe from this group and stop receiving emails from it, send an email to vcap-dev+u...@cloudfoundry.org.

[James Bayer]

no, the problem is simply that the data in this table is too big to create an index on it in large systems like bluemix or PWS without incurring timeouts and issues with availability. ibm was involved in this analysis, you can contact alex t if you need more details. 

To view this discussion on the web visit https://groups.google.com/a/cloudfoundry.org/d/msgid/vcap-dev/OF36D6520D.261CC035-ON85257D18.006B543D-85257D18.006B9C07%40us.ibm.com.

To unsubscribe from this group and stop receiving emails from it, send an email to vcap-dev+u...@cloudfoundry.org.

--

Thank you,

James Bayer