PranK

Who is the warranty with?

haha... damn it... another one of my many todo's that i forgot about. I'll try to fix it this weekend.

Got receipts for the new engine?

Still available? I might be interested. Can you send me some more pics to [email protected] ?

Nice work Shan!!

Hmmm, still right hand drive? No Motorex for you canadians!

There is no member with that username, but I did find a few threads, maybe it's one of these: click here

George, The name on the email address you contacted me with was 'Jordan Vlotis' ... So, no, nobody will help you, because if you are Jordan, you know you're not welcome. If you are an associate of Jordans, then I'm sorry but if you're close enough to him to be using his email address then I'm not so sure we want you as a member either. Christian

For those of you who are wondering, we spent a lot of time working on the server today. Shaved some memory usage off Apache, changed some MySQL veriables, rebooted the box, plus lots (AND LOTS) more. The load is nice and constant, seems to be a bit faster to browse. I'll keep an eye on it for the next few hours and see if its ok. If it hasnt fixed the problem, then I plan to double to servers memory. sh@un - If you are going to be unhelpful and make stupid posts, then just bugger off. Its not needed.

Yeah thats the peak time for the boards. We get hammered between 9:30 and 11. I'm working on it though, should have it fixed over the weekend.

Thank you to all who have donated. I know I have been slack, but I promise you it is muchly appreciated. Your 'contributor' user groups have been added. Thanks again. Bec, thank you very much to SAU VIC, I do very much appreciate that donation! I'm not sure who to add the contributor tag to if anyone? To see a list of who has donated, go here: http://www.skylinesaustralia.com/forums/member-list.html and select the user group 'contributor' Thanks again guys!! And again, I'm sorry it took so long to sort this out.

Yeah I'll be devoting a poop load of time to it this week to get it sorted. Sorry guys, I know its as irritating as hell.

Wow Paul, great post! Its good to see people taking an interest in fixing it rather than just getting cranky! I agree wholeheartedly with you that it is MySQL. I have been playing with the conf for a few weeks now, I just cant seem to get it to a happy medium between load and speed. Re. your questions; how is the database setup, is it on localhost - Yes has anyone optimized the schemea? - Its the default IPB Schema with additional tables for mods / hacks and other things has anyone looked at the slow queruies (theres a command arg to log them) - Yep, I log all slow (>5 sec) queries to a slow query log. I just havent check it in a while). how are the indexes setup for the big tables? - Not sure, but I have checked the indexes through the admin cp of IPB and it reports no problems. if you do show process do you see much locking processes or waiting? - Only occasionally. I have been considering changing the posts table to Innodb as we dont use full text on it anymore anyway as search is taken care of by Sphinx wht about copy to tmp_table do you see much of this? - Hmmm, havent noticed. Also, I havent analyzed the database for a while, thats definately worthwhile doing. I have a few ideas for speeding the site up. Postgres wasn't one of them but I am more than happy to go down that path. I was also going to setup lighttpd to serve static content (images mainly) and have apache looking after the php side of things. You sound like you know your stuff, I'll be more than happy to give you access to the box to have a poke around if you'd like? Thanks Paul, Christian

You're nuts. Its never done that. But, I am going to be implementing some menu's up there soon to clean it up, so I can link to all the state forums. (good idea too)

That was me.

Hey chuckie, Not sure what you mean. Can you submit a screen shot? (You can open a support ticket too which will make it easier - up the top).

*cuckoo*

Hey Adz, check the IPS Driver Error issue in this forum (maybe 1 or 2 down?) I have been working on it recently.

Yeah few probs this morning ... just watching the processes now.. hopefully its ok.

Woops. maybe doubling it was a little too drastic.

Hey Paul, when did you get it last mate?

The errors were related to how many concurrent connections were made to the MySQL Server, I have just doubled the max_connections setting in the my.cnf file. I think that will make a GIANT difference. Please report in here if you get another one.

Hmmm, ok, I'll check the logs as I am trying really hard to get rid of them all.

when viewing threads or just generally?

Hey All, So sorry about this lack of response. As Dan says, I get hundreds of emails and PM's and try to get to them all in a batch. but time doesnt always permit (Uni, work and new baby). I seriously appreciate the donations, a LOT! Dont think for one minute that I dont, you guys are fantastic for donating! Col, I'll add the tag to your account, sorry mate. a20089, Sponsorship is slow atm, donations aren't "needed" but appreciated and the money always goes back into SAU, I havent ever made money from the site. The bank details are still correct. The list hasn't been updated for a while, but you can view the list of contributors by choosing the 'contributor' members group on the members page or forum leaders. MZTRBO, I did receive your donation, thank you very much. I've had some problems with emails recently, I am sure I did reply but it may not have gone through, sorry. Thanks again all, you guys rock. I'm sorry for being slack.