Zapytania sql "zabijające" baze

[Gość DnL]

Hej, jak w temacie, mam pewne zapytania sql do bazy, które mi ją bardzo obciążają, co to za zapytania, od czego?

| 355931 | nedds_1  | ro11470.plusserver.de:51398 | nedds_1 | Query  |  48 | Sending data | SELECT p.*,t.*,m.member_group_id, m.mgroup_others,cca.* FROM ibf_posts p  LEFT JOIN ibf_topics t ON ( t.tid=p.topic_id )
LEFT JOIN ibf_members m ON ( m.member_id=p.author_id )
LEFT JOIN ibf_content_cache_posts cca ON ( cca.cache_content_id=p.pid )  WHERE  p.queued=0  AND  t.approved=1  AND p.author_id=647841 AND p.new_topic=0 AND t.forum_id IN (591,139,141,140,142,145,144,148,143,147,262,13,29 1,220,161,231,499,134,135,124,203,543,544,545,546, 202,265,548,125,438,12,264,439,458,459,460,461,463 ,464,465,466,467,468,509,252,253,254,255,266,258,2 57,256,428,214,217,215,216,267,306,158,159,164,160 ,166,165,173,174,175,127,248,547,592,569,17,204,19 ,476,221,224,226,245,230,228,212,440,441,249,238,5 55,251,250,389,581,434,400,401,435,357,384,273,550 ,289,436,437,515,482,402,403,404,407,408,351,213,2 60,211,462,431,432,427,433,259,429,241,243,532,445 ,447,448,449,450,451,452,453,454,455,296,295,305,3 82,2,263,595,593,206,232,493,205,9,549,385,239,233 ,130,276,352,483,364,516,278,517,16,4,5,22,531,534 ,553,304,303,298,444,353,354,355,442,443,383,456,3 88,386,395,396,397,398,399,571,572,573,574,469,279 ,155,156,153,157,21,275,484,488,485,487,507,508,51 8,519,520,541,561,522,529,530,528,539,536,537,538, 540,575,566,565)  AND p.post_date > 1282842090 ORDER BY p.pid DESC LIMIT 0,5 |

[OmegaOne]

Wygląda mi to na ostatnie 5 postów usera o id 647841. Do tego jest dołączane info o temacie, grupie i cache.

Zobacz sobie w acp w narzędziach sql czy masz poprawne indexy na tabelach.

[Gość DnL]

Teraz takie coś zapycha:

| 456294 | nedds_1  | ro11470.plusserver.de:56793 | nedds_1 | Query  |  233 | Sending data | SELECT p.*,t.*,m.member_group_id, m.mgroup_others,cca.* FROM ibf_posts p  LEFT JOIN ibf_topics t ON ( t.tid=p.topic_id )
LEFT JOIN ibf_members m ON ( m.member_id=p.author_id )
LEFT JOIN ibf_content_cache_posts cca ON ( cca.cache_content_id=p.pid )  WHERE  p.queued=0  AND  t.approved=1  AND p.author_id=660470 AND p.new_topic=0 AND t.forum_id IN (591,139,141,140,142,145,144,148,143,147,262,13,29 1,220,161,231,499,134,135,124,203,543,544,545,546, 202,265,548,125,438,12,264,439,458,459,460,461,463 ,464,465,466,467,468,509,252,253,254,255,266,258,2 57,256,428,214,217,215,216,267,306,158,159,164,160 ,166,165,173,174,175,127,248,547,592,569,17,204,19 ,476,221,224,226,245,230,228,212,440,441,249,238,5 55,251,250,389,581,434,400,401,435,357,384,273,550 ,289,436,437,515,482,402,403,404,407,408,351,213,2 60,211,462,431,432,427,433,259,429,241,243,532,445 ,447,448,449,450,451,452,453,454,455,296,295,305,3 82,2,263,595,593,206,232,493,205,9,549,385,239,233 ,130,276,352,483,364,516,278,517,16,4,5,22,531,534 ,553,304,303,298,444,353,354,355,442,443,383,456,3 88,386,395,396,397,398,399,571,572,573,574,469,279 ,155,156,153,157,21,275,484,488,485,487,507,508,51 8,519,520,541,561,522,529,530,528,539,536,537,538, 540,575,566,565)  AND p.post_date > 1282860493 ORDER BY p.pid DESC LIMIT 0,5 |

[DawPi]

Normalne zapytania forum.

[Gość DnL]

nie wiem, kloc do mnie wypisuje, że obciążają, ale okej.