Announcement

Collapse
No announcement yet.

MySQL Connections (want to buy vB)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Connections (want to buy vB)

    Hello,

    i would like to buy vB 2, but i have to know if it would work with my provider ("Schlund & Partner").

    The board i use at the moment counts about 10.000 Views/day.

    And there are about 30-50 users online at the same time (last 10 minutes).

    The limits of my provider are:

    - max. 12.000- 15.000 Mysql Queries / hour
    - max. 12 parallel Mysql connections

    Is it possible may to run vBulletin on 2 Mysql databases?

    thanks!

  • #2
    4.167 queries per second!! and 12 max_connections

    your host is very restrictive and you will have problems with any php/mysql based forum including vbulletin

    i suggest you find a better host as that is very restrictive for any php/mysql forum script

    as to 2 databases - you mean 1 vb forum using 2 databases ? vB uses 1 database for 1 installation
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      I use at the moment a PHP4/MySQL board (dynamicboard.de) and i have at the moment about 2000 connections and 15.000 queries at the moment.

      Comment


      • #4
        with vB you can in config.php turn off persistent connections (pconnect = 0) to ease the 12 max_connections limit your host set

        how many new posts/threads per day are you getting with those 50 users online ?
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment


        • #5
          Per day about 30 new threads and about 300 replys.

          Comment


          • #6
            Originally posted by webmaster20923
            Per day about 30 new threads and about 300 replys.
            hmmm you should be okay... but it's hard to say how different vB would perform compared to your current forum script in terms of mysql usage

            also from my experience moving to vBulletin has the effect of increasing member activity since it's generally a faster forum script ...

            my ezboard use to get 3900 posts in 10 months with 200 members

            changing to vB i get 1300 - 2400 new posts each day and 30 - 150 new members per day
            :: Always Back Up Forum Database + Attachments BEFORE upgrading !
            :: Nginx SPDY SSL - World Flags Demo [video results]
            :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

            Comment


            • #7
              How much queries will be done per 1 connect ?

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X