.
VR
Cancer's Journal


Cancer's Journal

THIS JOURNAL IS ON 502 FAVORITE JOURNAL LISTS

Honor: 130    [ Give / Take ]

PROFILE




8 entries this month
 

MySQL

01:15 Jun 26 2009
Times Read: 969


If you are not a database admin, skip this entry. It'll be gibberish to you.



I had MySQL nice and tuned more than 6 months ago. Everything was swell.. Fast queries and low server loads.



Last week I converted some heavy usage tables over to InnoDB from MyISAM. I did this so I could add numerous foreign keys and utilize referential integrity (cascading updates and deletes).



After the conversion from MyISAM to InnoDB tables, mysqld CPU utilization, as reported by top, jumped from around 5% to 80+%. Queries started dragging out..



No doubt this was due to the foreign keys, but I wasn't expecting such a large hit on performance. I've since gotten mysqld CPU utilization to hold under 40% (during peak periods) by adjusting 3 MySQL variables: table_cache, query_cache_limit, and sort_buffer_size.



Query_cache_limit I reduced by 100%. Sort_buffer_size I reduced by 75%. Table_cache I increased by 50%.



MySQL can be soooo touchy...


COMMENTS

-



birra
birra
01:31 Jun 26 2009

All DB applications can be touchy like that.



I could share some of my MS-Sql experiences.. but I think there has been far too much geek-speak in this journal entry already...





voodoochile
voodoochile
02:18 Jun 26 2009

Not exactly my strong suit (troubleshooting MySQL), but if I might ask, did you get your tweaks from the MS database help white pages, your own experimentation or a fix it site? Just curious...





Cancer
Cancer
03:17 Jun 26 2009

I'm pretty familiar with what each MySQL variable does.





Morrigon
Morrigon
13:56 Jun 27 2009

MySQL Should just go home crying to his momma.



Cancer doesn't read the help pages, the help pages come to Cancer for help and then don't understand what he's talking about.





 

Radu

19:59 Jun 24 2009
Times Read: 1,043


radu



Kismet: So many people asking for re-rates.






Well, yeah. Your rating is now the most valuable on the site. It's worth close to twice as much as a regular Sire.

COMMENTS

-



CryingMist
CryingMist
20:47 Jun 24 2009

*nods freneticly* I agree





radu
radu
21:05 Jun 24 2009

I find it funny that people who say they do not like me are asking me to re rate them.





MBK
MBK
21:47 Jun 24 2009

Notwithstanding it is worth almost twice as much as yours. ;P





vines
vines
01:43 Jun 25 2009

I've never asked anyone to re-rate me. and i got a of low rates. lol, Maybe cancer you should change the age limit to 25.





vines
vines
01:44 Jun 25 2009

opps my bad i forgot to put the word lots in there. I'll blame the coffee.





MillesVisages
MillesVisages
02:26 Jun 26 2009

Love the page High Sires





 

Kismet

01:10 Jun 24 2009
Times Read: 1,109


MooniePie



Kismet: Remember only you can prevent block penalities. So don't be a prick.


COMMENTS

-



MooniePie
MooniePie
02:12 Jun 24 2009

hahaha



I feel all speshial.





MBK
MBK
02:39 Jun 24 2009

Best words I've heard all day.





atyourwindow
atyourwindow
08:54 Jun 24 2009

short and to the point , just like da moonies hehe





Nightgame
Nightgame
16:57 Jun 24 2009

The truth stares all in the face with this one :)





 

She Never Met An Update She Liked

00:05 Jun 24 2009
Times Read: 1,141


nobodysfallenangel



kismet: What the fuck with these updates? FUCK THIS!


COMMENTS

-



Quinto
Quinto
00:13 Jun 24 2009

lol





Fallenxx
Fallenxx
01:03 Jun 24 2009

oooh ok..lol





xRobin3x
xRobin3x
01:03 Jun 24 2009

some people just can't get a clue....



i think the updates are just fine......



but i have a ponder for the auto coffee pot beam button to refill my coffee cup comes in............



O_O (j/k)





imagesinwords
imagesinwords
01:23 Jun 24 2009

LOL





CuRsEdToDaRkNeSs
CuRsEdToDaRkNeSs
02:02 Jun 29 2009

LMAO! Thats all I can say..... LMAO!





 

Kismets That Rock

20:53 Jun 23 2009
Times Read: 1,184


DarkxLord1985



Kismet: Yay for people getting stressed over being blocked






I gotta say, I really love the new kismet feature. Sometimes I just read the Who's Online page from top to bottom.

COMMENTS

-



PandorasBx
PandorasBx
20:54 Jun 23 2009

It IS quite entertaining lol.....I love it too.





HAWK2K
HAWK2K
21:13 Jun 23 2009

Hell.... it's better then watching Comedy Central!



and as for the Blocking.....



it don't bother me one bit!



:D





voodoochile
voodoochile
22:33 Jun 23 2009

The blocking thing is just incentive to be nice and not such a...well, you know. So yeah, I am digging it too. Thanks man, these improvements on the site simple are the best in my years here.





Cancer
Cancer
23:26 Jun 23 2009

voodoochile, you hit it on the head. Be a prick if you want, but it will come out of your status ;)





MorbidTendencies
MorbidTendencies
14:43 Jul 09 2009

