sql slow queries
Hola, tengo un problema con mi sitio, en el servidor donde lo tengo alojado lo suspendi´´o porque tengo un script o consultas lentas, pues le comento que yengo mas de 1000 visitas diarias y consultas no tan complejas, pero de todas maneras tengo la carpeta /temp llena de logs de ese tipo. que me sugieren.
uno de los script log es:
# Mon Feb 16 07:14:42 2009
# Query_time: 12 Lock_time: 0 Rows_sent: 166 Rows_examined: 166
use biblored_portal;
SELECT *,
`TABLE_SCHEMA` AS `Db`,
`TABLE_NAME` AS `Name`,
`ENGINE` AS `Engine`,
`ENGINE` AS `Type`,
`VERSION` AS `Version`,
`ROW_FORMAT` AS `Row_format`,
`TABLE_ROWS` AS `Rows`,
`AVG_ROW_LENGTH` AS `Avg_row_length`,
`DATA_LENGTH` AS `Data_length`,
`MAX_DATA_LENGTH` AS `Max_data_length`,
`INDEX_LENGTH` AS `Index_length`,
`DATA_FREE` AS `Data_free`,
`AUTO_INCREMENT` AS `Auto_increment`,
`CREATE_TIME` AS `Create_time`,
`UPDATE_TIME` AS `Update_time`,
`CHECK_TIME` AS `Check_time`,
`TABLE_COLLATION` AS `Collation`,
`CHECKSUM` AS `Checksum`,
`CREATE_OPTIONS` AS `Create_options`,
`TABLE_COMMENT` AS `Comment`
FROM `information_schema`.`TABLES`
WHERE BINARY `TABLE_SCHEMA` IN ('biblored_portal')
LIMIT 250 OFFSET 0
# Mon Feb 16 07:30:53 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 3
use biblored_portal;
SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 5115
- Inicie sesión o regístrese para enviar comentarios
- 491 lecturas


Licenciado en todo
Seguramente estas usando un modulo contrib que tiene problemas de performance, averigua que modulo esta causando los slow querys