Recent content by Sean Kendle

Awesome, thanks for the quick response! Any chance of updating the version here so that others can easily find this update? I checked the update date earlier today, and would have tried that first if I'd seen an update. Thanks again!

We're getting an error, I traced it to `origin.asn.cymru.com`. This server is not responding. Is there a back up server to use, or should I just disable the plugin until they fix their server issues?

It actually works just fine in 1.5.x, except that on very large boards with hundreds of thousands of conversations, it takes 20+ seconds to query all conversations. For now this will do for us, as our moderator stays on top of conversations and only needs a week's worth at a time. I can add...

I patched it to only pull conversations from the past week. I think adding a time limit to the conversations would be a good improvement, defaulting to a month or a week, and allowing the user to input from/to dates to see more messages. Thanks!

Looks like the WHERE clause isn't being appended to that query. Is that potentially the cause of such a slow query?

We are continuously getting max connection errors on our site, (50k+ users per day), and the server admins pointed us to this query in your add-on, which is taking around 20 seconds to complete: SELECT conversation_master.*...

Query takes around 20 seconds to complete, leaving database connections open, and causing too many connections error.

TilkiBey_ReadPC_Model_ReadPC::getConversations(array $conditions = array(), array $fetchOptions = array()) Lines 94 - 120

Screenshots for Troubleshooting and Support

Either way, I suspect it has more to do with a poorly formed SQL statement taking an overly long time to complete more than a connection left open, knowing what I now know. Thanks! I guess we'll wait for the hosting company to get back to us with which query is hanging.

Little gains in a one off scenario, sure, that's almost meaningless, but multiply that by 20,000 active users.

From: http://php.net/manual/en/function.mysql-close.php However, I'd much rather know for sure my connections are being closed as soon as possible. This board is very big and very busy, so any efficiency gains are very welcome.

We're waiting on that information. I know they're used to run queries, but do they open a database connection without closing it, is my question?

We have been getting the dreaded "Too Many Connections" error, and while I know that we can increase the number of connections, this is not the problem. The problem according to our host is that there is a query somewhere that is hanging, or potentially running and then leaving the connection...

I searched for usages and found none. Is that function really unused? Or is it only used by some form post in the AdminCP, potentially? Just curious. Thanks for your attention!