There are two things that need to happen -- DX does his mojo, and I do some too. Except my mojo doesn't work with this version of MySQL, so there hasn't been any done since we moved in.
Wash: Mal, your dead army buddy's on the bridge! Zoe: He ain't dead. Wash: Oh.
'The Message'
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.
§ ita § - Aug 24, 2004 4:11:40 pm PDT #8157 of 10000
Well not canonically, no, but this is transformative fiction.
Betsy HP - Aug 25, 2004 4:45:15 pm PDT #8158 of 10000
If I only had a brain...
main query that populates both the main page and the message centre now runs 80% faster.
Who is a star? ita is a frellin' supernova. Yeaaaa!
§ ita § - Aug 25, 2004 4:50:10 pm PDT #8159 of 10000
Well not canonically, no, but this is transformative fiction.
Heh.
If anyone feels like applying themselves to further SQL optimisations, please submit resumes.
I asked istrata support about why we're so far behind in versions from the rest of the world. It's a Plesk (our control panel) issue. If I had SSH access from work, I'd not be so leery about breaking Plesk -- as it, it's the only way I can get in to do a lot of stuff, a lot of the time. Here's the support answer:
These packages were provided by RedHat in 7.3 which as you know is end of lifed. Updates that are available from the Fedora Legacy Project are security fixes only, no new versions of software will be introduced. That said you can safely upgrade MySQL to my knowledge (but do so at your own risk :-), but upgrading PHP, at least with the standard PHP RPMs will break Plesk. There is a guy on the Plesk Forums (Something like Atomic Monkey) that is building his own Plesk friendly RPMs but they are not supported so proceed cautiously if you decide to use them. The best solution I have is Plesk 7 which was recently released (you're running version 5). Plesk 7 includes an upgrade of PHP to 4.3.8 among many other enhancements (Application Vault, Spam Assassin, new skins, and lots of other cool features.). I can upgrade your Plesk installation to the latest version for $99.
Liese S. - Aug 25, 2004 4:58:20 pm PDT #8160 of 10000
"Faded like the lilac, he thought."
Huh. Yeah, it's no fun to break the control panel.
I reckon we could at least upgrade to the point that we're able to. But it looks like we'll need to deal with it at some point in the future, huh? Anyway, do we know if upgrading MySQL will help our Big Problem? Because that would be good, and worth doing, if cautiously, if so.
§ ita § - Aug 25, 2004 5:04:13 pm PDT #8161 of 10000
Well not canonically, no, but this is transformative fiction.
Don't know about MySQL -- we're at 3.23 right now. It goes as high as 5. Could do, could do.
Karl - Aug 25, 2004 8:39:05 pm PDT #8162 of 10000
I adore all you motherfuckers so much -- PMM.
Spend the $99, ita. I'll contribute, if it'll help. 3.23 is ancient, and it's not going to get any better.
Tom Scola - Aug 26, 2004 6:57:56 am PDT #8163 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Does the Plesk upgrade also include an upgrade to a recent Fedora?
§ ita § - Aug 26, 2004 7:03:12 am PDT #8164 of 10000
Well not canonically, no, but this is transformative fiction.
Nope. The Fedora upgrade is separate -- Enterprise Server has an initial cost, plus a yearly cost ($349, IIRC).
Jesse - Aug 26, 2004 7:51:07 am PDT #8165 of 10000
Sometimes I trip on how happy we could be.
We do have a good chunk of change in the bank right now, if finances are a question.
Gus - Aug 26, 2004 9:35:12 am PDT #8166 of 10000
Bag the crypto. Say what is on your mind.
OK. Automagical tag closing seems to be working in my dev nook. How do we get some exhaustive pounding on it?