CP text search is very very slow

You acted on one side of the problem: you gave more resources to the server. I'm in no position to tell if that's enough.
Your priority should be reducing the load imposed by that monster query.

BTW: that query doesn't look like a 'text search' at all. There's no trace of the text being searched.

hi,

Thanks for your response, running a new text search query freezing our server again
it was running for more then 2 minutes, until we had to restart mysql service server was freezing

can you please check it, and helping us to solve the problem? we are ready to provide all the info you need.

SET timestamp=1327341153;
SELECT DISTINCT 'content' AS content_element ,c.id AS id,c.title AS title,c.alias AS title_alias,c.catid AS catid ,c.introtext AS introtext,CONCAT('index.php?option=com_content&view=article','&catid=', c.catid,':',cat.alias, '&id=', c.id,':',c.alias) AS href,c.created AS created,c.`fulltext` AS `fulltext`,c.images AS images,c.ordering AS ordering,cat.title AS category ,cat.alias AS cat_alias ,cat.lft AS cat_ordering ,c.publish_up AS publish_up,c.publish_down AS publish_down
FROM fdos_content AS c
LEFT JOIN fdos_categories AS cat ON(c.catid = cat.id)
INNER JOIN fdos_custom_properties AS cp0
ON(c.id = cp0.content_id)
INNER JOIN fdos_custom_properties_values AS v0
ON (cp0.value_id = v0.id )
INNER JOIN fdos_custom_properties_fields AS f0
ON (v0.field_id = f0.id )
INNER JOIN fdos_custom_properties AS cp1
ON(c.id = cp1.content_id)
INNER JOIN fdos_custom_properties_values AS v1
ON (cp1.value_id = v1.id )
INNER JOIN fdos_custom_properties_fields AS f1
ON (v1.field_id = f1.id )
INNER JOIN fdos_custom_properties AS cp2
ON(c.id = cp2.content_id)
INNER JOIN fdos_custom_properties_values AS v2
ON (cp2.value_id = v2.id )
INNER JOIN fdos_custom_properties_fields AS f2
ON (v2.field_id = f2.id )
INNER JOIN fdos_custom_properties AS cp3
ON(c.id = cp3.content_id)
INNER JOIN fdos_custom_properties_values AS v3
ON (cp3.value_id = v3.id )
INNER JOIN fdos_custom_properties_fields AS f3
ON (v3.field_id = f3.id )
INNER JOIN fdos_custom_properties AS cp4
ON(c.id = cp4.content_id)
INNER JOIN fdos_custom_properties_values AS v4
ON (cp4.value_id = v4.id )
INNER JOIN fdos_custom_properties_fields AS f4
ON (v4.field_id = f4.id )
INNER JOIN fdos_custom_properties AS cp5
ON(c.id = cp5.content_id)
INNER JOIN fdos_custom_properties_values AS v5
ON (cp5.value_id = v5.id )
INNER JOIN fdos_custom_properties_fields AS f5
ON (v5.field_id = f5.id )
INNER JOIN fdos_custom_properties AS cp6
ON(c.id = cp6.content_id)
INNER JOIN fdos_custom_properties_values AS v6
ON (cp6.value_id = v6.id )
INNER JOIN fdos_custom_properties_fields AS f6
ON (v6.field_id = f6.id )
INNER JOIN fdos_custom_properties AS cp7
ON(c.id = cp7.content_id)
INNER JOIN fdos_custom_properties_values AS v7
ON (cp7.value_id = v7.id )
INNER JOIN fdos_custom_properties_fields AS f7
ON (v7.field_id = f7.id )
WHERE (cat.published = '1' OR cat.published IS NULL)
AND (c.state >= '1')
AND cp0.ref_table = 'content'
AND cp1.ref_table = 'content'
AND cp2.ref_table = 'content'
AND cp3.ref_table = 'content'
AND cp4.ref_table = 'content'
AND cp5.ref_table = 'content'
AND cp6.ref_table = 'content'
AND cp7.ref_table = 'content'
AND
CONCAT(c.title,' ', c.introtext,' ', c.`fulltext`) LIKE '%iraq%'

AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2012-01-23 17:50:54' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2012-01-23 17:50:54' )
AND c.catid IN (7,14,15,8,9,10,12,11)
ORDER BY c.created DESC;
/usr/libexec/mysqld, Version: 5.5.19-cll (MySQL Community Server

Thanks,

Thanks for this info. You'll soor receive an email to continue the troubleshooting process.