start(){
[ -x $exec ] || exit 5
# check to see if it's already running
RESPONSE=`/usr/bin/mysqladmin --socket="$socketfile" --user=UNKNOWN_MYSQL_USER ping 2>&1`
if [ $? = 0 ]; then
# already running, do nothing
action $"Starting $prog: " /bin/true
ret=0
elif echo "$RESPONSE" | grep -q "Access denied for user"
then
# already running, do nothing
action $"Starting $prog: " /bin/true
ret=0
UNKNOWN_MYSQL_USER@localhost as on SET NAMES Quit
ps ax | grep mysql
. Второе, проверьте, не заполнен ли диск на 100%? df -h
. Ну и третье - нужно смотреть логи самого мускула. [client]
port = 3306
socket = /var/lib/mysqld/mysqld.sock
default-character-set = utf8
[mysqld_safe]
nice = 0
socket = /var/lib/mysqld/mysqld.sock
[mysqld]
# Basic mysql server configuration
user = mysql
port = 3306
bind-address=127.0.0.1
basedir = /usr
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysqld.sock
skip-external-locking
default-storage-engine = innodb
pid-file = /var/run/mysqld/mysqld.pid
transaction-isolation = READ-COMMITTED
max_allowed_packet = 16M
myisam-recover = BACKUP
expire_logs_days = 10
max_binlog_size = 100M
log = /var/log/mysqld.log
# Cache parameters
query_cache_size = 32M
table_open_cache = 4096
thread_cache_size = 32
key_buffer = 16M
thread_stack = 128K
join_buffer_size = 2M
sort_buffer_size = 2M
# Parameters for temporary tables
tmpdir = /tmp
max_heap_table_size = 32M
tmp_table_size = 32M
# InnoDB parameters
#innodb_file_per_table
innodb_buffer_pool_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 64M
innodb_flush_method = O_DIRECT
# Database charset parameters
character-set-server = utf8
collation-server = utf8_unicode_ci
init-connect = "SET NAMES utf8 COLLATE utf8_unicode_ci"
#skip-character-set-client-handshake
skip-name-resolve
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
default-character-set = utf8
[mysql]
[isamchk]
key_buffer = 16M
# Include additional settings
!includedir /etc/mysql/conf.d/
cat /dev/null > /var/lib/mysql/web.local.err
(остальные логи по аналогии)160706 12:13:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160706 12:13:46 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
160706 12:13:46 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
160706 12:13:46 [Note] /usr/libexec/mysqld (mysqld 5.5.50-log) starting as process 69953 ...
160706 12:13:46 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
160706 12:13:46 [Note] Plugin 'FEDERATED' is disabled.
160706 12:13:46 InnoDB: The InnoDB memory heap is disabled
160706 12:13:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160706 12:13:46 InnoDB: Compressed tables use zlib 1.2.3
160706 12:13:46 InnoDB: Using Linux native AIO
160706 12:13:46 InnoDB: Initializing buffer pool, size = 7.3G
160706 12:13:46 InnoDB: Completed initialization of buffer pool
160706 12:13:46 InnoDB: highest supported file format is Barracuda.
160706 12:13:47 InnoDB: Waiting for the background threads to start
160706 12:13:48 InnoDB: 5.5.50 started; log sequence number 1595916
160706 12:13:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160706 12:13:48 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160706 12:13:48 [Note] Server socket created on IP: '0.0.0.0'.
160706 12:13:48 [Warning] 'user' entry 'root@web.local' ignored in --skip-name-resolve mode.
160706 12:13:48 [Warning] 'user' entry '@web.local' ignored in --skip-name-resolve mode.
160706 12:13:48 [Warning] 'proxies_priv' entry '@ root@web.local' ignored in --skip-name-resolve mode.
160706 12:13:48 [Note] Event Scheduler: Loaded 0 events
160706 12:13:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.50-log' socket: '/var/lib/mysql/mysqld.sock' port: 3306 MySQL Community Server (GPL) by Remi
160706 12:26:51 [Note] /usr/libexec/mysqld: Normal shutdown
160706 12:26:51 [Note] Event Scheduler: Purging the queue. 0 events
160706 12:26:51 InnoDB: Starting shutdown...
160706 12:26:52 InnoDB: Shutdown completed; log sequence number 1595916
160706 12:26:52 [Note] /usr/libexec/mysqld: Shutdown complete
160706 12:26:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended