We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Answered Revo 2.2.4 Database Ratelimited by Rackspace Cloud Sites

    • 37261 ☆ A M B ☆
    • 113 Posts
    pyrographics Reply #1, 13 years, 11 months ago
    Something generated the query below through MODX:

    SELECT `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties` FROM `modx_site_content` AS `modResource` WHERE ( ( modResource.parent IN (0,1,12,13,14,1022,15,16,17,18,106,111,144,207,594,634,780,961,1473,2624,4,6,195,297,379,528,609,654,682,774,858,1002,1101,1187,1258,1569,1331,1408,1481,1619,1707,1779,1854,1927,1998,2087,2172,2265,2332,2402,2478,2553,2660,2747,2830,2909,2972,3067,3146,3226,3312,3402,3476,3544,3618,3697,3808,3872,3938,4024,4106,4195,4271,4355,4437,4514,4589,4665,4735,4816,4898,5,9,3,10,11,24,25,26,27,28,29,30,31,32,33,34,35,36,38,37,39,40,41,51,52,53,54,55,56,57,58,59,60,61,62,63,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,94,96,99,100,101,102,103,113,114,116,117,7,118,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,137,138,139,142,143,149,151,152,153,155,156,157,158,159,160,161,162,164,165,166,167,168,169,170,172,173,174,175,177,178,179,180,181,182,183,184,185,187,188,189,190,191,193,196,197,198,199,201,202,203,205,208,210,221,222,223,224,225,226,227,228,229,230,231,233,235,236,237,238,239,241,244,245,247,248,249,250,251,252,253,254,256,257,258,259,260,262,263,264,266,267,268,269,...

    It caused our hosting provider to cut off our database. Any ideas what could have caused this? I need to get the rest of the query from them.

    This question has been answered by pyrographics. See the first response.

      • 37261 ☆ A M B ☆
      • 113 Posts
      pyrographics Reply #2, 13 years, 11 months ago
      The ID numbers in this appear to be our entire site tree in order of level. This is a large site.
        • 18373 ☆ A M B ☆
        • 3,141 Posts
        Mark Hamstra Reply #3, 13 years, 11 months ago
        Sounds like getResources or Wayfinder to me.. the only reason I can imagine a host to cut off a database based on something like that would be if it's repeated a lot over and over - perhaps an uncached getR or WF call somewhere?
          Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

          Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.
          • 37261 ☆ A M B ☆
          • 113 Posts
          pyrographics Reply #4, 13 years, 11 months ago
          Not sure what happened, they lifted the ratelimit. I checked and all my Wayfinder and getResources calls are cached. I don't use any calls that show the entire site tree anyway.
            • 28042 ☆ A M B ☆
            • 24,524 Posts
            sottwell Reply #5, 13 years, 11 months ago
            Some kind of sitemap generator?
              Studying MODX in the desert - http://sottwell.com
              Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
              Join the Slack Community - http://modx.org
            • discuss.answer
              • 37261 ☆ A M B ☆
              • 113 Posts
              pyrographics Reply #6, 13 years, 11 months ago
              Good point, there are a couple sitemaps on the site. They are generated using getResources and cached but show 300 resources and includes content and all resource TV's unnecessarily. I'll chalk it up to that and lighten it's load. Thanks for your assistance Mark and Susan!