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

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_