Results 1 to 1 of 1

Thread: any one running large classi press ? it crash mysql

  1. #1
    Thread Starter
    Veteran sonnycool's Avatar
    Join Date
    Mar 2009
    Location
    Malaysia
    Posts
    308
    Thanks
    32
    Thanked 2 Times in 2 Posts

    any one running large classi press ? it crash mysql

    anyone running large classipress site ?
    it seem like there is a lot issue on large site with reasonable daily post 300 - 500. but it create way too many quries on my server .....
    i have another log with 3000 quries waiting ....

    my site :
    20000 post.
    1.5gb mysql
    daily 300-500 new post.
    running on quad xeon with 8gb dedicated server and it crash my mysql

    server stacking up quries.
    | 1 | ipp_ppp | 14.192.211.122:2899 | ipp_ppp | Sleep | 218 | | NULL |
    | 20 | ipp_my1 | localhost | ipp_my1 | Query | 49 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 22 | ipp_my1 | localhost | ipp_my1 | Query | 43 | Waiting for table level lock | DELETE FROM ipp_postmeta WHERE meta_id IN( 1964784 ) |
    | 23 | ipp_my1 | localhost | ipp_my1 | Query | 50 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 24 | ipp_my1 | localhost | ipp_my1 | Query | 50 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 25 | ipp_my1 | localhost | ipp_my1 | Query | 49 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 26 | ipp_my1 | localhost | ipp_my1 | Query | 48 | Waiting for table level lock | UPDATE `ipp_posts` SET `guid` = 'http://my.ipushproperty.com/?p=308312' WHERE `ID` = 308312 |
    | 28 | da_admin | localhost | NULL | Query | 0 | NULL | show full processlist |
    | 29 | ipp_my1 | localhost | ipp_my1 | Query | 50 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 30 | ipp_my1 | localhost | ipp_my1 | Query | 49 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 31 | ipp_my1 | localhost | ipp_my1 | Query | 50 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 32 | ipp_my1 | localhost | ipp_my1 | Query | 49 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 33 | ipp_my1 | localhost | ipp_my1 | Query | 49 | Copying to tmp table | SELECT DISTINCT meta_value FROM ipp_postmeta m JOIN ipp_posts p ON m.post_id=p.id AND p.post_status='publish' WHERE meta_key='cp_state' |
    | 42 | ipp_my1 | localhost | ipp_my1 | Sleep | 44 | | NULL |
    | 45 | ipp_my1 | localhost | ipp_my1 | Query | 42 | Waiting for table level lock | SELECT ipp_posts.* FROM ipp_posts INNER JOIN ipp_postmeta ON ( ipp_posts.ID = ipp_postmeta.post_id ) WHERE 1=1 AND ipp_posts.post_type = 'page' AND ((ipp_posts.post_status = 'publish')) AND (
    ipp_postmeta.meta_key = '_wp_page_template'
    ) GROUP BY ipp_posts.ID ORDER BY ipp_posts.post_date DESC |
    | 46 | ipp_my1 | localhost | ipp_my1 | Query | 40 | Waiting for table level lock | SELECT ipp_posts.* FROM ipp_posts INNER JOIN ipp_postmeta ON ( ipp_posts.ID = ipp_postmeta.post_id ) WHERE 1=1 AND ipp_posts.post_type = 'page' AND ((ipp_posts.post_status = 'publish')) AND (
    ipp_postmeta.meta_key = '_wp_page_template'
    ) GROUP BY ipp_posts.ID ORDER BY ipp_posts.post_date DESC |
    | 47 | ipp_my1 | localhost | ipp_my1 | Query | 34 | Waiting for table level lock | SELECT ipp_posts.* FROM ipp_posts INNER JOIN ipp_postmeta ON ( ipp_posts.ID = ipp_postmeta.post_id ) WHERE 1=1 AND ipp_posts.post_type = 'page' AND ((ipp_posts.post_status = 'publish')) AND (
    ipp_postmeta.meta_key = '_wp_page_template'
    ) GROUP BY ipp_posts.ID ORDER BY ipp_posts.post_date DESC |
    | 48 | ipp_my1 | localhost | ipp_my1 | Query | 22 | Waiting for table level lock | SELECT ipp_posts.ID FROM ipp_posts INNER JOIN ipp_postmeta ON ( ipp_posts.ID = ipp_postmeta.post_id ) WHERE 1=1 AND ipp_posts.post_type = 'page' AND (ipp_posts.post_status = 'publish' OR ipp_posts.post_status = 'future' OR ipp_posts.post_status = 'draft' OR ipp_posts.post_status = 'pending' OR ipp_posts.post_status = 'private') AND (
    ( ipp_postmeta.meta_key = '_wp_page_template' AND CAST(ipp_postmeta.meta_value AS CHAR) = 'tpl-dashboard.php' )
    ) GROUP BY ipp_posts.ID ORDER BY ipp_posts.post_date DESC LIMIT 0, 1 |
    | 49 | ipp_my1 | localhost | ipp_my1 | Query | 12 | Waiting for table level lock | SELECT ipp_posts.* FROM ipp_posts INNER JOIN ipp_postmeta ON ( ipp_posts.ID = ipp_postmeta.post_id ) WHERE 1=1 AND ipp_posts.post_type = 'page' AND ((ipp_posts.post_status = 'publish')) AND (
    ipp_postmeta.meta_key = '_wp_page_template'
    ) GROUP BY ipp_posts.ID ORDER BY ipp_posts.post_date DESC |
    | 51 | ipp_my1 | localhost | ipp_my1 | Sleep | 5 | | NULL |
    | 52 | ipp_my1 | localhost | ipp_my1 | Query | 2 | Waiting for table level lock | SELECT ipp_posts.* FROM ipp_posts INNER JOIN ipp_postmeta ON ( ipp_posts.ID = ipp_postmeta.post_id ) WHERE 1=1 AND ipp_posts.post_type = 'page' AND ((ipp_posts.post_status = 'publish')) AND (
    ipp_postmeta.meta_key = '_wp_page_template'
    ) GROUP BY ipp_posts.ID ORDER BY ipp_posts.post_

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] classi-press 3.3 working with classi-estate ??
    By meltaylor in forum ClassiEstate
    Replies: 2
    Last Post: April 30th, 2013, 05:51 AM
  2. Is this one of WP CLassi Press THEME?
    By jjaafar in forum Report ClassiPress Bugs
    Replies: 1
    Last Post: July 20th, 2010, 04:54 AM