• I'm getting emails when there are failed attempts to connect to mysql. I'm getting several hundred per day. And I see it in other apps I'm running on the server such as PhotoPost. Apparently somthing is wrong with my PHP and MySQL configuration. When it happens there are dozens at about the same time. Then it might go a couple of hours before I start getting them again.

    I've asked my hosting company to look into it, but they don't see anything. Not sure they are knowledgeable about MySQL configs.

    The server is a Windows 2003 dual process with 1 GB of ram. While I have a pretty good amount of traffic, I don't think I'm over taxing this box. The CPU loads stays at about 40-60 during high load times.

    Can anyone help? Where do I start?

    Thanks!


  • Which arcade are you running, both have some issues, I think the IBProArcade has a querry issue with lots of games...


  • I have a few hacks, nothing major. Most are things like the arcade which doesn't change vB code.

    I don't think it is any one php app though. vBulletin is great because it send the emails when there are errors. But browsing the page, I can see that the other apps are also giving errors at about the same rate. So I would think that it is more of a server issue.

    ????


  • This error means that either:

    1) The db info in your config.php file is wrong (in which case your forums won't work at all.)

    2) That user doesn't have permission to access the database listed in config.php.

    3) The database doesn't exist.

    4) MySQL isn't accepting new connections. (The server could either be down or has reached it's maximum connections limit.)

    If you are sure your config.php info is correct, then you will need to contact your host about this.

    Note, many servers are being probed for the phpBB worm these days and the MySQL server is being overloaded. This could account for these errors.


  • There should be a my-{somthing}.cnf in the mysql directory.

    It won't list as my-{somthing}.cnf as a .cnf file in windows is a modem configuration file (or somthing of the like)

    If it is, it isn't .cnf. I've searched for my.cnf, .cnf, and *.cnf and nothing.


  • There should be a my-{somthing}.cnf in the mysql directory.

    It won't list as my-{somthing}.cnf as a .cnf file in windows is a modem configuration file (or somthing of the like)


  • I have the custom my.ini and mmcache running now.

    I'll let you know if the errors decrease!

    Thanks for the help!

    Still need help on the other accelerator, though.


  • This may be my.ini on a Windows server.


  • You have something killing your server. I don't know what you are running, but, it took 30 seconds for your mainpage to load and it never fully loaded. I went to your forum and it crashed Firefox before the page loaded and with IE it never loaded. It just sat there doing nothing until I clicked out. I don't think you have a mysql problem. I think something else is hogging the resources and isn't leaving enough for mysql causing the connection problems.

    Are you running Tomcat also?
    I finally got your site to load after 5 minutes with IE. If you are running Tomcat then you need another gig of memory. Tomcat is a memory hog. The specs say to have at least 512K memory just for it to run and it uses every bit of it


  • I've got the eacellerator downloaded, but where do I put the file and do I need to configure anything else with it?


  • Ok, thanks!

    I'm still seeing a good deal of vBulletin errors. Probably about 350 emails since I turned mmcache on.

    That's less, but still a good many.

    Anything else I can try?

    Thanks!
    is your forum hacked with other code embedded in templates etc ? may be try turning off all mysql using apps on server and run one by one each app until you find your culprit


  • I'm already at:
    PHP 4.3.10
    MySQL 4.0.20a-nt

    Do I still need to upgrade?

    I can't use that accelerator, I'm on IIS not Apache.

    And will the my.cnf work on a windows server?

    Where does it go on windows?

    Thanks


  • Keep Alive 300
    MaxKeepAliveRequests - not in php info
    KeepAliveTimeout - not in php info
    MinSpareServers- not in php info
    MaxSpareServers- not in php info
    StartServers- not in php info
    MaxClients- not in php info


  • As long as mmcache is installed and running then no need to use ea. They are the same thing.


  • Is the syntax

    [mysqld_safe]
    open_files_limit = 8192

    The same as:

    [safe_mysqld]
    open_files_limit = 8192

    ??


  • Is there a way to see if I'm being hit with that worm? How does it show up in a log?

    Thanks


  • At what site?

    And I can't find that post, any help??


  • Anymore help??


  • Dual Processor 2.66
    1 GB of Ram
    2 40 GB hard drives - no raid
    Plesk 7 for windows
    Windows 2003 - IIS

    PHP 4.3.10
    MySQL 4.0.20a-nt
    No innob db's


  • You have something killing your server. I don't know what you are running, but, it took 30 seconds for your mainpage to load and it never fully loaded. I went to your forum and it crashed Firefox before the page loaded and with IE it never loaded. It just sat there doing nothing until I clicked out. I don't think you have a mysql problem. I think something else is hogging the resources and isn't leaving enough for mysql causing the connection problems.

    Are you running Tomcat also?
    I finally got your site to load after 5 minutes with IE. If you are running Tomcat then you need another gig of memory. Tomcat is a memory hog. The specs say to have at least 512K memory just for it to run and it uses every bit of it

    I'm turning off tomcat now. I'll see how it does without it on.

    Try some of the other domains:
    http://www.thegowders.com
    http://www.santeeswapper.com

    I haven't heard anyone complain of those types of issues on PowWows.com before!

    Thanks!


  • If you don't have one create it in the mysql root dir. Use notepad and add this:

    [mysqld]
    # change this to the actual path to mysql root
    basedir=C:/mysql
    # change this to actual path to the data dir
    datadir=C:/mysql/data
    [mysqld]
    skip-innodb
    max_connections = 650
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 10800
    connect_timeout = 10
    tmp_table_size = 32M
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    query_prealloc_size = 16384
    query_alloc_block_size = 16384

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M

    [WinMySQLAdmin]
    # change this to actual path to mysql binary.
    Server=C:/mysql/bin/mysqld-max-nt.exe

    You can download eacellerator binary for Windows at http://www.arnot.info/eaccelerator
    My post with mmcache.zip with instructions is at
    http://www.vbulletin.com/forum/showthread.php?t=126399


  • I'm getting emails when there are failed attempts to connect to mysql. I'm getting several hundred per day. And I see it in other apps I'm running on the server such as PhotoPost. Apparently somthing is wrong with my PHP and MySQL configuration. When it happens there are dozens at about the same time. Then it might go a couple of hours before I start getting them again.

    I've asked my hosting company to look into it, but they don't see anything. Not sure they are knowledgeable about MySQL configs.

    The server is a Windows 2003 dual process with 1 GB of ram. While I have a pretty good amount of traffic, I don't think I'm over taxing this box. The CPU loads stays at about 40-60 during high load times.

    Can anyone help? Where do I start?

    Thanks!
    post the info asked at http://www.vbulletin.com/forum/showthread.php?t=70117


  • We average around 100-150 online.

    Cookie timeout is 1800.


  • I did a search of the entire drive, there is no my.cnf????


  • seems mysql is running default settings which won't cut it

    do in this order

    1. Upgrade MySQL server to latest 4.0.x series - which is 4.0.24 if you haven't already
    2. Upgrade PHP to 4.3.11
    3. Only after upgrading to MySQL 4.0.24 or if you are using MySQL 4.0.xx server, then edit /etc/my.cnf or create at my.cnf at /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards


    [mysqld]
    skip-innodb
    max_connections = 650
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 10800
    connect_timeout = 10
    tmp_table_size = 32M
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    query_prealloc_size = 16384
    query_alloc_block_size = 16384

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M


    4. Install eaccelerator from http://eaccelerator.net/InstallEacceleratorUk read http://www.vbulletin.com/forum/showpost.php?p=805040&postcount=441


  • Several scripts:
    DigiChat
    Hubz
    PhotoPost
    Coppermine
    evoArticles
    Kayko Support Help Desk
    Some custom php scripts


  • back log 50 50
    basedir C:Program FilesSWsoftPleskMySql C:Program FilesSWsoftPleskMySql
    binlog cache size 32768 32768
    bulk insert buffer size 8388608 8388608
    character set latin1 latin1
    character sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
    concurrent insert ON ON
    connect timeout 5 5
    convert character set
    datadir C:Program FilesSWsoftPleskMySqldata C:Program FilesSWsoftPleskMySqldata
    default week format 0 0
    delay key write ON ON
    delayed insert limit 100 100
    delayed insert timeout 300 300
    delayed queue size 1000 1000
    flush OFF OFF
    flush time 1800 1800
    ft boolean syntax + -><()~*:""& + -><()~*:""&
    ft min word len 4 4
    ft max word len 254 254
    ft max word len for sort 20 20
    ft stopword file (built-in) (built-in)
    have bdb NO NO
    have crypt NO NO
    have innodb YES YES
    have isam YES YES
    have raid NO NO
    have symlink YES YES
    have openssl NO NO
    have query cache YES YES
    init file
    innodb additional mem pool size 1048576 1048576
    innodb buffer pool size 8388608 8388608
    innodb data file path ibdata1:10M:autoextend ibdata1:10M:autoextend
    innodb data home dir
    innodb file io threads 4 4
    innodb force recovery 0 0
    innodb thread concurrency 8 8
    innodb flush log at trx commit 1 1
    innodb fast shutdown ON ON
    innodb flush method
    innodb lock wait timeout 50 50
    innodb log arch dir . .
    innodb log archive OFF OFF
    innodb log buffer size 1048576 1048576
    innodb log file size 5242880 5242880
    innodb log files in group 2 2
    innodb log group home dir . .
    innodb mirrored log groups 1 1
    innodb max dirty pages pct 90 90
    interactive timeout 28800 28800
    join buffer size 131072 131072
    key buffer size 8388600 8388600
    language C:Program FilesSWsoftPleskMySqlshareenglish C:Program FilesSWsoftPleskMySqlshareenglish
    large files support ON ON
    license GPL GPL
    local infile ON ON
    log OFF OFF
    log update OFF OFF
    log bin OFF OFF
    log slave updates OFF OFF
    log slow queries OFF OFF
    log warnings ON ON
    long query time 10 10
    low priority updates OFF OFF
    lower case file system OFF OFF
    lower case table names 1 1
    max allowed packet 1048576 1048576
    max binlog cache size 4294967295 4294967295
    max binlog size 1073741824 1073741824
    max connections 1500 1500
    max connect errors 10 10
    max delayed threads 20 20
    max insert delayed threads 20 20
    max heap table size 16777216 16777216
    max join size 4294967295 4294967295
    max relay log size 0 0
    max seeks for key 4294967295 4294967295
    max sort length 1024 1024
    max user connections 0 0
    max tmp tables 32 32
    max write lock count 4294967295 4294967295
    myisam max extra sort file size 268435456 268435456
    myisam max sort file size 2147483647 2147483647
    myisam repair threads 1 1
    myisam recover options OFF OFF
    myisam sort buffer size 8388608 8388608
    named pipe OFF OFF
    net buffer length 16384 16384
    net read timeout 30 30
    net retry count 10 10
    net write timeout 60 60
    new OFF OFF
    open files limit 0 0
    pid file C:Program FilesSWsoftPleskMySqldatacp.pid C:Program FilesSWsoftPleskMySqldatacp.pid
    log error .cp.err .cp.err
    port 3306 3306
    protocol version 10 10
    query alloc block size 8192 8192
    query cache limit 1048576 1048576
    query cache size 0 0
    query cache type ON ON
    query prealloc size 8192 8192
    range alloc block size 2048 2048
    read buffer size 131072 131072
    read only OFF OFF
    read rnd buffer size 262144 262144
    rpl recovery rank 0 0
    server id 0 0
    slave net timeout 3600 3600
    skip external locking ON ON
    skip networking OFF OFF
    skip show database OFF OFF
    slow launch time 2 2
    sort buffer size 2097144 2097144
    sql mode 0 0
    table cache 64 64
    table type MYISAM MYISAM
    thread cache size 0 0
    thread stack 196608 196608
    tx isolation REPEATABLE-READ REPEATABLE-READ
    timezone Central Daylight Time Central Daylight Time
    tmp table size 33554432 33554432
    tmpdir C:WINDOWSTEMP C:WINDOWSTEMP
    transaction alloc block size 8192 8192
    transaction prealloc size 4096 4096
    version 4.0.20a-nt 4.0.20a-nt
    version comment Source distribution Source distribution
    version compile os NT NT
    wait timeout 28800 28800


  • Yes you can use eacellerator with IIS. Search this forum for a post by me that has mmcache.zip attached. Use the instructions in it to install eacellerator. You can download the binary for Windows a ea site.
    The my.cnf file is in c:mysql.
    What you have to do is open a command prompt and do the following:
    cd C:mysql
    ren my-huge.cnf my.ini
    Now you open it with notepad to add the above variables. Restart mysql to use new my.in.


  • vBProArcade.


  • Ok, thanks!

    I'm still seeing a good deal of vBulletin errors. Probably about 350 emails since I turned mmcache on.

    That's less, but still a good many.

    Anything else I can try?

    Thanks!


  • Ok, I had to turn mmcache off. It worked great for my main site, but other other domains on the server wouldn't show php pages.

    Any ideas there??


  • This error means that either:

    1) The db info in your config.php file is wrong (in which case your forums won't work at all.)

    2) That user doesn't have permission to access the database listed in config.php.

    3) The database doesn't exist.

    4) MySQL isn't accepting new connections. (The server could either be down or has reached it's maximum connections limit.)

    If you are sure your config.php info is correct, then you will need to contact your host about this.

    Note, many servers are being probed for the phpBB worm these days and the MySQL server is being overloaded. This could account for these errors.

    Hmm must be #4.

    I have 1500 max connections, that would seem like enough??


  • Nope not tomcat. I had it running but apparently in all the tickets with EV1, they turned it off a couple of weeks ago!

    So that's not it!







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Connect Failed Errors , Please add it free.