i have done what whole forum post suggest to solve the problem. (disabled "Recent Articles" Module, remove old articles, run asset script)
Code: Select all
/usr/sbin/mysqld, Version: 5.0.95-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
/usr/sbin/mysqld, Version: 5.0.95-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
/usr/sbin/mysqld, Version: 5.0.95-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
# Time: 120422 8:30:03
# User@Host: root[root] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 10 Rows_examined: 288
use mysql;
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 120423 7:36:02
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use medcom_newsdb;
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES
('c0edb6454c3c61615ae68122d03d0867', 0, '1335180960');
# Time: 120430 4:02:39
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use tamilmed_4tamiltvdb;
INSERT INTO `z6xk9_session`
(`session_id`, `client_id`, `time`) VALUES
('05cdb1983d30b638b8f76a3370905ef5', 0, '1335772957');
# Time: 120507 22:25:14
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use medcom_newsdb;
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES
('03f6aaae4d5b29362f31a967103ffde9', 0, '1336443912');
# Time: 120508 3:00:58
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE anj_assets
SET rgt = rgt + 2
WHERE rgt >= 979;
# Time: 120508 5:16:30
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES
('50395598caf2b6fbc4eb1dbb313acb7b', 0, '1336468588');
# Time: 120508 5:39:37
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE
FROM `anj_session`
WHERE `time` < '1336468175';
# Time: 120508 5:50:00
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use tamilmed_4tamiltvdb;
INSERT INTO `z6xk9_session`
(`session_id`, `client_id`, `time`) VALUES
('42d75bd00819176626b10eaa34180b78', 0, '1336470598');
# Time: 120508 6:18:13
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 7 Rows_examined: 19965
use medcom_newsdb;
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 7 Rows_examined: 19965
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 7 Rows_examined: 19965
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 7 Rows_examined: 19965
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# Time: 120508 6:54:44
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 28
SELECT `value` FROM `anj_obrss_config` WHERE `name` = 'view_feedburner';
# Time: 120508 6:55:03
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES
('383965714268c29e255a880c50051d92', 0, '1336474501');
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE anj_content SET hits = hits + 1 WHERE id = 5094;
# Time: 120508 6:55:12
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES
('a70dc07018c65381df185e69fdbb42ae', 0, '1336474509');
# Time: 120508 6:55:14
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use tamilmed_4tamiltvdb;
UPDATE z6xk9_phocagallery_categories
SET `hits` = (`hits` + 1)
WHERE id = '617';
# Time: 120508 6:55:15
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 4 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
use medcom_newsdb;
DELETE
FROM `anj_session`
WHERE `time` < '1336472711';
# Time: 120508 6:55:24
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES
('d15e560406fbd015c5096eb22c812e6a', 0, '1336474522');
# Time: 120508 6:55:26
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use tamilmed_4tamiltvdb;
INSERT INTO `z6xk9_session`
(`session_id`, `client_id`, `time`) VALUES
('106730645ec33557b12ebd8ed34104a4', 0, '1336474523');
# Time: 120508 6:55:33
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use medcom_newsdb;
UPDATE anj_content SET hits = hits + 1 WHERE id = 4957;
i have pm the site address to you.