Can't connect to local MySQL server through socket

[alesk]

Ubuntu server. Место есть.

Code: Select all

mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Code: Select all

 cat /etc/mysql/my.cnf
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_file_per_table

!includedir /etc/mysql/conf.d/

Code: Select all

# mysqld restart
150906 15:08:43 [Note] mysqld (mysqld 5.5.44-0ubuntu0.14.04.1) starting as process 1749 ...
# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

# cat /var/log/mysql/error.log
150906 15:08:43 [Note] Plugin 'FEDERATED' is disabled.
150906 15:08:43 InnoDB: The InnoDB memory heap is disabled
150906 15:08:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150906 15:08:43 InnoDB: Compressed tables use zlib 1.2.8
150906 15:08:43 InnoDB: Using Linux native AIO
150906 15:08:43 InnoDB: Initializing buffer pool, size = 128.0M
150906 15:08:43 InnoDB: Completed initialization of buffer pool
150906 15:08:43 InnoDB: highest supported file format is Barracuda.
150906 15:08:43  InnoDB: Waiting for the background threads to start
150906 15:08:44 InnoDB: 5.5.44 started; log sequence number 5242137053
mysqld: Too many arguments (first extra is 'restart').
Use --verbose --help to get a list of available options
150906 15:08:44 [ERROR] Aborting

150906 15:08:44  InnoDB: Starting shutdown...
150906 15:08:45  InnoDB: Shutdown completed; log sequence number 5242137053
150906 15:08:45 [Note] mysqld: Shutdown complete

Что еще показать? Как исправить?

[imperio]

Добрый день.


Возможно служба остановилась из-за нехватки памяти. Если будет падение, то скиньте вывод

Code: Select all

top

Запустите mysql командами

Code: Select all

service mysqld stop
service mysqld start

[alesk]

Через service mysql start запустилось, работает.

Как избежать ошибки в дальнейшем?

[skurudo]

Брать в руки mysqltunel и подбирать настройки для сервера базы данных