• I’m regularly facing downtime of my blog. The ISP says my blog is generating lot of DB queries, here’re few queries they’ve sent. Please advice me the way to solve this problem.

    # Query_time: 12  Lock_time: 0  Rows_sent: 10  Rows_examined: 61022
    
    SELECT wp_posts.*, (meta_value+0) AS views FROM wp_posts LEFT JOIN
    wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE post_date <
    '2008-04-22 09:32:16' AND post_type = 'post' AND post_status = 'publish' AND meta_key = 'views' AND post_password = '' ORDER  BY views DESC LIMIT 10;
    
    # Query_time: 11  Lock_time: 0  Rows_sent: 26  Rows_examined: 20304
    
    SELECT DISTINCT YEAR(post_date) AS <code>year</code>, MONTH(post_date) AS <code>month</code>, 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;
    
    # Query_time: 11  Lock_time: 0  Rows_sent: 26  Rows_examined: 20300
    
    SELECT DISTINCT YEAR(post_date) AS <code>year</code>, MONTH(post_date) AS <code>month</code>, 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;
    
    # Query_time: 11  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    
    SET insert_id=20533; INSERT INTO wp_posts (<code>post_author</code>,<code>post_date</code>,<code>post_date_gmt</code>,<code>post_content</code>,<code>post_content_filtered</code>,<code>post_title</code>,<code>post_excerpt</code>,<code>post_status</code>,<code>post_type</code>,<code>comment_status</code>, <code>ping_status</code>,<code>post_password</code>,<code>post_name</code>,<code>to_ping</code>,<code>pinged</code>,<code>post_modified</code>,<code>post_modified_gmt</code>,<code>post_parent</code>,<code>menu_order</code>,<code>guid</code>,<code>post_mime_type</code>) VALUES ('2','2008-04-22 09:16:00','2008-04-22 14:16:00','<p>Here&rsquo;re some pretty neat new Sidebar Gadgets to tell you about for WindowsSidebar. If you\'re into Baseball, you\'ll like this new Gadget. <a href=\"https://msn.foxsports.com/\" mce_href=\"https://msn.foxsports.com/\">Fox Sports on MSN</a> is offering a <a
    href=\"https://msn.foxsports.com/peopleready\"mce_href=\"https://msn.foxsports.com/peopleready\">Fantasy BaseballGadget</a> brought to you by <a href=\"https://www.microsoft.com/business/peopleready/default.mspx\"mce_href=\"https://www.microsoft.com/business/peopleready/default.mspx\">People-Ready Business</a> from Microsoft. </p>
    <p><a href=\"https://img76.imageshack.us/img76/7461/originalqj2.jpg\"><img height=\"92\" alt=\"\"src=\"https://img76.imageshack.us/img76/7461/originalqj2.th.jpg\"width=\"103\" align=\"left\" border=\"0\" / /></a>With this Gadget, you can check up on Fantasy Baseball news, check player stats, and create your own roster. This Gadget requires Adobe Flash so if you\'re running Windows Vista x64 (like me), you\'ll need to run Windows Sidebar under 32-bit. To do that in Windows Vista x64 - just go to <em>C:/Program Files (x86)/Windows Sidebar</em> and execute sidebar.exe from there. </p>
    <p>Download the People-Ready Fantasy Baseball Gadget <a href=\"https://gallery.live.com/liveItemDetail.aspx?li=385fde7f-72cf-44fc-
    ab43-9ad75521d773\" mce_href=\"https://gallery.live.com/liveItemDetail.aspx?li=385fde7f-72cf-44fc-ab43-9ad75521d773\">here</a>. </p>
    <p><a href=\"https://img76.imageshack.us/img76/328/originalxf8.jpg\"><img height=\"92\" alt=\"\"src=\"https://img76.imageshack.us/img76/328/originalxf8.th.jpg\"width=\"103\" align=\"left\" border=\"0\" / /></a>Another new Gadget to check out is the brand new MSN Video Gadget for Windows Sidebar. The MSN Video Team <a href=\"https://soapboxteam.spaces.live.com/Blog/cns!278AB163A6122C91!1441.entry\"
    mce_href=\"https://soapboxteam.spaces.live.com/Blog/cns!278AB163A6122C91!1441.entry\">announced its availability</a> today along with some highlights as to what you can do with the Gadget on their blog. </p>
    <p><br />Download the MSN Video Gadget <a href=\"https://gallery.live.com/liveItemDetail.aspx?li=b4ea67a2-5cb6-4a15-8ae1-048cccaf8ffc&amp;bt=1\"mce_href=\"https://gallery.live.com/liveItemDetail.aspx?li=b4ea67a2-5cb6-4a15-8ae1-048cccaf8ffc&amp;bt=1\">here</a>.</p>
    <p class=\"sr\">Source:→&nbsp;<a href=\"https://windowsvistablog.com/blogs/windowsexperience/default.aspx\"target=\"_blank\">Windows Experience Blog</a></p>
    <p>[tags]Windows Vista, Sidebar, Gadgets, Download, Windows Sidebar,
    Sidebar Gadget, MSN, Internet Video[/tags]</p>','','Windows Vista Sidebar Gadgets','','publish','post','open','open','','windows-vista-sidebar-gadgets','','','2008-04-22 09:16:00','2008-04-22 14:16:00','0','0','','');
  • The topic ‘Critical & urgent’ is closed to new replies.