Question about mysql queries

[Darkknight550]

Hi, I'm new to mysql and was wondering how you can check the amount of queries your site is useing?

I'm wondering why because I'm getting ready to move a site with over 2000 members and 14,000 topics. With 10-15 members on at a time. The forums are useing phpbb right now and I'm wanting to move them to yabbse. I'm just wondering If i'll hit powwebs mysql limits.

Any help would be appreciate.

Thanks Darkknight550

[HalfaBee]

There is no way to find out how many connections or queries you use. You could probably hack yabbse to count connections and queries.
I hacked a custom program for one site and just had a table storing a row for every connection and query and deleteing the old rows after 1 hour. The count() of the table gave the hits/hour.

It may be available after mysql has finished writing the manual and mysql goes production.

With 15 users on at a time and rotating users they would be able to view 240 pages per hour ( depending on the number of queries per page.

If this is not enough you can rotate users and multiply this by 3.

HalfaBee

[Storms]

Do you mean that each can see 270 pages per hour or is that the total?

A) 270 pages per hour
B) 270 pages x 15 users

How many queries per user per page have you used in this calculation?

regs

[HalfaBee]

I assumed 10 queries per connection.

240 page views per person per hour

240*15 = 3600 connections;

3600*10 = 36000 queries.

I had a quick look at yabbse and it would need all the php pages checked for queries to get a total count of the queries.

So rotating 3 users would give 30 queries per connection.

HalfaBee