Consumming to much memory

  • I have a big problem, i have a VDS vith 2 giga of ram,
    can anny body help me to resolve the problem

    My host say :

    The mysql server I found the below. Until you optimize these queries as we do not help. Any php optimizer will not solve the problem. The current problem is your mysql queries. The need to optimize them.

    How can i optimize that… i instal wp-optimizer.. and others but nothing happened…

    2398 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 67   | Creating tmp table   | SELECT t.*, tt.* FROM wp_terms AS t INNER               JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |

| 2407 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 64   | Creating tmp table   | SELECT t.*, tt.* FROM wp_terms AS t INNER               JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |

| 2449 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 67   | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FRO              M wp_posts  INNER JOIN wp_term_relationships ON (wp_posts. |

| 2448 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 47   | Creating tmp table   | SELECT t.*, tt.* FROM wp_terms AS t INNER               JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |

| 2451 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 17   | Creating tmp table   | SELECT DISTINCT p.ID, p.post_title, p.post              _name, p.post_type, '' as post_permalink FROM wp_posts p W |

| 2455 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 19   | Sending data         | SELECT p.* FROM wp_posts AS p  WHERE p.pos              t_date < '2010-10-26 05:20:58' AND p.post_type = 'post' AN |

| 2456 | tata_front     | localhost | tata_front       | Query   | 45   | Creating tmp table   | SELECT *    FROM wp_links  INNER JOIN wp_t              erm_relationships AS tr ON (wp_links.link_id = tr.object_i |

| 2458 | tata_front     | localhost | tata_front       | Sleep   | 4    |                      |                                                                                                                    |

| 2459 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 67   | Sorting result       | SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FRO              M wp_posts  INNER JOIN wp_term_relationships ON (wp_posts. |

| 2460 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 67   | removing tmp table   | SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FRO              M wp_posts  INNER JOIN wp_term_relationships ON (wp_posts. |

| 2462 | tata_front     | localhost | tata_front       | Sleep   | 4    |                      |                                                                                                                    |

| 2466 | tata_front     | localhost | tata_front       | Sleep   | 4    |                      |                                                                                                                    |

| 2468 | tata_front     | localhost | tata_front       | Sleep   | 2    |                      |                                                                                                                    |

| 2471 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 39   | Creating tmp table   | SELECT t.*, tt.* FROM wp_terms AS t INNER               JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |

| 2472 | divizia_frxnou | localhost | divizia_frxnou   | Query   | 20   | Creating tmp table   | SELECT DISTINCT object_id as ID, post_titl              e FROM wp_term_relationships r, wp_term_taxonomy t, wp_pos |

| 2474 | divizia_frxnou | localhost | divizia_frxnou   | Sleep   | 8    |                      |                                                                                                                    |

| 2475 | tata_front     | localhost | tata_front       | Sleep   | 4    |                      |                                                                                                                    |

| 2476 | roimdb_imdb    | localhost | roimdb_filmeimdb | Query   | 1    | Opening tables       | SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FRO              M wp_posts  INNER JOIN wp_term_relationships ON (wp_posts. |

| 2478 | tata_front     | localhost | tata_front       | Query   | 30   | Sending data         | SELECT option_name, option_value FROM wp_o              ptions WHERE autoload = 'yes'                              |

| 2479 | tata_front     | localhost | tata_front       | Query   | 24   | Sending data         | SELECT option_name, option_value FROM wp_o              ptions WHERE autoload = 'yes'                              |

| 2481 | tata_front     | localhost | tata_front       | Query   | 17   | Sending data         | SELECT option_name, option_value FROM wp_o              ptions WHERE autoload = 'yes'
  • The topic ‘Consumming to much memory’ is closed to new replies.