Results 1 to 4 of 4
-
06-04-2007, 02:35 PM #1Junior Guru Wannabe
- 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)
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.
-
06-04-2007, 02:39 PM #2Web Hosting Master
- 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.
-
06-04-2007, 02:49 PM #3Junior Guru Wannabe
- 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
Memory usage:
Code:total used free shared buffers cached Mem: 4151472 4030808 120664 0 42492 2025744 -/+ buffers/cache: 1962572 2188900 Swap: 2096440 3036 2093404
-
06-05-2007, 02:22 AM #4Web Hosting Master
- Join Date
- Dec 2006
- Posts
- 599
I have the exact same problem.
Should I post my my.cnf?