OpenVZ Forum: Support » MySQL constantly crashing

Home » General » Support » MySQL constantly crashing

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

MySQL constantly crashing [message #33977]

Sat, 22 November 2008 20:41

gsv_
Messages: 1
Registered: November 2008
Location: NYC

Junior Member

I'm facing a problem on one of my VE's where MySQL is constantly crashing. At first, I noticed that some beancounters were being hit, but I've increased sufficiently enough that the fail counts are no longer increasing (and naturally they aren't being hit). However, the problem still remains. MySQL just stops responding to requests. I have the MySQL error log enabled, however it displays no useful information.

I am running MySQL 5.0.51a-community which happens to run just fine on other VEs that are actually on the same node. I also tried running a later version, but it made no difference, so I reverted back.

Here's the current beancounter situation:

Version: 2.5
       uid  resource                     held              maxheld              barrier                limit              failcnt
    10010:  kmemsize                  9243052             17046329             22111846             22754099                    0
            lockedpages                     0                    0                  512                  512                    0
            privvmpages                 65775               322809               393216               393216                37470
            shmpages                    19668                65358               131072               131072                   45
            dummy                           0                    0                    0                    0                    0
            numproc                        52                  126                  720                  720                    0
            physpages                   49400               258037                    0           2147483647                    0
            vmguarpages                     0                    0               196608           2147483647                    0
            oomguarpages                49400               258037               196608           2147483647                    0
            numtcpsock                     33                  240                 1200                 1200                    0
            numflock                        2                   25                  384                  384                    0
            numpty                          1                    3                   32                   32                    0
            numsiginfo                      1                   33                  512                  512                    0
            tcpsndbuf                 1658328              6614200             21621760             21621760                    0
            tcprcvbuf                  540672              9645936             21621760             21621760                  273
            othersockbuf               615408             12278656             21621760             21621760                 1849
            dgramrcvbuf                     0                52128               524288               524288                    0
            numothersock                   70                  304                  720                  720                    0
            dcachesize                 510157              1738982              7249920              7249920                    0
            numfile                      2328                 4183                18624                18624                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                     233                  233                 2000                 2000                    0

Any help would be appreciated.

King regards,

-gsv

Report message to a moderator

Re: MySQL constantly crashing [message #33979 is a reply to message #33977]

Sun, 23 November 2008 04:57

kir
Messages: 1645
Registered: August 2005
Location: Moscow, Russia

Senior Member

I guess this is something mysql-specific. Try to check its databases (mysqlcheck) -- sometimes it can lock up if DB went south. Try stracing it (strace). Ask on mysql forum.

Kir Kolyshkin

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Previous Topic:	my o/s crashed then my steps , show me the exit
Next Topic:	[solved] NFS export /vz results in "Cannot allocate memory" on HN / CT0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri May 16 05:11:49 GMT 2025

Total time taken to generate the page: 0.03440 seconds