Tickets :: Comment on [#6633] Performance query MYSQL

* Your Email Address
* Spam protection	Enter the letters below: __.. . ..__ .__. (__ \| \|__\|[__)[__] .__)\|___\| \|\| \\| \|
Comment	> Hi we have some problem with a query: > > > > SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN > horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE > c.group_uid = 'horde.shares.kronolith' AND ( a1.attribute_name = > 'owner' AND a1.attribute_value = 'marco.curradi' ) GROUP BY > c.datatree_id, c.datatree_name, c.datatree_order ORDER BY > c.datatree_order, c.datatree_name, c.datatree_id; > > > > This query use the CPU at the 100%. > > > > We have this problem only the users connection are about 20-30 or more. > > This query use the disk and if running 3-4 this query the process of > Mysql use the 100% of CPU. > > This query find 1 record but move 15000 record on temp (see the attachment). > > I think the problem is the ORDER BY. Is necessary to use ORDER BY ? > > > > thanks for your help > >
Attachment
Watch this ticket