Hello,

Dear friends

I get This message "mysqld dead but subsys locked " today after adjustment my.cnf,

My linode is 4GB Ram with
OS: Centos 6.4 (updated to CentOS release 6.5 (Final)).
Mysql-Server Version: mysql Ver 14.14 Distrib 5.1.71, for redhat-linux-gnu (i386) using readline 5.1n
using LAMP Stack, serve Drupal 7 CMS Website with innodb DB.
Apache: Server version: Apache/2.2.15 (Unix).
PHP: PHP 5.3.3 .

my New MysqlServer Config File is:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

symbolic-links=0
default-time-zone = '+02:00'
skip-networking
bind-address=127.0.0.1

server-id = 1
max_connections = 200
max_user_connections = 200
key_buffer = 128M
myisam_sort_buffer_size = 128M
max_allowed_packet= 16M
join_buffer_size = 8M
read_buffer_size = 8M
sort_buffer_size = 8M
thread_stack = 192K
thread_cache_size = 286
table_cache = 3072
table_definition_cache = 3072
read_rnd_buffer_size = 16M
net_buffer_length = 2K
connect_timeout = 20
interactive_timeout = 25
wait_timeout = 1800
max_connect_errors = 2000
binlog_cache_size = 1M
query_cache_limit = 4M
query_cache_size = 64M
query_cache_type = 1
tmp_table_size = 96M
max_heap_table_size = 96M
innodb_buffer_pool_size = 512M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 120
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

before adjustments mysql was take about 800% of cup usage, so now its works fine...

Is there are problem with this configurations or its not suitable for my VPS with limited RAM of 4GB.?

Or What do you think?

please help me to solving Mysql problems, and adjustment it...

Thank you very much and regards.