Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Location
    UK
    Posts
    45

    "Can't connect to local MySQL server" + "IPS Driver Error"

    During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery:

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
    (The forums and the gallery are the main parts of the site).

    I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference.

    What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings?

    Btw, my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.

    Thanks in advance for any help.

  2. #2
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    9,072
    Can you paste your /etc/my.cnf and tell us your load average and memory usage?
    RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca

    www.HostingSecList.com - Security Notices for the Hosting Community.

  3. #3
    Join Date
    Mar 2005
    Location
    UK
    Posts
    45
    Sure, my.cnf:

    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-external-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_user_connections=85
    max_connections=850
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=128
    key_buffer=16M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=1024
    read_buffer_size=1M
    max_connect_errors=10
    thread_concurrency=8
    myisam_sort_buffer_size=64M
    server-id=1
    
    [mysql.server]
    user=mysql
    basedir=/var/lib
    
    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid
    open_files_limit=8192
    
    [mysqldump]
    quick
    max_allowed_packet=16M
    
    [mysql]
    no-auto-rehash
    
    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M
    
    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M
    
    [mysqlhotcopy]
    interactive-timeout
    Load averages reach up to about 20.00+ at peak times, otherwise around 3.00 - 5.00. (The site's performance is good enough during the high load which is why I haven't worried about it yet).

    Memory usage:
    Code:
                    total       used       free     shared    buffers     cached
    Mem:       4151472    4030808     120664          0      42492    2025744
    -/+ buffers/cache:    1962572    2188900
    Swap:      2096440       3036    2093404

  4. #4
    Join Date
    Dec 2006
    Posts
    599
    I have the exact same problem.
    Should I post my my.cnf?

Posting Permissions

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