Joined: Jan 31, 2004 Posts: 1769 Location: NH, USA XP: 171,140
Posted: Tue Jun 15, 2010 6:32 am Post subject:
Databaes optimized! Thanks for the feedback guys! _________________________________________________________ 10% VIP Discount (Coupon Code: HQ-VIP-001 ) - Signup for web hosting at www.TweakedHosting.com/clients/aff.php?aff=004 and earn the HQ network of sites recurring income!
forahobby Administrator
Joined: May 22, 2003 Posts: 23948 Location: NSW, Australia XP: 3,060,914
Posted: Tue Jun 15, 2010 6:40 am Post subject:
dw5304 wrote:
yea im aware of what the issue is im am a network admin deal w/ this type of stuff all the time;).
i know you are you legend..
I forgot to mentioned thanks to dw5304 for mentioning that..
I had to duck out and pick up my car from the mechanic.. haha (again) _________________________________________________________ HQ Network:
www.xbox-hq.com | www.xboxone-hq.com | www.360-hq.com | www.c64-hq.com
tweaked V.I.P. Lifetime
Joined: Jan 31, 2004 Posts: 1769 Location: NH, USA XP: 171,140
Posted: Tue Jun 15, 2010 6:33 pm Post subject:
The database side of things are all set. Working like a charm! _________________________________________________________ 10% VIP Discount (Coupon Code: HQ-VIP-001 ) - Signup for web hosting at www.TweakedHosting.com/clients/aff.php?aff=004 and earn the HQ network of sites recurring income!
forahobby Administrator
Joined: May 22, 2003 Posts: 23948 Location: NSW, Australia XP: 3,060,914
Posted: Thu Jun 17, 2010 4:19 am Post subject:
tweaked wrote:
The database side of things are all set. Working like a charm!
I have to agree mate.. Fantastic job as always.
It's really smooth now, I can't believe the difference!
@ everyone else,
if you need a good host.. Click the link in my sig..
Tweaked will look after you. Great rates and support. _________________________________________________________ HQ Network:
www.xbox-hq.com | www.xboxone-hq.com | www.360-hq.com | www.c64-hq.com
tweaked V.I.P. Lifetime
Joined: Jan 31, 2004 Posts: 1769 Location: NH, USA XP: 171,140
Posted: Thu Jun 17, 2010 5:30 am Post subject:
Well, I have been watching things for years now. I always observed how the database was hogging and clogging other things like http/php and mainly stealing CPU power just because of drive access. The server has 8 processing cores with a total of 16 processing threads so it was still doing quite well this way but I thought it was time to address things. Now I can't just put faster drives in without redoing everything so I setup a second server with 15000 RPM drives in RAID which is handling all databases and sql queries for the HQ sites. The 2 servers are connected via private LAN on 1000Mbit ports.
To this put in perspective: In 2 days the HQ database has processed over 2000 GB of data transfer between the 2 severs. So 30 days will mean like more than 60 terabytes of data use. That translates into an amazing amount of drive IO being saved on the web server of the HQ sites. IO is now zero most of the time on the Hq web server now.
So too the load averages are now only about 1 for the processors which means most of the CPU cores are now napping allot. This is good in another thought, heat generated by the processors will be significantly less saving hardware life and energy. Oh and now there is much more of the 12 GB RAM available to the web server too. Yeahoo
I love it when things go good _________________________________________________________ 10% VIP Discount (Coupon Code: HQ-VIP-001 ) - Signup for web hosting at www.TweakedHosting.com/clients/aff.php?aff=004 and earn the HQ network of sites recurring income!
tweaked V.I.P. Lifetime
Joined: Jan 31, 2004 Posts: 1769 Location: NH, USA XP: 171,140
Posted: Thu Jun 17, 2010 8:44 am Post subject:
It is actually about 2000 GB a day not every 2 days but 60 terabytes is right. _________________________________________________________ 10% VIP Discount (Coupon Code: HQ-VIP-001 ) - Signup for web hosting at www.TweakedHosting.com/clients/aff.php?aff=004 and earn the HQ network of sites recurring income!
dw5304 V.I.P. Lifetime
Joined: Feb 28, 2006 Posts: 80 Location: USA XP: 4,684
Posted: Thu Jun 17, 2010 4:55 pm Post subject:
next step solaris and zfs .
lol hobs knows what im talking about.
tweaked V.I.P. Lifetime
Joined: Jan 31, 2004 Posts: 1769 Location: NH, USA XP: 171,140
Posted: Thu Jun 17, 2010 6:59 pm Post subject:
I like that Solaris XFS is 128 bit file system. Puts 64 bit to shame in capabilities. We couldn't afford the hardware to make it worth while though for the HQ sites at this time but who knows, in time maybe we can. _________________________________________________________ 10% VIP Discount (Coupon Code: HQ-VIP-001 ) - Signup for web hosting at www.TweakedHosting.com/clients/aff.php?aff=004 and earn the HQ network of sites recurring income!
dw5304 V.I.P. Lifetime
Joined: Feb 28, 2006 Posts: 80 Location: USA XP: 4,684
Posted: Thu Jun 17, 2010 7:12 pm Post subject:
lol u can just install over the current os ... really dont need more hardware...
p.s. been running zfs now for 3 years never failed me yet.
Code:
naszfs06162009:~# zfs list
NAME USED AVAIL REFER MOUNTPOINT
backup 483G 5891G 20K /mnt/backup
backup/data 483G 5891G 483G /mnt/backup/data
ext 483G 5891G 22K /mnt/ext
ext/data 483G 5891G 483G /mnt/ext/data
main 484G 5887G 484G /mnt/main
Joined: Jan 31, 2004 Posts: 1769 Location: NH, USA XP: 171,140
Posted: Thu Jun 17, 2010 9:29 pm Post subject:
Sounds nice. This will be great to use on fileservers. Something new to start testing. I think I'll setup a test network using this and have some fun with it.
Thanks for turning me on to this. _________________________________________________________ 10% VIP Discount (Coupon Code: HQ-VIP-001 ) - Signup for web hosting at www.TweakedHosting.com/clients/aff.php?aff=004 and earn the HQ network of sites recurring income!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
HQ Network: 9,769 | 
Guests: 4102 |
Members: 0
