Mysql performance isssue
 

In the evening the database becomes very unresponsive and often it rejects new connections with 'Too many connections'. How would you analyze and solve this problem?

No idea, since you provide NO DETAILS at all. Version of MySQL? Linux? Number of users? How are they hitting the database? What have you done/tried??

And this also sounds very much like a verbatim homework question, like your other thread. Have you done ANY research on how to diagnose MySQL problems???

Please let us know some details about your configuration so we can better help you...

OS = ?
RAM = ?
VM or Physical = ?

How many users / applications are hitting your database in the 'evening' when you see this issue? Can you use 'ps' in command line and show us your processes running on the problem system?

Also let us know what version of MySQL you're using.

Start with raising the limit of connections, but if your database is slow now, it's going to be even slower - it just won't display connect errors anymore.

in my.cnf

Per the LQ Rules, please do not post homework assignments verbatim. We're happy to assist if you have specific questions or have hit a stumbling point, however. Let us know what you've already tried and what references you have used (including class notes, books, and Google searches) and we'll do our best to help. Also, keep in mind that your instructor might also be an LQ member.

Doing a little bit of (ironically) googling shows that this is more like a section from a Google e-mail interview questionaire.

Ah I'm guessing that's why the OP didn't respond w/ specifics. It's just a homework question or generic scenario it seems...

you can add the specification of hardware RAM, Processor and hard drive, and maintenance the user connection

Yes, they OP was asked all of that previously. See posts #2 and #3.