Ad Widget

Collapse

Please help this noob with mysql error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zabbixisfun
    Junior Member
    • Apr 2019
    • 9

    #16
    I had this error:
    MySQL database "zabbix" on "localhost" is not available: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

    but it seemed to disappear


    MySQL Error log:

    GNU nano 2.9.3 error.log
    2019-06-06 6:22:29 140279059229824 [Note] InnoDB: Using SSE crc32 instructions
    2019-06-06 6:22:29 140279059229824 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2019-06-06 6:22:29 140279059229824 [Note] InnoDB: Completed initialization of buffer pool
    2019-06-06 6:22:29 140279059229824 [Note] InnoDB: Highest supported file format is Barracuda.
    2019-06-06 6:22:29 140279059229824 [Note] InnoDB: 128 rollback segment(s) are active.
    2019-06-06 6:22:29 140279059229824 [Note] InnoDB: Waiting for purge to start
    2019-06-06 6:22:29 140279059229824 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 15483980222
    2019-06-06 6:22:29 140279059229824 [Note] Plugin 'FEEDBACK' is disabled.
    2019-06-06 6:22:29 140278388225792 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at l$
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: The InnoDB memory heap is disabled
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Using Linux native AIO
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Using SSE crc32 instructions
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Completed initialization of buffer pool
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Highest supported file format is Barracuda.
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: 128 rollback segment(s) are active.
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Waiting for purge to start
    2019-06-06 6:22:34 140246067195008 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 15483980232
    2019-06-06 6:22:34 140246067195008 [Note] Plugin 'FEEDBACK' is disabled.
    2019-06-06 6:22:34 140245395830528 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2019-06-06 6:22:34 140246067195008 [Note] Server socket created on IP: '127.0.0.1'.
    2019-06-06 6:22:34 140246067195008 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '10.1.40-MariaDB-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Ubuntu 18.04

    Comment

    Working...