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...
radu
Kismet: So many people asking for re-rates.
COMMENTS
*nods freneticly* I agree
I find it funny that people who say they do not like me are asking me to re rate them.
Notwithstanding it is worth almost twice as much as yours. ;P
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.
opps my bad i forgot to put the word lots in there. I'll blame the coffee.
Love the page High Sires
MooniePie
Kismet: Remember only you can prevent block penalities. So don't be a prick.
COMMENTS
hahaha
I feel all speshial.
Best words I've heard all day.
short and to the point , just like da moonies hehe
The truth stares all in the face with this one :)
nobodysfallenangel
kismet: What the fuck with these updates? FUCK THIS!
COMMENTS
lol
oooh ok..lol
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)
LOL
LMAO! Thats all I can say..... LMAO!
DarkxLord1985
Kismet: Yay for people getting stressed over being blocked
COMMENTS
It IS quite entertaining lol.....I love it too.
Hell.... it's better then watching Comedy Central!
and as for the Blocking.....
it don't bother me one bit!
:D
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.
voodoochile, you hit it on the head. Be a prick if you want, but it will come out of your status ;)
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
MistressReznor
Kismet: That figures... I reach Sire & the whole system changes :(
COMMENTS
lol.
Ironic huh?
That's an evil laugh, isn't it?
that's harsh, man.... Restructuring the ENTIRE status system to foil the attempts of a single VR member.
Deeeeevious.
*snicka*
xD
That.. is... toooooo FUNNY!
Sits in corner ,biting nails ......wonder what he,s gonna change next? @ @"
~"
I love the Kismet- such an interesting peek into the minds of others.
This is funny:
https://www.youtube.com/watch?v=z0xhpG0v298
COMMENTS
Hey shuddup!
She just doesn't care :-p
She's just helping you debug table size limits...
Yeah, now you know that the new journal comment system can take a LOT.
OMG!...that is just so funny, lol
omg! poor morrigan!....lmao!
O.o
-snickers-
lol.......ouch......
wow wish I had that problem, lol I would like to have that many people comment in my journal.
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
geez take a break every now and then, your no good to us if ya cant type lol
I can't wait for the new update.
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.
Have a great flight :) Oh and take some pictures if you are able to. I know everyone would love to see them.
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.
Don't over do it boss....Hope you had fun flying and can't wait to see new update
Face it, you are getting old. Typing is a young persons game.
Spelling must be an old PERSON'S game.
Person is singular. Persons is plural. You were using a possessive tense.
Idiot.
Pffffft. Shove your " 's ". I ain't got time to be dottin every i and crossin every t.
Luv the Dashboard .. is it based on a cockpit? :-p
It's good to get an overview at a glance.
LMAO...Daire.
i get it too Boss. just stretch every 15-25 min.
COMMENTS
-
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
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
03:17 Jun 26 2009
I'm pretty familiar with what each MySQL variable does.
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.