4 GM RAM - 1000 Max MySQL Connections - Knowledgebase

Portal Home > Knowledgebase > Articles Database > 4 GM RAM - 1000 Max MySQL Connections

4 GM RAM - 1000 Max MySQL Connections

Posted by DjiXas, 09-13-2008, 04:41 AM
Hey guys, I've set max mysql c. to 1000 but as techs reported, ram is being maxed out once it reaches number like this. Is this normal or 4GB of RAM should handle more of them? RAM diagnosis is not a solution I guess, cause server would be donw for quite a long time.
Posted by ub3r, 09-13-2008, 06:22 AM
You haven't given us any information about your database. If you are consuming swap, you need more memory. I recommend 8gb+ for a busy database server.
Posted by DjiXas, 09-13-2008, 06:49 AM
There are various db's there. cnf if needed
Posted by ub3r, 09-13-2008, 06:56 AM
Do you have a degree in vague posting? Have you looked at your mysql process list to see what is being done in each respective database?