0 Members and 2 Guests are viewing this topic.
you should check mysql logs, location:/var/lib/mysql/
Also, how many CPU's and RAM available on your VPS?
you need to find log file in that folder, usually its called the same as your hostname with .err extension
190110 21:33:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql2019-01-10 21:33:52 140203948259584 [Note] /usr/sbin/mysqld (mysqld 10.1.29-MariaDB) starting as process 31634 ...2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Using mutexes to ref count buffer pool pages2019-01-10 21:33:53 140203948259584 [Note] InnoDB: The InnoDB memory heap is disabled2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2019-01-10 21:33:53 140203948259584 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Compressed tables use zlib 1.2.72019-01-10 21:33:53 140203948259584 [Note] InnoDB: Using Linux native AIO2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Using SSE crc32 instructions2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Initializing buffer pool, size = 5.0G2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Completed initialization of buffer pool2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Highest supported file format is Barracuda.2019-01-10 21:33:53 140203948259584 [Note] InnoDB: 128 rollback segment(s) are active.2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Waiting for purge to start2019-01-10 21:33:53 140203948259584 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 428122328882019-01-10 21:33:53 140203948259584 [Note] Plugin 'FEEDBACK' is disabled.2019-01-10 21:33:53 140197475874560 [Note] InnoDB: Dumping buffer pool(s) not yet started2019-01-10 21:33:53 140203948259584 [Note] Server socket created on IP: '::'.2019-01-10 21:33:53 140203948259584 [Note] /usr/sbin/mysqld: ready for connections.Version: '10.1.29-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server2019-01-10 21:33:57 140203869195008 [Note] /usr/sbin/mysqld: Normal shutdown2019-01-10 21:33:57 140197501052672 [Note] InnoDB: FTS optimize thread exiting.2019-01-10 21:33:57 140203869195008 [Note] InnoDB: Starting shutdown...2019-01-10 21:33:58 140203869195008 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool2019-01-10 21:34:00 140203869195008 [Note] InnoDB: Shutdown completed; log sequence number 428129260132019-01-10 21:34:00 140203869195008 [Note] /usr/sbin/mysqld: Shutdown complete190110 21:34:00 mysqld_safe mysqld from pid file /var/lib/mysql/server.*******.es.pid ended