[Sweeks]

Anyone confirm this to work fine on vbulletin 3.8.1?
________
Lesbian Scissoring

[Zachariah]

Yep, no poblems.

With a few changes the concept should work with any php program that accesses mySql.

[Sweeks]

Can this work around this error?

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Hope it can avoid this if possible.
________
BOX VAPORIZER

[Zachariah]

It should in theory.

max_user_connections - this limits only the number of simultaneous connections made using a single account.

• The number of queries that an account can issue per hour
• The number of updates that an account can issue per hour
• The number of times an account can connect to the server per hour
• The number of simultaneous connections to the server an account can have (as of MySQL 5.0.3)

This little bit of code takes multiple mysql user accounts (all with the same password) and spread the questions between users at random.

[bokmade]

Does It Work With web hosting limit connection ?If the limit 25 we can get 100 if four user ?

Does It Speed Up the Forum and Increase the server load ?

Thanks.

[Zachariah]

There is no harm in trying. I have not ran into this problem to test for an answer.

The number of simultaneous connections to the server an account can have are limits per account. If there are multi accounts, I would think each account has a limit of 25 vs. each database with a max limit.

Try it out and see if your problem goes away. Report back findings please .

[Frondy]

1. Create additional user(s)
Create more MySQL user/password's and give these full permissions to your database.

2. Edit you config.php, and locate the following lines (they should alerady contain the user/password for your current setup):

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

After the first 3 comment lines, add the following:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Edit mysql_username_X and mysql_password_X to have valid MySQL username/password combinations. If you need more then 3 combination, just duplicate the third line. If you are only using 2 combinations, remove the third combination.

3. Now edit the lines that configure your username password (they will probably already contain the info for the first MySQL user).
find:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

and replace them with:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

4. Check your edits, the complete block should look something like:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

5. Save and upload your config.php. Finished.

Everytime a page is opened, 1 of the defined username/password combinations will be choosen at random, and by this reducing the number of connections for each user.

I found this quoted article on vb.com site, is it the same purpose variant? ('max_user_connections' issue)


.

[MyChemicalSelf]

Thanks dude im using this

[thinkfast]

is this work for vbulletin 4?

[Zachariah]

Originally Posted by thinkfast

is this work for vbulletin 4?

Yes this should work the same.

[Alecsmith]

first of though this will make forum loading fast but after i adding more Mysql users but it made forum loading very slow

[Poker Face]

Originally Posted by Zachariah

Replace with:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

1) Make sure and replace user1, user2, user3, user4, user5, user6, user7 with the correct user names made for the database.

2) Also replace password with the correct password.

This isn't working for some reason... where does the database name 'username' get inserted or replaced, as in the original instructions?

My Database: $config['Database']['dbtype'] = 'mysqli';

[combs]

This is genius. I didn't want to change servers and Hostgator can be a real pain in the ass. I did this and the forum was INSTANTLY faster and the hundreds of errors in my email have stopped(for now..let it continue). Thanks a ton man!

[Videx]

Originally Posted by combs

This is genius.

Only until they catch you. They've limited you to 25 connections per account, not per user (which would basically be unlimited connections).