Could not connect to MySQL

userda

New member
Joined
Mar 9, 2011
Messages
3
One process MySQL result of that is started only there is an overflow connection to a MySQL at all users. It was updated with 5.0 on 5.1 hasn't helped.


At restart, nano /var/lib/mysql/... err

110309 10:16:28 [Note] /usr/sbin/mysqld: Normal shutdown

110309 10:16:28 [Note] Event Scheduler: Purging the queue. 0 events
110309 10:16:28 InnoDB: Starting shutdown...
110309 10:16:31 InnoDB: Shutdown completed; log sequence number 0 153912309
110309 10:16:31 [Note] /usr/sbin/mysqld: Shutdown complete

110309 10:16:31 mysqld_safe mysqld from pid file /var/lib/mysql/XXXXX.ru.pid ended
110309 10:16:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110309 10:16:32 [Note] Plugin 'FEDERATED' is disabled.
110309 10:16:32 InnoDB: Initializing buffer pool, size = 8.0M
110309 10:16:32 InnoDB: Completed initialization of buffer pool
110309 10:16:32 InnoDB: Started; log sequence number 0 153912309
110309 10:16:32 [Note] Event Scheduler: Loaded 0 events
110309 10:16:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.54-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

OS Centos 5.5 x86_64
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.1.54
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent Off Off
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli
MysqlI Support enabled
Client API library version 5.1.54
Client API header version 5.1.54
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
 
Hello,

what do you mean with

is an overflow connection to a MySQL


???

If you mean error

Too many connections

Open /etc/my.cnf and update it to feed your needs:

Code:
max_user_connections    = 32
max_connections         = 300

Additionally I would deny permanent connections from PHP scripts to MySQL server.
 
More than one process mysqld DirectAdmin 1.37 doesn't create

Hello,

what do you mean with




???

If you mean error



Open /etc/my.cnf and update it to feed your needs:

Code:
max_user_connections    = 32
max_connections         = 300

Additionally I would deny permanent connections from PHP scripts to MySQL server.

More than one process mysqld DirectAdmin 1.37 doesn't create.
One process mysqld can't process inquiries simultaneously more than 10 connections. Updating, reinstallation, max_connections the other haven't helped.

nano /etc/my.cnf
[mysqld]
local-infile=0
max_user_connections=75
max_connections=300

/etc/init.d/mysqld restart
Shutting down MySQL SUCCESS!
Starting MySQL SUCCESS!
 
9fef5b3e72.jpg

:confused:
 
Back
Top