vb.org Archive - What does this routine do??? Forum error from it...

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - What does this routine do??? Forum error from it... (https://vborg.vbsupport.ru/showthread.php?t=42924)

Tim Wheatley

08-29-2002 09:17 PM

What does this routine do??? Forum error from it...

Hi,

When my forums get busy I get an error saying too many connections to line 38 of db_mysql.php

Line 38 is this line:

Code:

$this->link_id=mysql_pconnect($this->server,$this->user,$this->password);

Of this routine:

Code:

function connect() {

    global $usepconnect;

    // connect to db server



    if ( 0 == $this->link_id ) {

      if ($this->password=="") {

        if ($usepconnect==1) {

          $this->link_id=mysql_pconnect($this->server,$this->user);

        } else {

          $this->link_id=mysql_connect($this->server,$this->user);

        }

      } else {

        if ($usepconnect==1) {

          $this->link_id=mysql_pconnect($this->server,$this->user,$this->password);

        } else {

          $this->link_id=mysql_connect($this->server,$this->user,$this->password);

        }

      }

      if (!$this->link_id) {

        $this->halt("Link-ID == false, connect failed");

      }

      if ($this->database!="") {

        if(!mysql_select_db($this->database, $this->link_id)) {

          $this->halt("cannot use database ".$this->database);

        }

      }

    }

  }

NTLDR

08-29-2002 09:19 PM

It means that more people are trying to connect to the MySQL database than your host is currently allowing.

Line 38 is the line that first tries to connected to the DB I would guess.

Tim Wheatley

08-29-2002 09:22 PM

Ok, for my sake can someone inform me what I need to tell my host to allow for me? They say they'll provide pretty much anything asked of them and will keep the server infront of where we need it, but this is really starting to bug both the members and myself. It's happening a lot...

On average the board gets 2000 members coming per day, at one time we get a maximum of 300 online at once. SQL usage runs from 00.05 to 02.00 when REALLY busy.

NTLDR

08-29-2002 09:25 PM

You need to ask you host to increase the maximum simultaneous MySQL connections that you are allowed.

Tim Wheatley

08-29-2002 09:27 PM

Any idea of a figure I can give to them?

I really appreciate you replying to this, thank you. :D

NTLDR

08-29-2002 09:34 PM

To be honest, no, as I don't know what the current value would be.

However it would be a good idea to make sure that it is higher than the maximum number of users & guests on at anyone time.

All times are GMT. The time now is 07:04 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01049 seconds Memory Usage 1,717KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: