I see the same on latest 4.5.1 rc. Erik
Den torsdag 30. april 2015 skrev Carles Figuerola <carle...@gmail.com> følgende: > Yes, I was trying different configurations and it has worked when using > mysql-5.5 on ubuntu and mysql-5.6 on centos. Maybe it did get fixed on ACS > 4.5.1 as my test environment was with CentOS 6.6 and the default mysql > version which is mysql-server-5.1.73-3.el6_5.x86_64. I tried reinstalling > different version on the 4.4 branch and all of them exhibited this problem > in this mysql version. > > Thanks, > > Carles > > On Tue, Apr 28, 2015 at 11:32 AM, ilya <ilya.mailing.li...@gmail.com > <javascript:;>> wrote: > > > No such issues when i ran this query against my test env, however i dont > > have the same tags in db so i received blank response.. My test env is > ACS > > 4.5.1 with MySQL 5.1.73 on CentOS 6.6+ > > > > Try dumping your DB and importing it to another host with newer mysql and > > run there. Perhaps mysql bug? > > > > > > On 4/22/15 9:17 PM, Carles Figuerola wrote: > > > >> 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 > >> > >> > > >
