Posted by Jerry Stuckle on 11/15/07 19:06

Pseudonyme wrote:
> .... "Some people, for instance, play with MySQL but don't know how to
> tune it well for a heavy load." ...
>
> That might be right.
>
> Problem is to give all access to Serverwizar for instance with the
> background of a guy :
> http://216.239.59.104/search?q=cache:1gQ6io6YCOcJ:www.namepros.com/warnings-and-alerts/267727-serverwizards-sucks.html+serverwizards&hl=en&ct=clnk&cd=2
>
> where they basically broke everything.
>
> "Server Wizar : We Never Sleep. We Never Eat. We Do Magic.". >>
> What's that ?
>
> In the Admin we trust ... but in someone secured.
>
> *****
>
> MYSQL :
> If I divide by 10 the weight of threads, multiple by 10 the weight of
> cache, multiple by 10 the number of threads, multiplie by 10 the
> number the simultaneous connections.
> I multiplie by 10.000 the available data in theory.
>
> Is there an option to apply that theory ?
> http://groups.google.com/group/comp.databases.mysql/browse_thread/thread/aee95d485b92977c?hl=en#717aaead47c4b27b
>
> My Regards
>
> Bob
>
>

Bob,

I can't help you a lot on that. Most of my experience with heavily
loaded systems is with DB2, which is completely different than MySQL in
tuning. I can tune MySQL and get good performance out of it, but it's
more hit and miss, and I probably don't get the best performance. Just
"good enough".

And when I do, I always start with the Optimizing chapter in the MySQL
documentation. It's got some really great information in it.

So I really hesitate to give you any guidance. It probably would be
worth exactly what you paid for it :-)

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]