Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

MySQL Community Capability

Hi Guys,

Please advise.

Currently we have Alfresco instance with MySQL Community. Alfresco is a document management system. Currently the it only has 20 users. We're planning to use this system with 1000 users.

What I want to ask is, does MySQL Community Edition will be sufficient for this? or do we need to subscribe to MySQL Enterprise?

I'm worried that MySQL CE won't be able to handle request from 1000 users.

Please advise based on your own experience.

Thanks
0
softbless
Asked:
softbless
4 Solutions
 
Steve BinkCommented:
It should be able to handle it just fine, but you might need to tune your MySQL installation for performance.  
0
 
Muhammad WasifCommented:
You need to go for MySQL Enterprise. MySQL Enterprise is a subscription-based service produced by MySQL AB (now Oracle) and targeted toward the commercial market. Check the product comparison.

I am managing too much traffic with MySQL of a portal with MySQL community edition. Hire a good DBA with experience of performance tuning if there is any problem.
0
 
Muhammad WasifCommented:
Typo in the last comment. It should read
You don't need to go for MySQL Enterprise. MySQL Enterprise is a subscription-based service produced by MySQL AB (now Oracle) and targeted toward the commercial market.
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
As per my knowledge, there is no hardlimit for the MySQL server, be it Community edition or Enterprise Edition.  But certianly your operating system and available resources can restrict the number of concurrent connections.

As you might be aware of the fact that MySQL for each connections can allocate memory up to the value of sort_buffer +  the value of the read_buffer_size.

Also, OS restricts for the max process and open file limits thus forcing MySQL to restrict for allowing more connections(one can notice too many connections etc).

0
 
softblessAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now