It is very slow (30 seconds) to open any pages including “Main Page”. Checking the processes in mysqld found the following sql statements for each page respectively. I guess `prop11`, `prop8`, `cats6` are temporary tables, which make it hard to tune these statements.

 

Does anyone know if these statements look alright? Your help are greatly appreciated.

 

SELECT  DISTINCT `page`.page_title as title, `page`.page_namespace as namespace, `page`.page_id as id  FROM `prop11`, `prop8`, `cats6`, `page` INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN `smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd12 ON rd12.rd_from=rel10.object_id  WHERE ((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND ((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND ((rel7.object_title='Main_Page' AND rel7.object_namespace=0) OR (rd9.rd_title='Main_Page' AND rd9.rd_namespace=0))) AND (prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid' AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND rd12.rd_namespace=0))))  LIMIT 51

 

SELECT  DISTINCT `page`.page_title as title, `page`.page_namespace as namespace, `page`.page_id as id  FROM `prop11`, `prop8`, `cats6`, `page` INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN `smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd12 ON rd12.rd_from=rel10.object_id  WHERE ((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND ((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND ((rel7.object_title='Monobook.css' AND rel7.object_namespace=0) OR (rd9.rd_title='Monobook.css' AND rd9.rd_namespace=0))) AND (prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid' AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND rd12.rd_namespace=0))))  LIMIT 51

 

SELECT  DISTINCT `page`.page_title as title, `page`.page_namespace as namespace, `page`.page_id as id  FROM `prop11`, `prop8`, `cats6`, `page` INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN `smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd12 ON rd12.rd_from=rel10.object_id  WHERE ((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND ((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND ((rel7.object_title='Protein_Clusters' AND rel7.object_namespace=0) OR (rd9.rd_title='Protein_Clusters' AND rd9.rd_namespace=0))) AND (prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid' AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND rd12.rd_namespace=0))))  LIMIT 51

 

SELECT  DISTINCT `page`.page_title as title, `page`.page_namespace as namespace, `page`.page_id as id  FROM `prop11`, `prop8`, `cats6`, `page` INNER JOIN `categorylinks` AS cl5 ON cl5.cl_from=`page`.page_id INNER JOIN `smw_relations` AS rel7 ON rel7.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd9 ON rd9.rd_from=rel7.object_id INNER JOIN `smw_relations` AS rel10 ON rel10.subject_id=`page`.page_id LEFT JOIN `redirect` AS rd12 ON rd12.rd_from=rel10.object_id  WHERE ((`page`.page_namespace='0') OR (`page`.page_namespace='6')) AND ((cats6.title=cl5.cl_to) AND (prop8.title=rel7.relation_title AND ((rel7.object_title='HSPP_Cluster:00000067' AND rel7.object_namespace=0) OR (rd9.rd_title='HSPP_Cluster:00000067' AND rd9.rd_namespace=0))) AND (prop11.title=rel10.relation_title AND ((rel10.object_title='Parotid' AND rel10.object_namespace=0) OR (rd12.rd_title='Parotid' AND rd12.rd_namespace=0))))  LIMIT 51