Backup restore issue MySQL server has gone away — CyberPanel - WebHosting Control Panel for OpenLiteSpeed
CyberLoader

Backup restore issue MySQL server has gone away

I am getting the following error while trying to fetch backup from old server to new server, how to solve the issue?

I DIDN'T CHANGE ANY MY CNF CONFIG.

[05.19.2021_18-32-38] (2006, 'MySQL server has gone away') [207][5009]
[05.19.2021_18-32-47] (2006, 'MySQL server has gone away') [207][5009]
[05.19.2021_18-33-05] (2006, 'MySQL server has gone away') [207][5009]
[05.19.2021_18-33-07] (2006, 'MySQL server has gone away') [207][5009]
[05.19.2021_18-33-09] (2006, 'MySQL server has gone away') [207][5009]
[05.19.2021_19-14-41] (2006, 'MySQL server has gone away') [207][5009]
[05.19.2021_19-15-16] Aborted, Failed to run cp -R /home/mydomain.com/public_html /home/mydomain.com/backup/backup-mydomain.com-05.19.2021_19-14-57/public_html..[365] [5009]

Comments

  • Kindly share your server specs, looks like your server can't handle MySQL load.
  • 12 core CPU, 48GB ram. now I reinstalled the server. the problem seems to be gone.

    but now I am experiencing other types of problems.

    most of the time CPU load is fine but suddenly sometimes CPU usage and ram usage seem to be full.

    how can my 4 sites use 48GB ram?

    my php memory limit is 512mb
    virtual host Max Connections * 15
    LSAPI_CHILDREN=15
    Memory Soft Limit (bytes) 3047
    Memory Hard Limit (bytes) 4047M

    Process Soft Limit 600
    Process Hard Limit 800

    LiteSpeed tuning setting https://prnt.sc/13vf45s

    Php tuning setting https://prnt.sc/13vfblu

    error log https://textbin.net/l2eyw2twm3

    brother, can you please tell me where is wrong, my site has heavy traffic around 300/400 / sec

    daily 90k/100k+ traffic. help me please brother @usmannasir
  • > @usmannasir said:
    > Kindly share your server specs, looks like your server can't handle MySQL load.

    help me please brother
  • Use some monitor and check your server overall CPU usage.

    You can use Hetrix at server level and New relic and application level -> https://cyberpanel.net/blog/2021/04/28/how-to-find-wordpress-performance-bottlenecks/

    The article above can be used to find bottlenecks in other php applications as well.
Sign In or Register to comment.
CyberPanel Discord

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion