problem with mysql

[rout3rx]

Hi before and after upgrading to latest version (11.5.0) i have some problem with mysql
now sometimes after login to plesk i get this error :

ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): No such file or directory (auth.php:142)

my.cnf configurarion :

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
#skip-innodb
key_buffer = 768M
table_cache = 512
sort_buffer_size = 512K
read_buffer_size = 256K
read_rnd_buffer_size = 1024K
net_buffer_length = 2K
max_allowed_packet = 64M
thread_stack = 256K
query_cache_limit = 1152M
query_cache_size = 128M
query_cache_type = 1
max_connections = 350
max_user_connections=20
interactive_timeout = 70
wait_timeout = 25
connect_timeout = 10
thread_cache_size = 128
max_connect_errors = 10
tmp_table_size = 256M
max_heap_table_size = 128M
innodb_buffer_pool_size = 4G
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
join_buffer_size = 1024
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
myisam_sort_buffer_size = 64M
log-bin
server-id=1

[mysqldump]
quick


[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

how fix this issue?
thanks

 

[IgorG]

Have you ever tried to restart mysql service with

# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start

and then check errors in log file /var/log/mysqld.log ?

 

[lvalics]

Or check /var/lib/mysql/*.err there is more valuable info of what is the issue with my.cnf

 

[rout3rx]

31230 20:12:01 [Note] /usr/libexec/mysqld: Normal shutdown

131230 20:12:01 [Note] Event Scheduler: Purging the queue. 0 events
131230 20:12:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 17  user: ''

131230 20:12:07  InnoDB: Starting shutdown...
131230 20:12:10  InnoDB: Shutdown completed; log sequence number 28 1652310126
131230 20:12:10 [Note] /usr/libexec/mysqld: Shutdown complete

131230 20:12:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131230 20:12:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131230 20:12:11 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
131230 20:12:11 [Warning] option 'join_buffer_size': unsigned value 1024 adjusted to 8200
131230 20:12:11 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem.
131230 20:12:11  InnoDB: Initializing buffer pool, size = 4.0G
131230 20:12:11  InnoDB: Completed initialization of buffer pool
131230 20:12:12  InnoDB: Started; log sequence number 28 1652310126
131230 20:12:12 [Note] Event Scheduler: Loaded 0 events
131230 20:12:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

it print's in /var/log/mysqld.log Regularly

 

[DirkF]

Change this line from

#skip-innodb

to

skip-innodb

but then, plesk will tell you, that this is no good idea for an update...

 

[rout3rx]

Change this line from

#skip-innodb

to

skip-innodb

but then, plesk will tell you, that this is no good idea for an update...

it's not true! it damaged plesk.