MySQL Server가 사라졌습니다(MariaDB - MEMORY Engine)

MySQL Server가 사라졌습니다(MariaDB - MEMORY Engine)

저는 암호화된 파일이 있는 플러그인이 많이 있는 OpenCart 웹사이트를 가지고 있습니다.점점 더 많은 제품(현재 150k)을 추가하면서 점점 느려졌습니다.쿼리를 변경할 수 없으므로(파일은 암호화됨)테이블의 일부 스토리지 엔진을 메모리로 변경해야 했습니다.조회 시간이 50초에서 2초로 늘었습니다.

하지만 새로운 문제가 있습니다.4~5페이지를 동시에 열려고 하면 DB서버가 다운됩니다.이것은 관리형 VPS이므로 모든 것에 접근할 수 없습니다.호스팅의 지원은 전혀 도움이 되지 않으며 메모리가 호환되지 않으므로 사용하지 말라고 합니다!

나는 내 로컬 호스트에 정확하게 동일한 설정을 가지고 있습니다(Webhost는 MariaDB이지만 내 로컬 호스트에서 MySQL을 사용한다는 차이점만 있습니다). 내가 아무리 노력해도 오류를 재현할 수 없습니다.

OpenCart 내의 오류 로그는 다음과 같습니다.

2018-04-26 22:32:42 - PHP Warning:  mysqli::query(): MySQL server has gone away in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  mysqli::query(): Error reading result set's header in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  Error while sending QUERY packet. PID=26733 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  mysqli::query(): (00000/0):  in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  mysqli::query(): MySQL server has gone away in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  mysqli::query(): Error reading result set's header in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  mysqli::query(): MySQL server has gone away in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  mysqli::query(): Error reading result set's header in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Notice:  Trying to get property of non-object in /home/grdrop/public_html/catalog/model/extension/module/yumenu.php on line 163
2018-04-26 22:32:42 - PHP Warning:  Error while sending QUERY packet. PID=26732 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  Error while sending QUERY packet. PID=26718 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  Error while sending QUERY packet. PID=26722 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  Error while sending QUERY packet. PID=26730 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  Error while sending QUERY packet. PID=26725 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:42 - PHP Warning:  Error while sending QUERY packet. PID=26726 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:43 - PHP Warning:  Error while sending QUERY packet. PID=26734 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:43 - PHP Warning:  Error while sending QUERY packet. PID=26724 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:43 - PHP Warning:  Error while sending QUERY packet. PID=26727 in /home/grdrop/public_html/system/library/db/mysqli.php on line 18
2018-04-26 22:32:44 - PHP Warning:  mysqli::__construct(): (HY000/2002): Connection refused in /home/grdrop/public_html/system/library/db/mysqli.php on line 7
2018-04-26 22:32:44 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:44 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:44 - PHP Warning:  mysqli::__construct(): (HY000/2002): Connection refused in /home/grdrop/public_html/system/library/db/mysqli.php on line 7
2018-04-26 22:32:44 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:44 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:45 - PHP Warning:  mysqli::__construct(): (HY000/2002): Connection refused in /home/grdrop/public_html/system/library/db/mysqli.php on line 7
2018-04-26 22:32:45 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:45 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:45 - PHP Warning:  mysqli::__construct(): (HY000/2002): Connection refused in /home/grdrop/public_html/system/library/db/mysqli.php on line 7
2018-04-26 22:32:45 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:45 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/grdrop/public_html/system/library/db/mysqli.php on line 10
2018-04-26 22:32:45 - PHP Warning:  mysqli::__construct(): (HY000/2002): Connection refused in /home/grdrop/public_html/system/library/db/mysqli.php on line 7

저는 DB에 대해 잘 모르고 여기서 완전히 길을 잃었습니다.이것이 메모리와 관련된 문제라면 충분한 RAM이 있을 때 DB가 첫 번째 쿼리를 완료하고 계속할 때까지 기다리도록 변경할 수 있는 변수나 설정이 없습니까?

언급URL : https://stackoverflow.com/questions/50096280/mysql-server-has-gone-away-mariadb-memory-engine