Hi all, While setting a new ACS installation using centos6.6 and 4.4.2 (I have several fully functioning ones running ubuntu12.04 + 4.3.0) I'm finding out that filtering VMs with tags hangs the mysql database.
Whenever an API query like this is run: apiKey=REDACTED&command=listVirtualMachines&isrecursive=true&listall=true&response=json&tags[0].key=chef_env&tags[0].value=fqa1&zoneid=30c4a514-402c-4413-a3fc-c65450a98f55&signature=REDACTED a query in the database like this is seen: SELECT DISTINCT(user_vm_view.id) FROM user_vm_view WHERE user_vm_view.account_type != 5 AND user_vm_view.state != 'Destroyed' AND user_vm_view.display_vm = 1 AND ( ( user_vm_view.tag_key = _binary'chef_env' AND user_vm_view.tag_value = _binary'fqa1' ) ) AND user_vm_view.removed IS NULL ORDER BY user_vm_view.id ASC LIMIT 0, 500 ; This should return 2 items, and doing this query manually with around 5 of the where constrictions returns the values in less than a second. Running the command above might take from 4 minutes to several days and it takes 100% of a core. Running a listall VMs without any kind of restrictions shows the 4 user VMs in milliseconds. Is there anything specific to tags that might slow down this kind of query? Thanks Carles Figuerola
