Gaspar Bakos schrieb:
---------- Forwarded message ----------
Date: Mon, 12 Jun 2006 11:39:11 -0400 (EDT)
From: Gaspar Bakos
To: Barry <[EMAIL PROTECTED]>
Subject: Re: my-huge.cnf quite outdated
Hello, Barry,
RE:
Guess we would answer to everyone on the list who wishes to optimize his
cnf.
I don't guess, and don't even expect that you answer to everyone.
Well if everyone would start posting "his" cnf. You would end up
confused. That's what i pointed out with it.
Sometimes it is good to guess.
"Oh, i have add super X RAMs with latencies of blah blah. Please i
think my cnf is outdated can somone help me?" Or: "Oh, i have added a
HD with 2times more rounds per/m can you update my cnf PLZ?"
These are not what I asked, they are pretty negative exaggarations.
Well yes you did. Well they are negative but in the end you will face
this. There are no typical 8GB, SATA II 2TB filesystem RAID clustered,
with high connection network card configs out there that would run
"smooothly" on your system. It's just as it is.
You have to do it by yourself.
You would be lucky as hell finding somone with the same hardware config
as you have.
And "yes". You can tweak the shit out of the mysql.cnf files.
You have to test yourself on "your" system.
This is what I am doing, and in the meantime, looking for experience,
and also sharing mine.
Experience is only gained by doing.
I did configured Server which had half a terrabyte of data and that was
no fun at all.
When you get further in this you will see that at the end you only have
two ways of accomplishing it.
Reading every manual you get about the cnf and get a hang on what every
variable do or get a customer contract and let somone configure it.
And btw. the cnf files wrk with even bigger tables than you have.
Not "optimal" but "okay".
How big?
i tested them with 350 GB files on a 4GB RAM 500GB SATA raid1 system.
And was stable.
Every special server needs special handling. there is no "the one and
only you have to do it this way" way....
OK, so why is there a my-{small,large,huge}.cnf ?
They are guidelines for typical systems and applications.
But they are quite outdated, as typical systems changed.
Because those cnf do give a push in a way you want to go but when you
want optimized configs you have to specialise it depending on the server.
That's what i said. nothing more or less
All in all: I was looking for _typical_ configs for 4GB+ machines and
100Gb+ tables.
Now guess this time. There isn't something like that.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
