Hi
What is solution for thei mysql error?
MySQL error in file: /engine/classes/mysqli.class.php at line 52
Error Number: 1
The Error returned was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
SQL query:
/etc/my.cnf has following values:
I get this error
root@se [/var/lib/mysql]# service mysql status
ERROR! MySQL is not running, but lock exists
root@se [/var/lib/mysql]#
What is solution for thei mysql error?
MySQL error in file: /engine/classes/mysqli.class.php at line 52
Error Number: 1
The Error returned was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
SQL query:
/etc/my.cnf has following values:
Code:
[mysqld]
datadir=/var/lib/mysql
local-infile=0
safe-show-database
query_cache_limit=128M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=2000
max_connections=300
#interactive_timeout=40
interactive_timeout=15
#wait_timeout=40
wait_timeout=15
#connect_timeout=40
connect_timeout=10
thread_cache_size=128
key_buffer=256M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M ## 1MB for every 1GB of RAM
read_buffer_size=2M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
skip-name-resolve
log_slow_queries = 10
slow_query_log_file = /var/log/mysql/slow_query_log
open_files_limit=50000
innodb_file_per_table=1
innodb_thread_concurrency =0
open_files_limit=4162
user = mysql
skip-external-locking
I get this error
root@se [/var/lib/mysql]# service mysql status
ERROR! MySQL is not running, but lock exists
root@se [/var/lib/mysql]#
Last edited: