Hello Pierre and all I can confirm that the plan was to deprecate v1 storage :) Thanks for the work you are doing on CK ! Cheers Christophe On Fri, Jul 23, 2021 at 10:18 PM Pierre Riteau <pierre@stackhpc.com> wrote:

Hello Thomas,

Storing data frames in SQL is only supported by the v1 storage interface: https://docs.openstack.org/cloudkitty/latest/admin/configuration/storage.htm... The v2 storage interface introduced InfluxDB and Elasticsearch as replacement.

I believe the plans of the previous core team was to deprecate v1 storage [1], so I am not sure we'll want to put lots of effort in supporting it. However feel free to propose a patch, if it's trivial enough I don't see why we wouldn't merge it.

[1] https://docs.openstack.org/releasenotes/cloudkitty/stein.html#new-features

On Fri, 23 Jul 2021 at 16:25, Thomas Goirand <zigo@debian.org> wrote:

...

Hi,

Very fast, with only a few resources, the rated_data_frames tables becomes huge.

I was very surprised to see there's absolutely zero index in this table. Isn't a "openstack rating dataframes get" querying this table, with tenant_id and begin / end as filters? Wouldn't the API calls be a lot more efficient with such indexes?

Cheers,

Thomas Goirand (zigo)

-- ---- Christophe Sauthier Directeur Général Objectif Libre : Au service de votre Cloud +33 (0) 6 16 98 63 96 | christophe.sauthier@objectif-libre.com https://www.objectif-libre.com | @objectiflibre Recevez la Pause Cloud Et DevOps : https://olib.re/abo-pause