Category Archives: mysql

Host X is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

Posted on August 27, 2011 by admin

I got following error in a PHP Application Warning: mysql_connect() [function.mysql-connect]: Host ‘server10.hosthat.com’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ in /home/hon/public_html/cp/admin/approve.php on line 6 Unable to connect to mysql server This is because MySQL server … Continue reading →

Posted in mysql | Tagged , , , | Leave a comment

Limit number of connections for MySQL user

Posted on October 19, 2009 by admin

To limit number of mysql connection per user, edit /etc/my.cnf vi /etc/my.cnf In [mysqld] section, set value for max_user_connections. [mysqld] max_user_connections=40 This will limit mysql connections at a time for any user to 40.

Posted in mysql | Tagged , , | Leave a comment

MySQL take too much time to start

Posted on May 7, 2008 by flashweb

On one of the Free phpBB hosting server, MySQL take about 18 minutes to start. That is if i restart MySQL for any reason (including server reboot), it take too much time to just start the MySQL server. The server … Continue reading →

Posted in mysql | Tagged | Leave a comment

Changing MySQL data folder

Posted on May 5, 2008 by flashweb

Today a client wanted to move his MySQL database to second hard disk. Moving MySQL database to its own hard disk improve IO performance as the hard disk only need to serve MySQL data, nothing OS related. This was a … Continue reading →

Posted in mysql | Tagged , | Leave a comment

MySQL blog

Posted on March 28, 2008 by flashweb

Today i found a blog on MySQL performance.  http://www.mysqlperformanceblog.com/mysql-performance-presentations/ I manage many big MySQL databases, some are over 20 GB in size. But i have not yet done much MySQL optimizations.  For me, it is good CPU and enough RAM … Continue reading →

Posted in mysql | Tagged | Leave a comment

MySql not starting on new cpanel server

Posted on June 6, 2007 by flashweb

On new cpanel server, MySQL is not starting. # service mysql start Starting MySQLCouldn’t find MySQL manager or server [FAILED] # Can’t find anything in log file /var/log/mysql.log I tried removing rpm of mysql and resinstalled mysql with /scripts/mysqlup –force … Continue reading →

Posted in Cpanel Server, mysql | Leave a comment