Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Usually I will make 1 MySQL user for every database, instead 1 MySQL user for all database.

but I just wonder.. does more MySQL user will require more CPU & memory usage?

share|improve this question
add comment

2 Answers 2

Simply put NO..

The amount of users is not comparable to memory or cpu..

In fact, to get to the point..

It is the amount of connections ( which use MEMORY ) and What those connections are doing ( Which use CPU )

Usually a connection/thread is capable of maximising 1 cpu core

Hope this helps :)

share|improve this answer
add comment

More Memory: Yes, though not in a relevant area.

More CPU: similar.

Multiple logins, multiple open connections e tc. - but at the end not in a range that is relevant compared to query processing and caching. I actually doubt you will be able to measure the higher use outside of lab scenarios (hundreds or thousands of users with no real load) designed to measure exactly this.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.