OpenVZ Forum


Home » International » French » strange behavior with mysql on CT
strange behavior with mysql on CT [message #42812] Tue, 31 May 2011 07:28 Go to next message
anarcia is currently offline  anarcia
Messages: 3
Registered: May 2011
Location: bordeaux
Junior Member
From: *fbx.proxad.net
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"





Re: strange behavior with mysql on CT [message #42938 is a reply to message #42812] Tue, 21 June 2011 21:14 Go to previous message
nyquist is currently offline  nyquist
Messages: 27
Registered: June 2010
Location: 44 - France
Junior Member
From: *fbx.proxad.net
"Chez Moi ça Marche".

Bon je sais que ca n'apporte pas grand chose alors je te colle ma conf et le contenu de /proc/user_beancounters.

PS c'est un ancien serveur physique converti en conteneur. le seul problème que j'ai est au redémarrage du noeud il perds soit son ip, soit la route par défaut...

cat /etc/vz/conf/CTID.conf
NUMPROC="358:358"
AVNUMPROC="179:179"
NUMTCPSOCK="358:358"
NUMOTHERSOCK="358:358"
VMGUARPAGES="63014:9223372036854775807"
ONBOOT="yes"
# Secondary parameters
KMEMSIZE="14704836:16175319"
TCPSNDBUF="3435244:4901612"
TCPRCVBUF="3435244:4901612"
OTHERSOCKBUF="1717622:3183990"
DGRAMRCVBUF="1717622:1717622"
OOMGUARPAGES="63014:9223372036854775807"
PRIVVMPAGES="269253:296178"
# Auxiliary parameters
LOCKEDPAGES="718:718"
SHMPAGES="26925:26925"
PHYSPAGES="0:9223372036854775807"
NUMFILE="5728:5728"
NUMFLOCK="572:629"
NUMPTY="35:35"
NUMSIGINFO="1024:1024"
DCACHESIZE="3203231:3299328"
NUMIPTENT="80:80"
DISKSPACE="5081208:6001208"
DISKINODES="192868:205428"
CPUUNITS="12303"
QUOTATIME="0"
OSTEMPLATE=debian
IP_ADDRESS="192.168.0.51"
NAMESERVER="212.27.40.240 212.27.40.241"
HOSTNAME="CTID"
DESCRIPTION="ancien serveur physique sql/apache"
NAME="CTID"


la suite est pas tres lisible mais un copié collé dans un fichier a un meilleur rendu.
cat /proc/user_beancounters
uid  resource                     held              maxheld              barrier                limit              failcnt
CTID:  kmemsize                  6229652              7379537             14704836             16175319                    0
            lockedpages                     0                    0                  718                  718                    0
            privvmpages                110214               117833               269253               296178                    0
            shmpages                     8228                 8228                26925                26925                    0
            dummy                           0                    0                    0                    0                    0
            numproc                        53                   64                  358                  358                    0
            physpages                   34386                43824                    0  9223372036854775807                    0
            vmguarpages                     0                    0                63014  9223372036854775807                    0
            oomguarpages                34403                43827                63014  9223372036854775807                    0
            numtcpsock                     17                   30                  358                  358                    0
            numflock                        8                   15                  572                  629                    0
            numpty                          0                    2                   35                   35                    0
            numsiginfo                      0                    4                 1024                 1024                    0
            tcpsndbuf                  283400              2418280              3435244              4901612                    0
            tcprcvbuf                  262144               437600              3435244              4901612                    0
            othersockbuf                16944                79408              1717622              3183990                    0
            dgramrcvbuf                     0                 4360              1717622              1717622                    0
            numothersock                   35                   43                  358                  358                    0
            dcachesize                 338633               428778              3203231              3299328                    0
            numfile                      1188                 1392                 5728                 5728                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                       0                    0                   80                   80                    0
Previous Topic: vps en français
Next Topic: mount --bind /host/directory /container/directory
Goto Forum:
  


Current Time: Mon Oct 15 23:22:20 GMT 2018