MySQL performance

[Alan DeKok]

Lorenzo Milesi wrote:
>> Then it must be magic. Hire a wizard to fix the problem.
> 
> Thanks, your sarcasm is really helpful!

  It seems to work better than honest suggestions.  You've ignored those.

> I *DID* say what I did: increased the amount of accounted users, nothing else.

  The *default configuration* doesn't have the problem you described.
So... what did you change?  "adding users" is *not* the answer I'm
looking for.

> I said what changes I did to the server in order to improve mysql performance.

  You edited radiusd.conf to improve MySQL performance?  That's magic.

> This doesn't look to me like saying "it doesn't work".

  It looks to me like that, which is why I said it.

> And on the other hand, if I haven't been detailed enough you could have asked more specific questions, and I would have answered. Instead of wasting time trolling at me. I haven't been trolling, I didn't say "this software sucks", I just asked for help for a specific problem. So either help and it'll be appreciated, or I'd suggest you to save your time and read other mails.

  I asked specific questions.  You evaded answering.

  Again, the default configuration doesn't have this problem.  *You*
changed the configuration.  What was it?  Saying "I added more users" is
a ridiculous response, and deserves a ridiculous answer.

  If the server is taking 1s to respond, *something* is blocking it.
That something is almost always an external script, or the DB.  Saying
"the DB log doesn't show slow queries" is a lazy answer.  It means you
didn't bother checking for yourself whether or not the DB was slow.

  The *RADIUS* server likely thinks the DB is slow.  I don't care what
kind of lies the DB log tells you.  Go check for yourself.

  If you're not going to *think* in order to track down the problem, you
have no hope of fixing the problem.

  Alan DeKok.