logs and file details report
Posted by: mrugesh shah
Date: December 23, 2008 11:37PM
Date: December 23, 2008 11:37PM
hello,
Actually the problem is not in CPU usage, the problem is in "system usage" on VPS. After you told me to write slow_querty time etc.... now, it is taking 7 hours (insted of 4) to get 100%, so something positive thing has happen. but still not fully solved.
Yes, My slow query log is working and it contains lots of data. following is its file content :
=========================================================
/usr/sbin/mysqld, Version: 5.0.51a-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 081223 13:15:07
# User@Host: readguja[readguja] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 25826 Rows_examined: 25826
SELECT * FROM `readguja_sahitya`.`wp_comments`;
# Time: 081223 13:16:22
# User@Host: readguja[readguja] @ localhost []
# Query_time: 52 Lock_time: 0 Rows_sent: 25826 Rows_examined: 25826
SELECT * FROM `readguja_sahitya`.`wp_comments`;
# Time: 081223 13:20:22
# User@Host: readguja[readguja] @ localhost []
# Query_time: 238 Lock_time: 0 Rows_sent: 2940 Rows_examined: 2940
SELECT * FROM `readguja_sahitya`.`wp_posts`;
# Time: 081223 13:29:10
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
use readguja_sahitya;
DESC wp_comments;
# Time: 081223 13:30:09
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# Time: 081223 13:31:33
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# Time: 081223 13:32:11
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=08 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 13:32:18
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=03 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 13:32:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 30 Rows_examined: 2209
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '09'
AND YEAR(post_date) = '2007'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 00:02:16';
# Time: 081223 13:52:24
# User@Host: readguja_suser[readguja_suser] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
use readguja_support;
SELECT * FROM wp_users WHERE user_login = 'VenFliednep';
# Time: 081223 14:05:09
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
use readguja_sahitya;
DESC wp_comments;
# Time: 081223 14:06:31
# User@Host: readguja_mds78[readguja_mds78] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_samachar;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (16) ORDER BY t.name ASC;
# Time: 081223 14:18:32
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
use readguja_sahitya;
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=07 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:18:33
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=06 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:18:34
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 1 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=10 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=07 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:29:13
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 21 Rows_examined: 105
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1262, 1261, 1255, 1256, 1259, 1260, 1258, 1257, 1254, 1253) ORDER BY t.name ASC;
# Time: 081223 14:36:38
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2142) ORDER BY t.name ASC;
# Time: 081223 14:46:04
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=11 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:46:05
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=02 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=08 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:46:06
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=01 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:46:07
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:53:24
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 4 Rows_examined: 16
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('987') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 15:04:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (350) ORDER BY t.name ASC;
# Time: 081223 15:07:17
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 1610
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('859') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 80, 10;
# Time: 081223 15:10:48
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (561) ORDER BY t.name ASC;
# Time: 081223 15:15:57
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1088) ORDER BY t.name ASC;
# Time: 081223 15:17:25
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1648) ORDER BY t.name ASC;
# User@Host: readguja_mshah78[readguja_mshah78] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_pustak;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (129) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (257) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (693) ORDER BY t.name ASC;
# Time: 081223 15:18:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=06 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 15:38:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE wp_options SET option_value = '1230064762' WHERE option_name = 'doing_cron';
# Time: 081223 15:52:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (679) ORDER BY t.name ASC;
# Time: 081223 15:53:07
# User@Host: readguja_mds78[readguja_mds78] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_samachar;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (19) ORDER BY t.name ASC;
# Time: 081223 16:02:04
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 24 Rows_examined: 48
use readguja_sahitya;
SELECT * FROM wp_comments WHERE comment_post_ID = 2376 AND comment_approved = '1' ORDER BY comment_date;
# Time: 081223 16:02:07
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# Time: 081223 16:04:42
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 8 Rows_examined: 16
SELECT * FROM wp_comments WHERE comment_post_ID = 2989 AND ( comment_approved = '1' OR ( comment_author = 'Ajit Desai' AND comment_author_email = 'ajit_desai@yahoo.com' AND comment_approved = '0' ) ) ORDER BY comment_date;
# Time: 081223 16:10:07
# User@Host: readguja_mshah78[readguja_mshah78] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 12 Rows_examined: 52
use readguja_pustak;
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC;
# Time: 081223 16:25:45
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 22 Rows_examined: 110
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (618, 617, 616, 615, 610, 607, 606, 605, 599, 593) ORDER BY t.name ASC;
# User@Host: readguja_mds78[readguja_mds78] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_samachar;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (110) ORDER BY t.name ASC;
# Time: 081223 16:48:58
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 21 Rows_examined: 105
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1594, 1593, 1589, 1588, 1586, 1585, 1579, 1581, 1580, 1571) ORDER BY t.name ASC;
# Time: 081223 17:12:48
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 25 Rows_examined: 29438
SELECT COUNT(comment_author) AS comment_comments, comment_author
FROM wp_comments
WHERE 1=1
AND comment_author NOT IN('Administrator')
AND comment_author != ''
AND comment_type != 'pingback'
AND comment_approved = '1'
GROUP BY comment_author
ORDER BY comment_comments DESC LIMIT 25;
# Time: 081223 17:12:50
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 25 Rows_examined: 29438
SELECT COUNT(comment_author) AS comment_comments, comment_author
FROM wp_comments
WHERE 1=1
AND comment_author NOT IN('Administrator')
AND comment_author != ''
AND comment_type != 'pingback'
AND comment_approved = '1'
GROUP BY comment_author
ORDER BY comment_comments DESC LIMIT 25;
# Time: 081223 17:24:03
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 100
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (550, 549, 548, 546, 545, 544, 542, 541, 540, 538) ORDER BY t.name ASC;
# Time: 081223 18:02:40
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1988) ORDER BY t.name ASC;
# Time: 081223 18:09:07
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1739) ORDER BY t.name ASC;
# Time: 081223 18:29:54
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1857) ORDER BY t.name ASC;
# Time: 081223 18:38:08
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1120, 1119) ORDER BY t.name ASC;
# Time: 081223 18:41:00
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (911, 910) ORDER BY t.name ASC;
# Time: 081223 18:43:59
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 14 Rows_examined: 70
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (416, 415, 414, 413, 412, 411, 410, 409, 408, 406) ORDER BY t.name ASC;
# Time: 081223 19:00:44
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1985) ORDER BY t.name ASC;
# Time: 081223 19:05:15
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2369, 2366) ORDER BY t.name ASC;
# Time: 081223 19:08:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2076) ORDER BY t.name ASC;
# Time: 081223 19:10:57
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (838) ORDER BY t.name ASC;
# Time: 081223 19:20:05
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (513) ORDER BY t.name ASC;
# Time: 081223 20:52:59
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 20:53:03
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 20:55:08
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 2
SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM wp_posts
WHERE post_date < '2006-05-01'
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date DESC
LIMIT 1;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=11 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2008 AND MONTH(wp_posts.post_date)=02 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2008 AND MONTH(wp_posts.post_date)=01 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 28 Rows_examined: 2207
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '12'
AND YEAR(post_date) = '2006'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 07:25:04';
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 29 Rows_examined: 2208
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '01'
AND YEAR(post_date) = '2007'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 07:25:05';
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 36 Rows_examined: 2251
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=06 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 12 Rows_examined: 60
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (528, 527, 524, 523, 522, 521, 520, 519, 518, 517) ORDER BY t.name ASC;
# Time: 081223 20:55:11
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 61 Rows_examined: 2179
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2007' AND MONTH(post_date) = '01' AND post_date < '2008-12-24 07:25:07' AND post_type = 'post' AND post_status = 'publish';
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 57 Rows_examined: 2179
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2007' AND MONTH(post_date) = '04' AND post_date < '2008-12-24 07:25:07' AND post_type = 'post' AND post_status = 'publish';
# Time: 081223 20:55:13
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 1612
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('859') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 1612
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('859') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 20:55:16
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 101 Rows_examined: 28628
SELECT wp_posts.ID, post_title, post_name, post_date, COUNT(wp_comments.comment_post_ID) AS 'comment_total' FROM wp_posts LEFT JOIN wp_comments ON wp_posts.ID = wp_comments.comment_post_ID WHERE comment_approved = '1' AND post_date_gmt < '2008-12-24 01:55:11' AND post_status = 'publish' AND post_password = '' GROUP BY wp_comments.comment_post_ID ORDER BY comment_total DESC LIMIT 101;
/usr/sbin/mysqld, Version: 5.0.51a-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
/usr/sbin/mysqld, Version: 5.0.51a-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 081223 21:20:47
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1263) ORDER BY t.name ASC;
# Time: 081223 21:45:36
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1886) ORDER BY t.name ASC;
# Time: 081223 22:20:09
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (836) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 18 Rows_examined: 90
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (3013, 3010, 2989, 2987, 2975, 2970, 2968, 2964, 2962) ORDER BY t.name ASC;
# Time: 081223 22:20:46
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 3718
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%સાથે%') OR (wp_posts.post_content LIKE '%સાથે%'))) AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 30, 10;
# Time: 081223 22:21:03
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE wp_options SET option_value = '1230088888' WHERE option_name = 'doing_cron';
# Time: 081223 22:21:14
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 4
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('980') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 22:21:15
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 2181
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=12 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 22:21:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (739) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (999) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 24 Rows_examined: 120
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1564, 1563, 1552, 1558, 1557, 1556, 1555, 1554, 1553, 1551) ORDER BY t.name ASC;
# Time: 081223 22:21:46
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 7 Rows_examined: 14
SELECT * FROM wp_comments WHERE comment_post_ID = 2987 AND comment_approved = '1' ORDER BY comment_date;
# Time: 081223 22:22:58
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 30
SELECT * FROM wp_comments WHERE comment_post_ID = 2975 AND comment_approved = '1' ORDER BY comment_date;
# Time: 081223 22:23:01
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2046) ORDER BY t.name ASC;
# Time: 081223 22:24:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 24 Rows_examined: 2205
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '12'
AND YEAR(post_date) = '2008'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 08:54:16';
# Time: 081223 22:24:27
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 7 Rows_examined: 28
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('890') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 22:24:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1718) ORDER BY t.name ASC;
# Time: 081223 22:25:21
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1024) ORDER BY t.name ASC;
# Time: 081223 22:26:37
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 24803
SELECT comment_date_gmt FROM wp_comments WHERE comment_author_IP = '212.116.219.82' OR comment_author_email = 'harder-yk@barone.com' ORDER BY comment_date DESC LIMIT 1;
# Time: 081223 22:47:57
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2181
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=11 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 23:26:21
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 19 Rows_examined: 95
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2960, 2957, 2952, 2954, 2948, 2945, 2942, 2935, 2932, 2930) ORDER BY t.name ASC;
# Time: 081223 23:32:17
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2101) ORDER BY t.name ASC;
# Time: 081223 23:34:51
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 11 Rows_examined: 55
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (348, 338, 336, 333, 325, 322, 317, 314, 313, 312) ORDER BY t.name ASC;
# Time: 081223 23:45:37
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 10 Rows_examined: 862
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('878') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 23:59:14
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1149) ORDER BY t.name ASC;
# Time: 081224 0:05:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1194) ORDER BY t.name ASC;
# Time: 081224 0:05:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 812
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('864') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081224 0:10:49
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 19 Rows_examined: 95
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1106, 1104, 1099, 1097, 1082, 1080, 1071, 1064, 1060, 1058) ORDER BY t.name ASC;
# Time: 081224 0:16:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 19 Rows_examined: 95
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2187, 2186, 2185, 2182, 2181, 2177, 2176, 2175, 2173, 2169) ORDER BY t.name ASC;
# Time: 081224 0:18:18
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2288) ORDER BY t.name ASC;
# Time: 081224 0:19:54
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 10 Rows_examined: 4348
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('862') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 200, 10;
======================================
As per your guidence I run "mysqldumpslow" command from SSH prompt and it is showing me follwoing report.
=====================================
Can't determine basedir from 'my_print_defaults mysqld' output: --skip-bdb
--skip-innodb
--concurrent_insert=1
--connect_timeout=10
--delayed_insert_timeout=30
--join_buffer_size=1M
--interactive_timeout=30
--max_allowed_packet=16M
--max_connections=100
--max_connect_errors=10
--max_delayed_threads=20
--max_user_connections=50
--max_heap_table_size=64M
--max_tmp_tables=128
--myisam_sort_buffer_size=64M
--key_buffer=16M
--long_query_time=2
--log_slow_queries=/var/lib/mysql/slowqueries.log
--low_priority_updates=1
--query_cache_limit=1M
--query_cache_size=16M
--query_cache_type=1
--read_buffer_size=1M
--read_rnd_buffer_size=1M
--safe-show-database
--skip-locking
--socket=/var/lib/mysql/mysql.sock
--sort_buffer_size=1M
--table_cache=1000
--thread_cache_size=128
--thread_concurrency=2
--tmp_table_size=64M
--wait_timeout=20
--skip-bdb
--skip-innodb
--concurrent_insert=1
--connect_timeout=10
--delayed_insert_timeout=30
--join_buffer_size=1M
--interactive_timeout=30
--max_allowed_packet=16M
--max_connections=100
--max_connect_errors=10
--max_delayed_threads=20
--max_user_connections=50
--max_heap_table_size=64M
--max_tmp_tables=128
--myisam_sort_buffer_size=64M
--key_buffer=16M
--long_query_time=2
--log_slow_queries=/var/lib/mysql/slowqueries.log
--low_priority_updates=1
--query_cache_limit=1M
--query_cache_size=16M
--query_cache_type=1
--read_buffer_size=1M
--read_rnd_buffer_size=1M
--safe-show-database
--skip-locking
--socket=/var/lib/mysql/mysql.sock
--sort_buffer_size=1M
--table_cache=1000
--thread_cache_size=128
--thread_concurrency=2
--tmp_table_size=64M
--wait_timeout=20
=========================================================
I donot know what to do in this. Please guide. I am very much confused where to find solution to make my system usage optimal.
please help.
Actually the problem is not in CPU usage, the problem is in "system usage" on VPS. After you told me to write slow_querty time etc.... now, it is taking 7 hours (insted of 4) to get 100%, so something positive thing has happen. but still not fully solved.
Yes, My slow query log is working and it contains lots of data. following is its file content :
=========================================================
/usr/sbin/mysqld, Version: 5.0.51a-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 081223 13:15:07
# User@Host: readguja[readguja] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 25826 Rows_examined: 25826
SELECT * FROM `readguja_sahitya`.`wp_comments`;
# Time: 081223 13:16:22
# User@Host: readguja[readguja] @ localhost []
# Query_time: 52 Lock_time: 0 Rows_sent: 25826 Rows_examined: 25826
SELECT * FROM `readguja_sahitya`.`wp_comments`;
# Time: 081223 13:20:22
# User@Host: readguja[readguja] @ localhost []
# Query_time: 238 Lock_time: 0 Rows_sent: 2940 Rows_examined: 2940
SELECT * FROM `readguja_sahitya`.`wp_posts`;
# Time: 081223 13:29:10
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
use readguja_sahitya;
DESC wp_comments;
# Time: 081223 13:30:09
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# Time: 081223 13:31:33
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# Time: 081223 13:32:11
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=08 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 13:32:18
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=03 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 13:32:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 30 Rows_examined: 2209
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '09'
AND YEAR(post_date) = '2007'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 00:02:16';
# Time: 081223 13:52:24
# User@Host: readguja_suser[readguja_suser] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
use readguja_support;
SELECT * FROM wp_users WHERE user_login = 'VenFliednep';
# Time: 081223 14:05:09
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
use readguja_sahitya;
DESC wp_comments;
# Time: 081223 14:06:31
# User@Host: readguja_mds78[readguja_mds78] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_samachar;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (16) ORDER BY t.name ASC;
# Time: 081223 14:18:32
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
use readguja_sahitya;
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=07 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:18:33
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=06 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:18:34
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 1 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=10 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=07 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:29:13
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 21 Rows_examined: 105
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1262, 1261, 1255, 1256, 1259, 1260, 1258, 1257, 1254, 1253) ORDER BY t.name ASC;
# Time: 081223 14:36:38
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2142) ORDER BY t.name ASC;
# Time: 081223 14:46:04
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=11 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:46:05
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=02 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=08 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:46:06
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=01 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:46:07
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 14:53:24
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 4 Rows_examined: 16
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('987') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 15:04:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (350) ORDER BY t.name ASC;
# Time: 081223 15:07:17
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 1610
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('859') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 80, 10;
# Time: 081223 15:10:48
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (561) ORDER BY t.name ASC;
# Time: 081223 15:15:57
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1088) ORDER BY t.name ASC;
# Time: 081223 15:17:25
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1648) ORDER BY t.name ASC;
# User@Host: readguja_mshah78[readguja_mshah78] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_pustak;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (129) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (257) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (693) ORDER BY t.name ASC;
# Time: 081223 15:18:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=06 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 15:38:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE wp_options SET option_value = '1230064762' WHERE option_name = 'doing_cron';
# Time: 081223 15:52:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (679) ORDER BY t.name ASC;
# Time: 081223 15:53:07
# User@Host: readguja_mds78[readguja_mds78] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_samachar;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (19) ORDER BY t.name ASC;
# Time: 081223 16:02:04
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 24 Rows_examined: 48
use readguja_sahitya;
SELECT * FROM wp_comments WHERE comment_post_ID = 2376 AND comment_approved = '1' ORDER BY comment_date;
# Time: 081223 16:02:07
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# Time: 081223 16:04:42
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 8 Rows_examined: 16
SELECT * FROM wp_comments WHERE comment_post_ID = 2989 AND ( comment_approved = '1' OR ( comment_author = 'Ajit Desai' AND comment_author_email = 'ajit_desai@yahoo.com' AND comment_approved = '0' ) ) ORDER BY comment_date;
# Time: 081223 16:10:07
# User@Host: readguja_mshah78[readguja_mshah78] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 12 Rows_examined: 52
use readguja_pustak;
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC;
# Time: 081223 16:25:45
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 22 Rows_examined: 110
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (618, 617, 616, 615, 610, 607, 606, 605, 599, 593) ORDER BY t.name ASC;
# User@Host: readguja_mds78[readguja_mds78] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
use readguja_samachar;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (110) ORDER BY t.name ASC;
# Time: 081223 16:48:58
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 21 Rows_examined: 105
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1594, 1593, 1589, 1588, 1586, 1585, 1579, 1581, 1580, 1571) ORDER BY t.name ASC;
# Time: 081223 17:12:48
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 25 Rows_examined: 29438
SELECT COUNT(comment_author) AS comment_comments, comment_author
FROM wp_comments
WHERE 1=1
AND comment_author NOT IN('Administrator')
AND comment_author != ''
AND comment_type != 'pingback'
AND comment_approved = '1'
GROUP BY comment_author
ORDER BY comment_comments DESC LIMIT 25;
# Time: 081223 17:12:50
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 25 Rows_examined: 29438
SELECT COUNT(comment_author) AS comment_comments, comment_author
FROM wp_comments
WHERE 1=1
AND comment_author NOT IN('Administrator')
AND comment_author != ''
AND comment_type != 'pingback'
AND comment_approved = '1'
GROUP BY comment_author
ORDER BY comment_comments DESC LIMIT 25;
# Time: 081223 17:24:03
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 100
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (550, 549, 548, 546, 545, 544, 542, 541, 540, 538) ORDER BY t.name ASC;
# Time: 081223 18:02:40
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1988) ORDER BY t.name ASC;
# Time: 081223 18:09:07
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1739) ORDER BY t.name ASC;
# Time: 081223 18:29:54
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1857) ORDER BY t.name ASC;
# Time: 081223 18:38:08
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1120, 1119) ORDER BY t.name ASC;
# Time: 081223 18:41:00
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 16 Rows_examined: 16
DESC wp_comments;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (911, 910) ORDER BY t.name ASC;
# Time: 081223 18:43:59
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 14 Rows_examined: 70
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (416, 415, 414, 413, 412, 411, 410, 409, 408, 406) ORDER BY t.name ASC;
# Time: 081223 19:00:44
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1985) ORDER BY t.name ASC;
# Time: 081223 19:05:15
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2369, 2366) ORDER BY t.name ASC;
# Time: 081223 19:08:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2076) ORDER BY t.name ASC;
# Time: 081223 19:10:57
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (838) ORDER BY t.name ASC;
# Time: 081223 19:20:05
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (513) ORDER BY t.name ASC;
# Time: 081223 20:52:59
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 20:53:03
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 20:55:08
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 2
SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM wp_posts
WHERE post_date < '2006-05-01'
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date DESC
LIMIT 1;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=11 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2008 AND MONTH(wp_posts.post_date)=02 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2008 AND MONTH(wp_posts.post_date)=01 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 28 Rows_examined: 2207
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '12'
AND YEAR(post_date) = '2006'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 07:25:04';
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 29 Rows_examined: 2208
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '01'
AND YEAR(post_date) = '2007'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 07:25:05';
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 36 Rows_examined: 2251
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=06 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 12 Rows_examined: 60
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (528, 527, 524, 523, 522, 521, 520, 519, 518, 517) ORDER BY t.name ASC;
# Time: 081223 20:55:11
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2179
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=04 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 61 Rows_examined: 2179
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2007' AND MONTH(post_date) = '01' AND post_date < '2008-12-24 07:25:07' AND post_type = 'post' AND post_status = 'publish';
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 57 Rows_examined: 2179
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2007' AND MONTH(post_date) = '04' AND post_date < '2008-12-24 07:25:07' AND post_type = 'post' AND post_status = 'publish';
# Time: 081223 20:55:13
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 1612
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('859') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 1612
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('859') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 20:55:16
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 101 Rows_examined: 28628
SELECT wp_posts.ID, post_title, post_name, post_date, COUNT(wp_comments.comment_post_ID) AS 'comment_total' FROM wp_posts LEFT JOIN wp_comments ON wp_posts.ID = wp_comments.comment_post_ID WHERE comment_approved = '1' AND post_date_gmt < '2008-12-24 01:55:11' AND post_status = 'publish' AND post_password = '' GROUP BY wp_comments.comment_post_ID ORDER BY comment_total DESC LIMIT 101;
/usr/sbin/mysqld, Version: 5.0.51a-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
/usr/sbin/mysqld, Version: 5.0.51a-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 081223 21:20:47
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
use readguja_sahitya;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1263) ORDER BY t.name ASC;
# Time: 081223 21:45:36
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1886) ORDER BY t.name ASC;
# Time: 081223 22:20:09
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 5
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (836) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 18 Rows_examined: 90
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (3013, 3010, 2989, 2987, 2975, 2970, 2968, 2964, 2962) ORDER BY t.name ASC;
# Time: 081223 22:20:46
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 3718
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%સાથે%') OR (wp_posts.post_content LIKE '%સાથે%'))) AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 30, 10;
# Time: 081223 22:21:03
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE wp_options SET option_value = '1230088888' WHERE option_name = 'doing_cron';
# Time: 081223 22:21:14
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 4
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('980') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 22:21:15
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 2181
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2007 AND MONTH(wp_posts.post_date)=12 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 22:21:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (739) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (999) ORDER BY t.name ASC;
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 24 Rows_examined: 120
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1564, 1563, 1552, 1558, 1557, 1556, 1555, 1554, 1553, 1551) ORDER BY t.name ASC;
# Time: 081223 22:21:46
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 7 Rows_examined: 14
SELECT * FROM wp_comments WHERE comment_post_ID = 2987 AND comment_approved = '1' ORDER BY comment_date;
# Time: 081223 22:22:58
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 30
SELECT * FROM wp_comments WHERE comment_post_ID = 2975 AND comment_approved = '1' ORDER BY comment_date;
# Time: 081223 22:23:01
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2046) ORDER BY t.name ASC;
# Time: 081223 22:24:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 24 Rows_examined: 2205
SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE MONTH(post_date) = '12'
AND YEAR(post_date) = '2008'
AND post_type = 'post' AND post_status = 'publish'
AND post_date < '2008-12-24 08:54:16';
# Time: 081223 22:24:27
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 7 Rows_examined: 28
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('890') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 22:24:55
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1718) ORDER BY t.name ASC;
# Time: 081223 22:25:21
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1024) ORDER BY t.name ASC;
# Time: 081223 22:26:37
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 24803
SELECT comment_date_gmt FROM wp_comments WHERE comment_author_IP = '212.116.219.82' OR comment_author_email = 'harder-yk@barone.com' ORDER BY comment_date DESC LIMIT 1;
# Time: 081223 22:47:57
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 2181
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=2006 AND MONTH(wp_posts.post_date)=11 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 23:26:21
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 19 Rows_examined: 95
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2960, 2957, 2952, 2954, 2948, 2945, 2942, 2935, 2932, 2930) ORDER BY t.name ASC;
# Time: 081223 23:32:17
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2101) ORDER BY t.name ASC;
# Time: 081223 23:34:51
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 11 Rows_examined: 55
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (348, 338, 336, 333, 325, 322, 317, 314, 313, 312) ORDER BY t.name ASC;
# Time: 081223 23:45:37
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 10 Rows_examined: 862
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('878') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081223 23:59:14
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 4 Rows_examined: 20
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1149) ORDER BY t.name ASC;
# Time: 081224 0:05:19
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1194) ORDER BY t.name ASC;
# Time: 081224 0:05:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 812
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('864') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;
# Time: 081224 0:10:49
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 19 Rows_examined: 95
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1106, 1104, 1099, 1097, 1082, 1080, 1071, 1064, 1060, 1058) ORDER BY t.name ASC;
# Time: 081224 0:16:20
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 19 Rows_examined: 95
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2187, 2186, 2185, 2182, 2181, 2177, 2176, 2175, 2173, 2169) ORDER BY t.name ASC;
# Time: 081224 0:18:18
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 10
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (2288) ORDER BY t.name ASC;
# Time: 081224 0:19:54
# User@Host: readguja_mrugesh[readguja_mrugesh] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 10 Rows_examined: 4348
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('862') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 200, 10;
======================================
As per your guidence I run "mysqldumpslow" command from SSH prompt and it is showing me follwoing report.
=====================================
Can't determine basedir from 'my_print_defaults mysqld' output: --skip-bdb
--skip-innodb
--concurrent_insert=1
--connect_timeout=10
--delayed_insert_timeout=30
--join_buffer_size=1M
--interactive_timeout=30
--max_allowed_packet=16M
--max_connections=100
--max_connect_errors=10
--max_delayed_threads=20
--max_user_connections=50
--max_heap_table_size=64M
--max_tmp_tables=128
--myisam_sort_buffer_size=64M
--key_buffer=16M
--long_query_time=2
--log_slow_queries=/var/lib/mysql/slowqueries.log
--low_priority_updates=1
--query_cache_limit=1M
--query_cache_size=16M
--query_cache_type=1
--read_buffer_size=1M
--read_rnd_buffer_size=1M
--safe-show-database
--skip-locking
--socket=/var/lib/mysql/mysql.sock
--sort_buffer_size=1M
--table_cache=1000
--thread_cache_size=128
--thread_concurrency=2
--tmp_table_size=64M
--wait_timeout=20
--skip-bdb
--skip-innodb
--concurrent_insert=1
--connect_timeout=10
--delayed_insert_timeout=30
--join_buffer_size=1M
--interactive_timeout=30
--max_allowed_packet=16M
--max_connections=100
--max_connect_errors=10
--max_delayed_threads=20
--max_user_connections=50
--max_heap_table_size=64M
--max_tmp_tables=128
--myisam_sort_buffer_size=64M
--key_buffer=16M
--long_query_time=2
--log_slow_queries=/var/lib/mysql/slowqueries.log
--low_priority_updates=1
--query_cache_limit=1M
--query_cache_size=16M
--query_cache_type=1
--read_buffer_size=1M
--read_rnd_buffer_size=1M
--safe-show-database
--skip-locking
--socket=/var/lib/mysql/mysql.sock
--sort_buffer_size=1M
--table_cache=1000
--thread_cache_size=128
--thread_concurrency=2
--tmp_table_size=64M
--wait_timeout=20
=========================================================
I donot know what to do in this. Please guide. I am very much confused where to find solution to make my system usage optimal.
please help.
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.