Brak mysql.sock

[Corypto 0]

 

Witam, wczoraj zrobiłem aktualizacje modułów, z panelu webmin. Stworzył on nową konfiguracje do Mysql, oczywiście nie była ona optymalna to zastąpiłem ją swoją starą, która niestety nie działa.

 

logi z daemona:

May 24 17:52:53 88-198-129-237 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 [ERROR] Use --lc-messages-dir without language specific part instead.
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 [Note] Plugin 'FEDERATED' is disabled.
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 InnoDB: The InnoDB memory heap is disabled
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 InnoDB: Compressed tables use zlib 1.2.3.4
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 InnoDB: Using Linux native AIO
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 InnoDB: Initializing buffer pool, size = 128.0M
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 InnoDB: Completed initialization of buffer pool
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53 InnoDB: highest supported file format is Barracuda.
May 24 17:52:53 88-198-129-237 mysqld: 120524 17:52:53  InnoDB: Waiting for the background threads to start
May 24 17:52:54 88-198-129-237 mysqld: 120524 17:52:54 InnoDB: 1.1.8 started; log sequence number 1589349
May 24 17:52:54 88-198-129-237 mysqld: 120524 17:52:54 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
May 24 17:52:54 88-198-129-237 mysqld: 120524 17:52:54 [ERROR] Aborting
May 24 17:52:54 88-198-129-237 mysqld:
May 24 17:52:54 88-198-129-237 mysqld: 120524 17:52:54  InnoDB: Starting shutdown...
May 24 17:52:55 88-198-129-237 mysqld: 120524 17:52:55  InnoDB: Shutdown completed; log sequence number 1589349
May 24 17:52:55 88-198-129-237 mysqld: 120524 17:52:55 [Note] /usr/sbin/mysqld: Shutdown complete
May 24 17:52:55 88-198-129-237 mysqld:
May 24 17:52:55 88-198-129-237 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
May 24 17:53:07 88-198-129-237 /etc/init.d/mysql[9453]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 24 17:53:07 88-198-129-237 /etc/init.d/mysql[9453]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 24 17:53:07 88-198-129-237 /etc/init.d/mysql[9453]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 24 17:53:07 88-198-129-237 /etc/init.d/mysql[9453]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 24 17:53:07 88-198-129-237 /etc/init.d/mysql[9453]:

 

tak wyglądał mój my.cnf przed próbą naprawy, i on działał bez zarzutu

[mysqld]
tmpdir = /tmp
set-variable = max_connections=30
max_user_connections=24
safe-show-database
#skip-locking
skip-innodb
skip-external-locking
key_buffer = 16M
sort_buffer_size = 64M
record_buffer = 32M
table_cache = 2000
thread_cache_size = 256
tmp_table_size = 190M #128M
read_rnd_buffer_size = 768K
read_buffer_size = 8M
max_allowed_packet = 16M
query_cache_limit = 8M
query_cache_size = 35M
query_cache_type = 1
thread_concurrency = 4
default-character-set = utf8
# dodano po optymalizacji
join_buffer_size = 256K
max_heap_table_size = 50M
log-slow-queries = /var/log/mysql-slow-queries.log
long_query_time = 5
open_files_limit = 5000
!includedir /etc/mysql/conf.d/

 

A tak wygląda teraz, po dużej ilości przeczytanych for i tematów, lecz dalej nie działa:

[client]
socket=/var/run/mysqld/mysqld.sock
port=3306

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

[mysqld]
user=mysql
bind-address=127.0.0.1
datadir=/var/lib/mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysql/mysql.sock
port=3306
tmpdir=/tmp
language=/usr/share/mysql/english
skip-external-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=3000
max_user_connections=600
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_stack=128K
thread_cache_size=128
myisam-recover=BACKUP
#key_buffer - 64M for 1GB, 128M for 2GB, 256 for 4GB
key_buffer=128M
#join_buffer_size - 1M for 1GB, 2M for 2GB, 4M for 4GB
join_buffer=2M
max_allowed_packet=32M
table_cache=1024
#sort_buffer_size - 1M for 1GB, 2M for 2GB, 4M for 4GB
sort_buffer_size=2M
#read_buffer_size - 1M for 1GB, 2M for 2GB, 4M for 4GB
read_buffer_size=2M
#read_rnd_buffer_size - 768K for 1GB, 1536K for 2GB, 3072K for 4GB
read_rnd_buffer_size=1536K
max_connect_errors=10
thread_concurrency=4
#myisam_sort_buffer_size - 32M for 1GB, 64M for 2GB, 128 for 4GB
myisam_sort_buffer_size=64M
skip-locking
skip-bdb
expire_logs_days=10
max_binlog_size=100M
server-id=1

[mysql.server]
user=mysql
basedir=/usr

[safe_mysqld]
bind-address=127.0.0.1
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192
SAFE_MYSQLD_OPTIONS=”–defaults-file=/etc/my.cnf –log-slow-queries=/var/log/slow-queries.log”

#[mysqldump]
#quick
#quote-names
#max_allowed_packet=16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
#key_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
key_buffer=128M
#sort_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
sort_buffer=128M
#read_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
read_buffer=32M
#write_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
write_buffer=32M

[myisamchk]
#key_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
key_buffer=128M
#sort_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
sort_buffer=128M
#read_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
read_buffer=128M
#write_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
write_buffer=128M

[mysqlhotcopy]
interactive-timeout

!includedir /etc/mysql/conf.d/

 

Może wiecie, czemu dalej nie tworzy mi pliku mysql.sock??

 

 

Idiota za mnie, problem rozwiązany ... do usunięcia temat.

Edytowano Maj 24, 2012 przez Corypto (zobacz historię edycji)

[Kolopik 222]

Usuń/zahashuj linię:

socket=/var/run/mysqld/mysqld.sock

 

 

Idiota za mnie, problem rozwiązany ... do usunięcia temat.

 

Nie zauważyłem.

Edytowano Maj 24, 2012 przez Kolopik (zobacz historię edycji)

[kammil1 0]

może napiszesz jak rozwiązałeś problem? bo może być tak ,że dla kogoś te ustawienia będą przydatne.

 

///

edit nie widziałem że kolopik napsiałeś.

Edytowano Maj 24, 2012 przez kammil1 (zobacz historię edycji)