for no reason, mysql began to stop working continuously...

Discussion in 'Installation/Configuration' started by blacklevel, Jun 29, 2017.

  1. blacklevel

    blacklevel New Member

    Hello,
    for no reason, mysql began to stop working continuously... Sites cant connect to mysql. After restarting service mysql, sites working about 10 minutes, and then sopping again..
    Can someone help me please? :)

    Before restarting mysql service I have this:

    Code:
    tcp  0  0 localhost:49947  localhost:mysql  ESTABLISHED 16640/error   
    tcp  0  0 localhost:50096  localhost:mysql  ESTABLISHED 16763/smtp   
    tcp  0  0 localhost:49913  localhost:mysql  ESTABLISHED 16506/error   
    tcp  0  0 localhost:50156  localhost:mysql  ESTABLISHED 16865/smtp   
    tcp  0  0 localhost:50005  localhost:mysql  ESTABLISHED 16733/error   
    tcp  0  0 localhost:49901  localhost:mysql  ESTABLISHED 16465/error   
    tcp  0  0 localhost:49906  localhost:mysql  ESTABLISHED 16490/error   
    tcp  0  0 localhost:50166  localhost:mysql  ESTABLISHED 16879/smtp   
    tcp  0  0 localhost:49923  localhost:mysql  ESTABLISHED 16564/error   
    tcp  0  0 localhost:49915  localhost:mysql  ESTABLISHED 16528/error   
    tcp  0  0 localhost:49892  localhost:mysql  ESTABLISHED 16421/error   
    tcp  0  0 localhost:49883  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49945  localhost:mysql  ESTABLISHED 16641/error   
    tcp  0  0 localhost:49973  localhost:mysql  ESTABLISHED 16713/error   
    tcp  0  0 localhost:49927  localhost:mysql  ESTABLISHED 16467/error   
    tcp  0  0 localhost:49958  localhost:mysql  ESTABLISHED 16665/smtp   
    tcp  0  0 localhost:49926  localhost:mysql  ESTABLISHED 16583/error   
    tcp  0  0 localhost:49886  localhost:mysql  ESTABLISHED 16413/error   
    tcp  0  0 localhost:49942  localhost:mysql  ESTABLISHED 16636/error   
    tcp  0  0 localhost:49925  localhost:mysql  ESTABLISHED 16558/error   
    tcp  0  0 localhost:50206  localhost:mysql  ESTABLISHED 16892/smtp   
    tcp  0  0 localhost:50058  localhost:mysql  ESTABLISHED 16806/smtp   
    tcp  0  0 localhost:47949  localhost:mysql  ESTABLISHED 10325/amavisd-new (
    tcp  0  0 localhost:49975  localhost:mysql  ESTABLISHED 16430/error   
    tcp  0  0 localhost:50067  localhost:mysql  ESTABLISHED 16820/smtp   
    tcp  0  0 localhost:49882  localhost:mysql  ESTABLISHED 16397/error   
    tcp  0  0 localhost:50155  localhost:mysql  ESTABLISHED 16854/smtp   
    tcp  0  0 localhost:51942  localhost:mysql  ESTABLISHED 16875/smtp   
    tcp  0  0 localhost:49902  localhost:mysql  ESTABLISHED 16469/error   
    tcp  0  0 localhost:49935  localhost:mysql  ESTABLISHED 16612/error   
    tcp  0  0 localhost:51748  localhost:mysql  ESTABLISHED 16930/smtp   
    tcp  0  0 localhost:49905  localhost:mysql  ESTABLISHED 16497/error   
    tcp  0  0 localhost:50178  localhost:mysql  ESTABLISHED 16858/smtp   
    tcp  0  0 localhost:49933  localhost:mysql  ESTABLISHED 16609/error   
    tcp  0  0 localhost:49951  localhost:mysql  ESTABLISHED 16521/error   
    tcp  0  0 localhost:49967  localhost:mysql  ESTABLISHED 16548/error   
    tcp  0  0 localhost:49969  localhost:mysql  ESTABLISHED 16690/smtp   
    tcp  0  0 localhost:49865  localhost:mysql  ESTABLISHED 10574/proxymap  
    tcp  0  0 localhost:49911  localhost:mysql  ESTABLISHED 16513/error   
    tcp  0  0 localhost:49894  localhost:mysql  ESTABLISHED 16418/error   
    tcp  0  0 localhost:49972  localhost:mysql  ESTABLISHED 16716/error   
    tcp  0  0 localhost:49893  localhost:mysql  ESTABLISHED 16425/error   
    tcp  0  0 localhost:49993  localhost:mysql  ESTABLISHED 16764/smtp   
    tcp  0  0 localhost:51751  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49878  localhost:mysql  ESTABLISHED 16384/error   
    tcp  0  0 localhost:49932  localhost:mysql  ESTABLISHED 16492/error   
    tcp  0  0 localhost:49968  localhost:mysql  ESTABLISHED 16709/error   
    tcp  0  0 localhost:50281  localhost:mysql  ESTABLISHED 16927/smtp   
    tcp  0  0 localhost:49929  localhost:mysql  ESTABLISHED 16581/error   
    tcp  0  0 localhost:50039  localhost:mysql  ESTABLISHED 16685/error   
    tcp  0  0 localhost:49976  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:50042  localhost:mysql  ESTABLISHED 16711/smtp   
    tcp  0  0 localhost:51937  localhost:mysql  ESTABLISHED 16955/smtp   
    tcp  0  0 localhost:49978  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49885  localhost:mysql  ESTABLISHED 16406/error   
    tcp  0  0 localhost:51941  localhost:mysql  ESTABLISHED 16936/smtp   
    tcp  0  0 localhost:47267  localhost:mysql  ESTABLISHED 4796/amavisd-new (c
    tcp  0  0 localhost:49869  localhost:mysql  ESTABLISHED 15985/smtpd   
    tcp  0  0 localhost:49964  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:51930  localhost:mysql  ESTABLISHED 16926/smtp   
    tcp  0  0 localhost:49928  localhost:mysql  ESTABLISHED 16579/error   
    tcp  0  0 localhost:49921  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49908  localhost:mysql  ESTABLISHED 16516/error   
    tcp  0  0 localhost:50152  localhost:mysql  ESTABLISHED 16860/smtp   
    tcp  0  0 localhost:50184  localhost:mysql  ESTABLISHED 16867/smtp   
    tcp  0  0 localhost:49940  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49042  localhost:mysql  ESTABLISHED 15700/smtp   
    tcp  0  0 localhost:49877  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:50125  localhost:mysql  ESTABLISHED 16819/smtp   
    tcp  0  0 localhost:50284  localhost:mysql  ESTABLISHED 16921/smtp   
    tcp  0  0 localhost:50043  localhost:mysql  ESTABLISHED 16802/smtp   
    tcp  0  0 localhost:50011  localhost:mysql  ESTABLISHED 16765/smtp   
    tcp  0  0 localhost:50121  localhost:mysql  ESTABLISHED 16842/smtp   
    tcp  0  0 localhost:49919  localhost:mysql  ESTABLISHED 16527/error   
    tcp  0  0 localhost:49884  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49890  localhost:mysql  ESTABLISHED 16416/error   
    tcp  0  0 localhost:49868  localhost:mysql  ESTABLISHED 15985/smtpd   
    tcp  0  0 localhost:51933  localhost:mysql  ESTABLISHED 16945/smtp   
    tcp  0  0 localhost:50145  localhost:mysql  ESTABLISHED 16870/smtp   
    tcp  0  0 localhost:50075  localhost:mysql  ESTABLISHED 16815/smtp   
    tcp  0  0 localhost:49934  localhost:mysql  ESTABLISHED 16607/error   
    tcp  0  0 localhost:50020  localhost:mysql  ESTABLISHED 16686/error   
    tcp  0  0 localhost:50072  localhost:mysql  ESTABLISHED 16761/smtp   
    tcp  0  0 localhost:49887  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49956  localhost:mysql  ESTABLISHED 16563/error   
    tcp  0  0 localhost:50670  localhost:mysql  ESTABLISHED 16915/smtp   
    tcp  0  0 localhost:51961  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49866  localhost:mysql  ESTABLISHED 10573/trivial-rewri
    tcp  0  0 localhost:51960  localhost:mysql  ESTABLISHED -   
    tcp  0  0 localhost:49949  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49907  localhost:mysql  ESTABLISHED 16499/error   
    tcp  0  0 localhost:49899  localhost:mysql  ESTABLISHED 16464/error   
    tcp  0  0 localhost:51934  localhost:mysql  ESTABLISHED 16931/smtp   
    tcp  0  0 localhost:49897  localhost:mysql  TIME_WAIT  -   
    tcp  0  0 localhost:49965  localhost:mysql  ESTABLISHED 16704/error
      
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Take a look at the mail.log file. There seem to be a lot of postfix connections to mysql, maybe your server is receiving or sending a lot of email.
     
  3. blacklevel

    blacklevel New Member

    2 days ago, (with your help) I removed many malicious websites, maybe this is related? How I can check and remove these emails from sending list?:) I cant find directory of mail.log file... /var/log/mail.log not oppening
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

  5. blacklevel

    blacklevel New Member

    Thank you!
    I get some errors whent try to remove messages by sender:
    -----
    root@013fr-web:~# mailq | grep sender.hostname.tld | awk ‘{ print $1′} | postsuper -d -
    awk: 1: unexpected character 0xe2
     
  6. Aivaras

    Aivaras Member

    There are some simple/safe possibility to reinstall postfix?
     

Share This Page