by lifeLinux on February 23, 2013
Today, I got following MySQL error in a PHP application: Host ‘host_name’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’. It means that mysqld has received many connection requests from the given host. Default max_connect_errors value is 10, that is remote host will be blocked if there is more than 10 connection […]
by lifeLinux on August 1, 2011
There’s a simple command to automatically check, repair and optimize all tables in all databases when you’re running a MySQL server on Linux / Unix / BSD. mysqlcheck -u{username} -p{password} –check –optimize –auto-repair –all-databases
by lifeLinux on May 8, 2011
The slow query log consists of all SQL statements that took more than long_query_time seconds to execute and required at least min_examined_row_limit rows to be examined. The time to acquire the initial table locks is not counted as execution time. mysqld writes a statement to the slow query log after it has been executed and […]
by lifeLinux on May 1, 2011
If you have very large mysql database then it is very hard to backup and restore using the conventional phpmyadmin or any other programs. In this Tutorial I will explain you how to backup and restore a larger database. This tutorial can be used while moving your database from one server to another.
by lifeLinux on November 24, 2010
The MySQL access control system enables you to create MySQL accounts and define what each account can do. The steps bellow to create a new user MySQL account.
by lifeLinux on November 24, 2010
By default, MySQL server will be installed with root account and password is blank. If you have set the password for root and forget it, then you will need to reset the root password for MySQL.
by admin on November 23, 2010
Issue with shared InnoDB /var/lib/mysql/ibdata1 storage InnoDB tables currently store data and indexes into a shared tablespace (/var/lib/mysql/ibdata1). Due to the shared tablespace, data corruption for one InnoDB table can result in MySQL failing to start up on the entire machine. Repairing InnoDB corruption can be extremely difficult to perform and can result in data […]