Professional Web Applications Themes

Should I use mysql_connect() or mysql_pconnect() ? - MySQL

If wondering the site has many con-current users, use of persistent connection might block new user from connecting? For heavy loaded site, which one is better?...

  1. #1

    Default Should I use mysql_connect() or mysql_pconnect() ?

    If wondering the site has many con-current users, use of persistent
    connection might block new user from connecting?

    For heavy loaded site, which one is better?

    howa Guest

  2. #2

    Default Re: Should I use mysql_connect() or mysql_pconnect() ?

    "howa" <com> wrote: 

    In almost all cases pconnect() causes more problems than it solves.

    http://groups.google.com/group/comp.databases.mysql/msg/e843f0b9e59ad710


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

    Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
    MySQL User Forums: http://forums.mysql.com/
    Axel Guest

  3. #3

    Default Re: Should I use mysql_connect() or mysql_pconnect() ?

    >If wondering the site has many con-current users, use of persistent 

    If you have a maximum of N Apache processes (this is an Apache
    setting, and may be much larger than the actual number of simultaneous
    hits), K different db_host / username / password / db combinations
    on your pages, and you use persistent connections, then you'll
    eventually have N*K connections, and MySQL had better be able to
    handle that many.

    On the other hand, if you use mysql_connect(), you'll at most use
    a number of connections equal to the max number of simultaneous
    hits, which is somewhat less than N.

    Gordon Guest

  4. #4

    Default Re: Should I use mysql_connect() or mysql_pconnect() ?


    Axel Schwenke wrote: 
    >
    > In almost all cases pconnect() causes more problems than it solves.
    >
    > http://groups.google.com/group/comp.databases.mysql/msg/e843f0b9e59ad710
    >
    >
    > XL
    > --
    > Axel Schwenke, Senior Software Developer, MySQL AB
    >
    > Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
    > MySQL User Forums: http://forums.mysql.com/[/ref]

    that's great information!

    many people believed that pconnect mean scalability but the fact is
    not, and in fact it is harmful in a busy site!

    thanks.

    howa Guest

Similar Threads

  1. error with mysql_pconnect()
    By Sheldon in forum PHP Development
    Replies: 0
    Last Post: June 12th, 03:23 PM
  2. mysql_pconnect() Do persistent connections ever die?
    By Randell D. in forum PHP Development
    Replies: 3
    Last Post: October 10th, 11:04 PM
  3. [PHP-DEV] PATCH: new_link parameter to mysql_pconnect()
    By Lenar Lõhmus in forum PHP Development
    Replies: 0
    Last Post: September 14th, 04:49 PM
  4. #25368 [Opn->Bgs]: Mysql_pconnect() issues
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: September 2nd, 10:54 PM
  5. #25368 [NEW]: Mysql_pconnect() issues
    By abrahamkou at sbcglobal dot net in forum PHP Development
    Replies: 0
    Last Post: September 2nd, 10:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139