title: Query is very very slow on MariaDB
body: <p>I am facing this issue since I started to use MariaDB 10 . Queries are taking too much time. With MySql 5.5 they were taking at most one minute to get the result set but with MariaDB I can not even see the result set after 20 minutes. </p>
  
  <p>This system runs on Magento 1.7.0.2 but this problem has nothing to do with Magento so I didn't create it under Magento section. </p>
  
  <p>My server administrator says that "everything is fine on server, queries are running on ram and cpu is 100% when ever this query starts running, if you want to improve it you need to change the query or increase the cpu power.". But I am pretty sure this is related to MariaDB and/or Database server settings.</p>
  
  <p>If there is any one who have faced such an issue before please guide me through the right path to follow.</p>
  
  <p>This is one of the biggest Queries that should run to get data for creating a feed. </p>
  
  <pre><code>SELECT `e`.*, `at_status`.`value` AS `status`, `at_visibility`.`value` AS      
  `visibility`, `at_quality_score`.`value` AS `quality_score`,    
  `at_exportable_for_idealo`.`value` AS `exportable`, 
  `stock`.`qty`, `stock`.`is_in_stock`, `stock`.`manage_stock`, 
  `stock`.`use_config_manage_stock`, `stock`.`min_qty`, 
  `stock`.`min_sale_qty`, MAX(DISTINCT request_path) AS `request_path`, 
  `cpsl`.`parent_id`, `categories`.*, `categories_parent`.*, 
  GROUP_CONCAT(DISTINCT categories_index.category_id) AS `categories_ids`, 
  `price_index`.`min_price`, `price_index`.`max_price`, 
  `price_index`.`tier_price`, `price_index`.`final_price` FROM 
  `catalog_product_entity` AS `e`
  
  INNER JOIN `catalog_product_website` AS `product_website` ON      
  product_website.product_id = e.entity_id AND product_website.website_id =     
  '1'
  
  INNER JOIN `catalog_product_entity_int` AS `at_status` ON 
  (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` 
  = '96') AND (`at_status`.`store_id` = 0)
  
  INNER JOIN `catalog_product_entity_int` AS `at_visibility` ON 
  (`at_visibility`.`entity_id` = `e`.`entity_id`) AND 
  (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 
  0)
  
  INNER JOIN `catalog_product_entity_varchar` AS `at_quality_score` ON 
  (`at_quality_score`.`entity_id` = `e`.`entity_id`) AND 
  (`at_quality_score`.`attribute_id` = '313') AND 
  (`at_quality_score`.`store_id` = 0)
  
  INNER JOIN `catalog_product_entity_int` AS `at_exportable_for_idealo` ON 
  (`at_exportable_for_idealo`.`entity_id` = `e`.`entity_id`) AND 
  (`at_exportable_for_idealo`.`attribute_id` = '353') AND 
  (`at_exportable_for_idealo`.`store_id` = 0)
  
  LEFT JOIN `cataloginventory_stock_item` AS `stock` ON 
  stock.product_id=e.entity_id
  
  LEFT JOIN `core_url_rewrite` AS `url` ON url.product_id=e.entity_id AND 
  url.target_path NOT LIKE '%category%' AND is_system=1 AND ISNULL(options) 
  AND url.store_id=1
  
  LEFT JOIN `catalog_product_super_link` AS `cpsl` ON 
  cpsl.product_id=e.entity_id 
  
  LEFT JOIN `catalog_category_product` AS `categories` ON 
  categories.product_id=e.entity_id
  
  LEFT JOIN `catalog_category_product` AS `categories_parent` ON 
  categories_parent.product_id=cpsl.parent_id
  
  LEFT JOIN `catalog_category_product_index` AS `categories_index` ON 
  ((categories_index.category_id=categories.category_id AND 
  categories_index.product_id=categories.product_id) OR 
  (categories_index.category_id=categories_parent.category_id AND 
  categories_index.product_id=categories_parent.product_id )) AND 
  categories_index.store_id=1
  
  LEFT JOIN `catalog_product_index_price` AS `price_index` ON 
  price_index.entity_id=e.entity_id AND customer_group_id=0 AND 
  price_index.website_id=1 WHERE (at_status.value = '1') AND (`e`.`type_id` 
  IN('simple')) AND (at_visibility.value IN('1')) AND (`e`.`attribute_set_id` 
  IN('19', '13', '4')) AND ((at_quality_score.value = 'A')) AND 
  ((at_status.value = '1')) AND ((at_exportable_for_idealo.value = '1'))
  </code></pre>
  
  <p>As said I can not see the result even after 20 minutes! No exceptions thrown, no sql error logs, no php error logs, nothing. Even if I run it directly on PhpMyAdmin the result is exactly same. </p>
  
  <p>Thanks in advance.</p>