Hi
when mysql down not started
try:
/etc/rc.d/init.d/mysql restart
No mysqld pid file found. Looked for /var/lib/mysql/serv.domain.com.pid.
working only if reboot the system.
my.cnf is:
when mysql down not started
try:
/etc/rc.d/init.d/mysql restart
No mysqld pid file found. Looked for /var/lib/mysql/serv.domain.com.pid.
working only if reboot the system.
my.cnf is:
[mysqld]
skip-innodb
skip-locking
skip-bdb
long_query_time=5
connect_timeout=5
wait_timeout=5
interactive_timeout=50
max_connections = 600
key_buffer_size = 384M
max_allowed_packet = 1M
table_cache = 640
sort_buffer_size = 2M
read_buffer_size = 2M
thread_cache_size=128
join_buffer=1M
record_buffer=1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
query_cache_type=1
thread_cache = 8
query_cache_size = 32M
query_cache_limit = 1M
thread_concurrency = 8
low-priority-updates
thread_stack = 128K
[safe_mysqld]
err-log=/var/log/mysqld.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
safe-updates
no-auto-rehash
connect_timeout=10
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 32M
write_buffer = 32M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 32M
write_buffer = 32M