We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 36912
    • 12 Posts
    Hello everyone, I googled and searched the forums but didn't find any answer, so I'm starting a new thread.
    I'm in charge of managing a large corporate website (~7000 pages) and I'm using modx. I upgraded from 2.1.5 to 2.2 some days ago.
    The first install went wrong (no manager resource tree, blank front-end pages...); after restoring v2.1.5, setting the appropriate suhosin "get_max_size" in php.ini, cleaning up unneeded packages and cleaning modx cache manually, the second install -at least- went ok.

    However, overall site performance has got worse; we cannot save modified resources (getting lots of aborted POST requests), and page access has become slower.

    I guess -see below- it's because the site has many visitors (~4000/day) and the db sometimes refuses connections; our provider has enabled memcached and installed the corresponding PHP extension, and now I'm trying to enable memcached resource caching, with no luck so far.

    Changing the setting "cache_handler" from "xPDOFileCache" to "xPDOMemCache" just flooded our error log with messages like this:

    (ERROR @ /index.php) Could not load class: xPDOMemCache from xpdomemcache.

    What am I missing?

    Besides, this kind of message is rather usual in error.log:

    (ERROR in xPDOConnection::connect @ ...l/core/xpdo/xpdo.class.php : 2955) SQLSTATE[42000] [1203] User --- already has more than 'max_user_connections' active connections

    Is there a way to use persistent db connections? Or a way to make resources (pages) static so no database interaction is needed? In the past, we used to save each page manually as a separate html file, but it would be better (since there are so many) to have an automated way to do it.


    Any advice will be greatly appreciated.

    I don't think it can help, anyway our server info are here (from phpinfo()):

    • Linux svxshd089 2.6.32-5-amd64 (virtual server)
    • Apache 2.0
    • PHP Version 5.3.3-7+squeeze3 run as an Apache module
    • Suhosin patch 0.9.9.1
    • Mysql v5.1
    [ed. note: stefanp_safilo last edited this post 14 years, 8 months ago.]
      • 1343 ☆ A M B ☆
      • 2,213 Posts
        Patrick | Server Wrangler
        About Me: Website | Tweets |  MODX Hosting
        • 36912
        • 12 Posts
        Yes I've read it but it seemed quite a hack... anyway I tried what is suggested there and seemingly it's working.

        BTW if anyone cares, I found out by myself how to make MODx use persistent connections to the db. In /core/config/config.inc.php, I changed this part:

        $driver_options = array (
        );


        to:

        $driver_options = array (
        	PDO::ATTR_PERSISTENT => true
        );
        
          • 22303 MODX Staff
          • 10,725 Posts
          Please see https://forums.modx.com/thread/73947/configuring-external-caching-apc-memcache-etc — when I have some time I will update the instructions in rtfm...