LMAO! I agree with you. it is funny when you take over a profile and the last person has like alot of blocks on there... that says something to ya about them.. LOL oh well.



I love the updates





 

LOL

02:39 Jun 23 2009
Times Read: 1,243


MistressReznor



Kismet: That figures... I reach Sire & the whole system changes :(






LOLOLOLOLOLOLOLOLOLOLOLOLOLOL

COMMENTS

-



DreamlessNight
DreamlessNight
02:46 Jun 23 2009

lol.



Ironic huh?





Morrigon
Morrigon
02:48 Jun 23 2009

That's an evil laugh, isn't it?





ThothLestat
ThothLestat
02:51 Jun 23 2009

that's harsh, man.... Restructuring the ENTIRE status system to foil the attempts of a single VR member.



Deeeeevious.

*snicka*





NocturnalMistress
NocturnalMistress
02:53 Jun 23 2009

xD

That.. is... toooooo FUNNY!






ladySnowStrixx
ladySnowStrixx
03:16 Jun 23 2009

Sits in corner ,biting nails ......wonder what he,s gonna change next? @ @"

~"





Nightgame
Nightgame
13:10 Jun 23 2009

I love the Kismet- such an interesting peek into the minds of others.





 

She can't write, but she can't read

21:00 Jun 19 2009
Times Read: 1,320


This is funny:



https://www.youtube.com/watch?v=z0xhpG0v298


COMMENTS

-



Morrigon
Morrigon
21:06 Jun 19 2009

Hey shuddup!





BLOODLIFE
BLOODLIFE
23:17 Jun 19 2009

She just doesn't care :-p





birra
birra
23:37 Jun 19 2009

She's just helping you debug table size limits...





Morrigon
Morrigon
23:39 Jun 19 2009

Yeah, now you know that the new journal comment system can take a LOT.





DragonWolf
DragonWolf
23:51 Jun 19 2009

OMG!...that is just so funny, lol





atyourwindow
atyourwindow
09:54 Jun 20 2009

omg! poor morrigan!....lmao!





DreamlessNight
DreamlessNight
15:53 Jun 20 2009

O.o

-snickers-





xRobin3x
xRobin3x
02:50 Jun 23 2009

lol.......ouch......





NoctusAngelusProcella
NoctusAngelusProcella
17:52 May 04 2011

wow wish I had that problem, lol I would like to have that many people comment in my journal.





 

WTF?

17:36 Jun 18 2009
Times Read: 1,386


I've been spending a lot of time programming the past 3 weeks. Most days I'm at the computer at least 8 hours... Sometimes 12.



My right forearm is hurting. It's acting like it's because of all my typing, the pain is local and it throbs with each keystroke.



Typing pain? WTF? I must be out of shape...



Going to go flying, then come back in a few hours and release a new Vampire Rave update...


COMMENTS

-



atyourwindow
atyourwindow
17:42 Jun 18 2009

geez take a break every now and then, your no good to us if ya cant type lol





IExist
IExist
17:47 Jun 18 2009

I can't wait for the new update.





ladySnowStrixx
ladySnowStrixx
17:51 Jun 18 2009

Sorry to hear about your Arm, Try soaking it in warm water and ebsoms salt , , and every so often straighten out your arm for a few minutes. I also have this problem every so often.





voodoochile
voodoochile
17:53 Jun 18 2009

Have a great flight :) Oh and take some pictures if you are able to. I know everyone would love to see them.





Morrigon
Morrigon
18:11 Jun 18 2009

Heh geez...



"Oh all this typing is taking its toll on my body. I suppose I'll go take a quick fly in my airplane and then go back to brilliant programming."



Make sure you don't O.D. on any badassary while you're out there.



Sounds like you need a shoulder massage and more breaks.





RazrTheHollowAngel
RazrTheHollowAngel
19:22 Jun 18 2009

Don't over do it boss....Hope you had fun flying and can't wait to see new update





Daire
Daire
01:17 Jun 19 2009

Face it, you are getting old. Typing is a young persons game.





Cancer
Cancer
02:36 Jun 19 2009

Spelling must be an old PERSON'S game.



Person is singular. Persons is plural. You were using a possessive tense.



Idiot.





Daire
Daire
02:51 Jun 19 2009

Pffffft. Shove your " 's ". I ain't got time to be dottin every i and crossin every t.





BLOODLIFE
BLOODLIFE
09:28 Jun 19 2009

Luv the Dashboard .. is it based on a cockpit? :-p

It's good to get an overview at a glance.





DreamlessNight
DreamlessNight
20:27 Jun 19 2009

LMAO...Daire.



i get it too Boss. just stretch every 15-25 min.








COMPANY
REQUEST HELP
CONTACT US
SITEMAP
REPORT A BUG
UPDATES
LEGAL
TERMS OF SERVICE
PRIVACY POLICY
DMCA POLICY
REAL VAMPIRES LOVE VAMPIRE RAVE
© 2004 - 2024 Vampire Rave
All Rights Reserved.
Vampire Rave is a member of 
Page generated in 0.0676 seconds.
X
Username:

Password:
I agree to Vampire Rave's Privacy Policy.
I agree to Vampire Rave's Terms of Service.
I agree to Vampire Rave's DMCA Policy.
I agree to Vampire Rave's use of Cookies.
•  SIGN UP •  GET PASSWORD •  GET USERNAME  •
X