Jump to content

Database capscity calculation : Queries per page... ?


inversesoft123

Recommended Posts

As we know the total number of hits to database is proportional to the number of page views if page views * queries per page is more than the capacity of your database, then mysql queries may show  problem.  is there any way to calculate the database capacity ? I googled someone says 128Mb cache is there for mysql.

Link to comment
Share on other sites

I think that would be limited by the server's memory allocation.  The more memory, the more supported users.  I think phpBB forums use around 20 queries per page, and some of those are very busy.

 

As far as capacity, the documentation says that there are known databases with 2K tables, and over 5B rows.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.