Perhaps fangeek can turn on mysqld logging (for a short period of time) so that we can get a handle on what's happening?
Whatever happened to the still beating heart of a virgin? No one has any standards anymore.
Giles ,'Lies My Parents Told Me'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Tom Scola - Aug 01, 2003 10:47:33 am PDT #4457 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
DXMachina - Aug 01, 2003 10:48:14 am PDT #4458 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
IH informs me that, while they did not anticipate any problems with the site, they simply weren't expecting "over 200 concurrent mysql connections at the same time". They had no way of predicting that. They informed us that we are the reason the server has been so slow of late. They also suggested that we modify our code, as they believe the script we're using is the problem.
IH mentions that they think if we "optimize the database queries" that will help a lot. It isn't our bandwidth usage that is the issue, it's our resource usage.
I gotta say that IH actually giving us a clue as to what's happening is much better than the way HR just kept telling us "You should have fixed your code."
Liese S. - Aug 01, 2003 10:59:41 am PDT #4459 of 10000
"Faded like the lilac, he thought."
Hey, I'm where Jess is. I've been out of the programming loop for a while so I dunno if I'd be any help, but sql used to be my baby, so I'd be happy to at least look it over. I'm limited as to my online time, but if I could look at the code offline I'd have a fair whack of time this weekend to do it up. Let me know how to do whatever I gotta do. Like I said, I dunno if I'm up to scratch but I'd be glad to be extra eyes and hands.
§ ita § - Aug 01, 2003 11:14:59 am PDT #4460 of 10000
Well not canonically, no, but this is transformative fiction.
I have an ERD lying around here somewhere. I'll make sure it's up to date, and then outline the queries involved in each transaction.
I think that's simpler than learning to read the code.
Kristen - Aug 01, 2003 11:17:48 am PDT #4461 of 10000
Sorry, I had to run off and do work for the people who write my paychecks.
Perhaps fangeek can turn on mysqld logging (for a short period of time) so that we can get a handle on what's happening?
I have asked this question. Will let you know what I hear.
§ ita § - Aug 01, 2003 11:24:56 am PDT #4462 of 10000
Well not canonically, no, but this is transformative fiction.
DX -- I've taken off Natter 9 and Bitches 1. I didn't miss any, did I?
DXMachina - Aug 01, 2003 11:32:03 am PDT #4463 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
Nope. I've been working on Bitches 2, but it won't be ready for a couple of hours.
§ ita § - Aug 01, 2003 11:34:36 am PDT #4464 of 10000
Well not canonically, no, but this is transformative fiction.
When you're done, just mark it "archived", and I'll check for that periodically and delete any then.
DXMachina - Aug 01, 2003 12:15:44 pm PDT #4465 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
Getting a POP3 error message for b.org accounts:
-ERR Sorry cannot find an owner for that domain (buffistas.org)
Kristen - Aug 01, 2003 12:19:56 pm PDT #4466 of 10000
I can't access any mail through pop3now but I can access all of my accounts through Squirrel Mail.