mysql quesions.

[locos]

ive been doing some traveling and havnt been able to get to the forums in a good while. i just read that powweb limited the amout of mysql we can use. well, im not so sure i understand this. would it be possible for some one to explain what this means to me in lamen terms ? for instance what does the 3 connections at 36000 views mean ?

i have a fairly busy ikonboard forum on my site and im now worried about it.

[HalfaBee]

You are allowed 3600 connections ( mysql_connect() ) per hour and 36000 mysql "SELECT " statements per hour.

You are allowed 3 mysql users ( defined in ops ).
Each user can have the 3600 connects and 36000 queries.

If your IB is still working OK there shouldn't be a problem.

If it stops working it should start up as soon as the hour is up.

Rotating users is a way to easily keep your IB forum up.

HalfaBee

[locos]

but what does that mean for my visitors ? does it mean that if it gets 3600 views in one hour it will go down ? im confused.

[HalfaBee]

Yes thats right 3600 per hour or 10,800 if you rotate the 3 users.

Thats 259,200 views per day with 3 users.

Hopefully your site is under that.

HalfaBee

[locos]

im sorry, i just dont get it. my site has way more than 3 users. thats the part i dont understand. my ikonboard forums get about 100 visitors per day. way more than the 3 everyone keeps mentioning. this is what i dont understand.....

[RadioRob]

The user that is being refered to is the MYSQL username/password. Remember in OPS when you created your mySQL database? How you had to pick a username/password for your database?

That's what is being talked about. PowWeb lets each database have a total of 3 unqiue username/passwords. Ikonboard uses one name. If you were sharing your database with another script, you might use a different username/password (settable in mySQL area in OPS), so you don't have both programs sharing the same limit.

Hope that helps. :)