OpenVZ Forum: French » strange behavior with mysql on CT

Home » International » French » strange behavior with mysql on CT

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

strange behavior with mysql on CT [message #42812]

Tue, 31 May 2011 07:28

anarcia
Messages: 3
Registered: May 2011
Location: bordeaux

Junior Member

Bonjour
J'ai une VM Openvz qui contient une base mysql. J'ai à chaque démarrage de mysql le message suivant :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

J'ai aussi régulièrement ce message d'erreur : #2006 - MySQL server has gone away.

Autant dire que ma VM ne fait pas du tout son travail.

J'ai tenté de modifier les limits de ma vm mais rien n'y fait. Je suis méchamment bloqué sur le coup.

Je vous poste la config trèèèès modifiée de ma vm.

ONBOOT="yes"
NAMESERVER="8.8.8.8"
CPUUNITS="1000"
CPUS="2"
CPULIMIT="50"
PRIVVMPAGES="1048576:1048576"
DISKSPACE="52428800:52428800"
QUOTATIME="0"
KMEMSIZE="18438144:18438144"
LOCKEDPAGES="2048:2048"
SHMPAGES="43008:43008"
NUMPROC="480:480"
PHYSPAGES="0:9223372036854775807"
VMGUARPAGES="33792:9223372036854775807"
OOMGUARPAGES="26112:9223372036854775807"
NUMTCPSOCK="14400:14400"
NUMFLOCK="188:206"
NUMPTY="16:16"
NUMSIGINFO="256:256"
TCPSNDBUF="4611686018427387903:9223372036854775807"
TCPRCVBUF="4611686018427387903:9223372036854775807"
OTHERSOCKBUF="4611686018427387903:9223372036854775807"
DGRAMRCVBUF="262144:262144"
NUMOTHERSOCK="14400:14400"
DCACHESIZE="11065344:11065344"
NUMFILE="28816:28816"
AVNUMPROC="180:180"
NUMIPTENT="128:128"
DISKINODES="300000:320000"
SWAPPAGES="9223372036854775807:9223372036854775807"
VE_ROOT="/var/lib/vz/root/$VEID"
VE_PRIVATE="/var/lib/vz/private/$VEID"
OSTEMPLATE="debian-6.0-amd64-minimal"
ORIGIN_SAMPLE="basic"
HOSTNAME="sql50"
IP_ADDRESS="192.168.0.50"
IPTABLES="ip_tables ipt_REJECT ipt_tos ipt_limit ipt_multiport iptable_filter iptable_mangle ipt_TCPMSS ipt_tcpmss ipt_ttl ipt_length ip_conntrack ip_conntrack_ftp ip_conntrack_irc ipt_LOG ipt_conntrack ipt_helper ipt_state iptable_nat ip_nat_ftp ip_nat_irc ipt_TOS"

Report message to a moderator