[Solved] Request For Mysql Queries Report: B2Scs

[notallowed]

Hi,

 

as Krydos said in suspended thread to post my load request here I am finally doing it.

I would like to see sql queries for last 24 hours which took the most load on my site.

 

Site data:

account name: b2scs

server: Stevie

main domain: blender2scs.heliohost.org

 

Thx,

notallowed

[Krydos]

Count: 17  Time=9.89s (168s)  Lock=0.45s (7s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 DELETE
 FROM `joomla_session`
 WHERE `time` < 'S'
--
Count: 4  Time=40.89s (163s)  Lock=0.14s (0s)  Rows=7.2 (29), b2scs[b2scs]@localhost
 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 FROM joomla_modules AS m
 LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id
--
Count: 7  Time=19.57s (137s)  Lock=0.27s (1s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 INSERT INTO `joomla_session`
 (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) VALUES
 ('S', N, N, 'S', N, 'S')
--
Count: 8  Time=14.97s (119s)  Lock=0.01s (0s)  Rows=0.0 (0), b2scs[b2scs]@localhost
 INSERT INTO `joomla_updates`
 (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`detailsurl`,`infourl`) VALUES
 ('S','S','S','S','S','S','S','S','S','S')
--
Count: 55  Time=1.63s (89s)  Lock=0.06s (3s)  Rows=27.0 (1486), b2scs[b2scs]@localhost
 SELECT `update_id`
 FROM `joomla_updates`
 WHERE element = 'S' AND type = 'S' AND client_id = 'S' AND folder = 'S'
--
Count: 159  Time=0.52s (82s)  Lock=0.02s (2s)  Rows=1.9 (302), b2scs[b2scs]@localhost
 SELECT a.fulltext, a.id, a.title, a.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.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.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.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,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 > 'S' 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, N) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE N END AS parents_published
 FROM joomla_content AS a
 LEFT JOIN joomla_content_frontpage AS fp ON fp.content_id = a.id
--
Count: 4  Time=18.33s (73s)  Lock=0.14s (0s)  Rows=0.0 (0), b2scs[b2scs]@localho
st
 UPDATE `joomla_update_sites`
 SET `last_check_timestamp` = 'S'
 WHERE `update_site_id` = 'S'
--
Count: 49  Time=0.97s (47s)  Lock=0.02s (1s)  Rows=2.0 (98), b2scs[b2scs]@localhost
 SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias)!=N THEN CONCAT_WS('S', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
 FROM joomla_categories as c
 LEFT JOIN joomla_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
--
Count: 1  Time=39.22s (39s)  Lock=0.04s (0s)  Rows=11.0 (11), b2scs[b2scs]@localhost
 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 FROM joomla_modules AS m
 LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id

[notallowed]

Hmm...now I would like to know if there are still some problematic queries which I should look into?

Also are thoose all of quieries from my domain or only queiries with most load?

 

I don't have much experience with monitoring that's why I'm asking that kinda questions