just gotta remember patience is a virtue. 
Server too busy??
Originally Posted by Brains
If you're getting multiple copies, chances are very good its on your end.
Adkoonerstrator
iTrader: (4)
Joined: Nov 2001
Posts: 21,420
Likes: 0
From: Deep in the seedy underworld of Koonerville
I've been getting duplicate PM's ......maybe it's my ISP. 
Brains - I just want to publically say thanks for all your hard work over the years. I honestly am not sure this site would be what it is today without you taking care of the server and software. I can just imagine this unshowered, old stale pizza eating, jolt cola drinking, thick glasses having, old underwear wearing(only thing
), 500lb weighing dude sitting in a pitch black room staring at a bigass monitor taking care of LS1Tech....as **** plays in the backround. You anything like that? 
NOW GET TO WORK BIATCH, THE TRUCK SITE IS SUFFERING!!
......maybe it's my ISP. Brains - I just want to publically say thanks for all your hard work over the years. I honestly am not sure this site would be what it is today without you taking care of the server and software. I can just imagine this unshowered, old stale pizza eating, jolt cola drinking, thick glasses having, old underwear wearing(only thing
), 500lb weighing dude sitting in a pitch black room staring at a bigass monitor taking care of LS1Tech....as **** plays in the backround. You anything like that? NOW GET TO WORK BIATCH, THE TRUCK SITE IS SUFFERING!!
OOH....ROFL....I just fell on the floor and hit my head.
Yepper, Brian does good work. It's like he's been getting the performance of an LS7 (oracle database) from a V-TEC (mySQL) for years now.
Yepper, Brian does good work. It's like he's been getting the performance of an LS7 (oracle database) from a V-TEC (mySQL) for years now.
Originally Posted by XLR8NSS
I've been getting duplicate PM's ......maybe it's my ISP.
Brains - I just want to publically say thanks for all your hard work over the years. I honestly am not sure this site would be what it is today without you taking care of the server and software. I can just imagine this unshowered, old stale pizza eating, jolt cola drinking, thick glasses having, old underwear wearing(only thing ), 500lb weighing dude sitting in a pitch black room staring at a bigass monitor taking care of LS1Tech....as **** plays in the backround. You anything like that?
NOW GET TO WORK BIATCH, THE TRUCK SITE IS SUFFERING!!
......maybe it's my ISP. Brains - I just want to publically say thanks for all your hard work over the years. I honestly am not sure this site would be what it is today without you taking care of the server and software. I can just imagine this unshowered, old stale pizza eating, jolt cola drinking, thick glasses having, old underwear wearing(only thing
), 500lb weighing dude sitting in a pitch black room staring at a bigass monitor taking care of LS1Tech....as **** plays in the backround. You anything like that? NOW GET TO WORK BIATCH, THE TRUCK SITE IS SUFFERING!!
I hope not, if so Zangel has really low standards, maybe I need to gain some weight get a big dark room, and start drinking jolt cola.
I'd just like to say thanks to Brains too, I don't post alot but I read this board probably 10 hours a day while I'm at work talking to dumb people.
You can limit the search results if the huge amount of data being returned is the problem. How is this software not compatible with Oracle? Can you set up a mySQL db instead?
LS1 Tech Stories
The Best V8 Stories One Small Block at Time
6 Common C5 Corvette Failures and What's Involved In Repairing Them
Pouria Savadkouei
Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph
Verdad Gallardo
Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked
Pouria Savadkouei
Top 10 Most Powerful Chevy Trucks Ever Made!
Hennessey's New Supercharged Silverado ZR2 Has 700 HP
Verdad Gallardo
Coachbuilt N2A Anteros Is an LS2-Powered C6 Corvette In Italian Clothes
Verdad Gallardo
Awesome K5 Blazer Restomod Comes With C7 Corvette Power
Verdad Gallardo
10 Camaros You Should Never Buy
10 LS Engine Myths That Refuse to Die
Verdad Gallardo
TECH Veteran
Joined: Dec 2004
Posts: 4,012
Likes: 1
From: Beaumont, TX
Originally Posted by ArcticZ28
You can limit the search results if the huge amount of data being returned is the problem. How is this software not compatible with Oracle? Can you set up a mySQL db instead?
Last edited by ACW; Jul 13, 2005 at 07:44 PM.
Originally Posted by ACW
Ummm... This is a mySQL database; that's the only type of database which vBulletin currently supports, which is the problem. And search results have been limited to 250 items for quite a while (if not from day one), but it still has to look through a lot to find those.
I've got the database server about as optimized as you can get. It runs with less than 4 meg of free memory, and less than 9 meg of total swap usage 
It trucks along really well until there's a query that does something that takes a long time (search, typically, since its looking at data that won't be in the query cache, and scans the largest index on the table). Once a big query comes in, if someone puts in a request that locks the table (ie. new post, edit post, delete post) then everything stacks up behind that request and waits. The more connections you allow, the longer it takes before the site becomes responsive again. Make the connection count too low, and you see the dreaded "there has been a slight problem with the database" message.
It trucks along really well until there's a query that does something that takes a long time (search, typically, since its looking at data that won't be in the query cache, and scans the largest index on the table). Once a big query comes in, if someone puts in a request that locks the table (ie. new post, edit post, delete post) then everything stacks up behind that request and waits. The more connections you allow, the longer it takes before the site becomes responsive again. Make the connection count too low, and you see the dreaded "there has been a slight problem with the database" message. 
Originally Posted by 777
The sites running a lot faster for me today. Did you make any changes or is there just less activity?
964 (455 members and 509 guests) yesterday i saw 800 something when it was sluggish
There's a higher number of guests online right now, which are typically search engine robots. We disabled search for non-members, which means search engines can't use search (ie. view all posts by xyx user), and are forced to simply follow threads -- MUCH less taxing on the system.