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.

MySQL 5.1.x

What is the cost of an account on disk when it is created in MySql? Also, what is the max number of accounts you can create?

share|improve this question

2 Answers 2

up vote 5 down vote accepted

What is the cost of an account on disk when it is created in MySql?
Practically nothing (a few K to create the rows in the Grant tables).

what is the max number of accounts you can create?
Practically unlimited (the Grant tables can't exceed the maximum number of rows in a table, for which there is no upper limit in modern InnoDB tables, but for obscenely large numbers of rows you may have performance problems. The chance of you having that many users / GRANTs is so small as to be a non-factor in capacity planning).

share|improve this answer
    
Awesome. Thank you. –  Mike B Apr 23 '12 at 19:33

MySQL accounts are stored in the user table of the mysql database. You are only limited by the amount of drive space you have. The disk cost is equal to the size of the row.

share|improve this answer
    
Thank you very much. –  Mike B Apr 23 '12 at 19:33

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.