Navigation

    • Register
    • Login
    • Search
    • Recent
    • Users
    • Groups

    Mysql load error

    CWP - Panel
    2
    6
    41
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      choqo last edited by

      Hello
      http://prntscr.com/112m1as

      load average: 7.46, 5.22, 4.62

      mysql is loading. I wonder if anyone has a solution to this?

      CWP : nginx + varnish + apache + php7.2 fpm

      Vps: 6 cpu + 24ram

      what would you suggest me to do? thanks.

      1 Reply Last reply Reply Quote 0
      • sandeep
        sandeep last edited by sandeep

        its hard to determine by only watching the screenshot.

        probably you've high traffic or ddos.

        1 Reply Last reply Reply Quote 0
        • sandeep
          sandeep last edited by

          you can try to optimize mysql by below values in /etc/my.cnf

          [mysqld]
          max_connections = 6000
          max_user_connections=300
          innodb_lock_wait_timeout=120
          max_heap_table_size = 1G
          tmp_table_size = 1024M
          thread_cache_size = 128
          innodb_buffer_pool_size = 1G
          innodb_log_file_size = 1G
          innodb_buffer_pool_instances = 4
          table_open_cache = 3000
          wait_timeout=110
          interactive_timeout=110
          long_query_time=25
          max_allowed_packet=128M
          
          C 1 Reply Last reply Reply Quote 0
          • C
            choqo @sandeep last edited by choqo

            @sandeep said in Mysql load error:

            max_connections = 6000
            max_user_connections=300
            innodb_lock_wait_timeout=120
            max_heap_table_size = 1G
            tmp_table_size = 1024M
            thread_cache_size = 128
            innodb_buffer_pool_size = 1G
            innodb_log_file_size = 1G
            innodb_buffer_pool_instances = 4
            table_open_cache = 3000
            wait_timeout=110
            interactive_timeout=110
            long_query_time=25
            max_allowed_packet=128M

            Firstly, thank you.
            cd /etc/my.cnf.d
            nano server.cnf

            [mysqld]
            I added below it. Did I do it right?

            ===========================================
            http://prntscr.com/112urus

            Also, when I look from here. I see such errors. I guess the attack comes from Memcached. but I did not install memcached.
            I see it working with the command "service memcached status".

            How can I completely remove memcached from the server?

            Apr 3 04:52:03 vm6065100 kernel: Firewall: UDP_IN Blocked IN=eth0 OUT= MAC=xx:xx:xx:xx:xx:dd:7c:1c:f1:f6:cf:61:08:00 SRC=68.119.123.131 DST=MY-İP LEN=43 TOS=0x00 PREC=0x00 TTL=52 ID=24444 PROTO=UDP SPT=3074 DPT=11211 LEN=23

            sandeep 1 Reply Last reply Reply Quote 0
            • sandeep
              sandeep @choqo last edited by sandeep

              @choqo i mentioned to add this to /etc/my.cnf

              you can also add it there /etc/my.cnf.d/server.cnf but recommended is to add in the /etc/my.cnf

              if you get error then its possible you've some sort custom added previously and wrongly added. you'll never get errors with this mysqld configs

              you can secure memcached from UDP attacks :
              https://www.mysterydata.com/how-to-secure-memcached-server-from-udp-attacks/

              C 1 Reply Last reply Reply Quote 0
              • C
                choqo @sandeep last edited by

                @sandeep
                thank you so much

                1 Reply Last reply Reply Quote 1
                • 1 / 1
                • First post
                  Last post

                Recent Topics

                • nginx/1.20.0 ngx_pagespeed module

                • Almalinux support

                • Error Dovecot IMAP/POP3 Server

                • Problem with How to Enable TLS 1.3 in Apache on CWP

                • Successful delivery message

                • Install latest version of Sqlite3 from source Ubuntu/Debian

                • Install latest version of Sqlite3 from source centos/rhel/el7/el8

                • C

                  Mysql load error

                1
                Online

                86
                Users

                117
                Topics

                768
                Posts

                URLs HOME | Blog | Support Portal