I am using Rackspace Cloud for my host.
Talking with them, the SSL cluster does not scale like a "regular" cloud site, nor does the SQL cluster. So, from what I understand, I have tied both hands behind my back. They suggested that I move my db to a cloud server site to allow it to be dedicated - which would allow more connections, which would not bog the site down, which would not bog the SSL cluster down etc. etc. That is something I will be looking into.
Here is the log file that was sent to me during a "slow" time.
# User@Host: db_username[db_username] @ [IP ADDRESS]
# Thread_id: 10825521 Schema: my_database
# Query_time: 13.472810 Lock_time: 0.000106 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1 Rows_read: 2
use my_database;
INSERT INTO `mydb_session` (`id`, `access`, `data`) VALUES ('gidh97olc5491ui6mm56v03se6', 1295643294, 'modx.user.contextTokens|a:0:{}');
+++++++++++++++++++++++++++++++++++++++++++++++++
# User@Host: db_username[db_username] @ [IP ADDRESS]
# Thread_id: 10826745 Schema: my_database
# Query_time: 10.721688 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1 Rows_read: 1
use my_database;
UPDATE `mydb_session` SET `data` = 'modx.user..attributes|a:1:{s:3:\"web\";a:3:{s:16:\"modAccessContext\";a:1:{s:3:\"web\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:22:\"modAccessResourceGroup\";a:0:{}s:17:\"modAccessCategory\";a:0:{}}}webDocgroups|a:0:{}modx.user.contextTokens|a:0:{}',`access` = 1295643483 WHERE `id` = 'dn14oll0du53tgm8hbqsncm1n4' LIMIT 1;
+++++++++++++++++++++++++++++++++++++++++++++++++
If I haven’t gotten laughed out of here yet, this will probably do it. To me, it looks like that is a call from within the manager. By that I mean an admin was accessing/updating a page. There was a save action(s) around the time of the site coming up and down. I think it was just a coincidence though.
MODx version: 2.6
I made sure to update my modx install (Revolution) to include the security patch when that post came out.
Snippets:
I have a handful that, before I discovered output filters mainly check if there is a value for any given TV. (banner images for example)
I do not have any custom plugins for this site.
As far as traditional plugins installed via package management:
getpage
getresources
googlesiteap
if
simplesearch
sitemapfriend
tinymce
ultimateparent
wayfinder
I believe I have everything checked so they are cached.
Thank you for your responses, I really appreciate any/all of the insight.
☆ A M B ☆
☆ A M B ☆
☆ A M B ☆
