by Visakh S | Jun 16, 2015 | MySQL, Server Administration
In VPS and dedicated servers, especially in those running high traffic websites, MySQL server sometimes fails to respond with the error [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#XXXXX.MYI’; try to repair it. This often leads to a...
by Visakh S | Jan 8, 2015 | cPanel, FTP, MySQL, Technical Support
cPanel logs provide a goldmine of information to quickly resolve various customer issues and server errors. Here’s a list of the cPanel logs most commonly used by our expert server administrators, and the commonly sought information in them. cPanel mail logs...
by Hamish Oscar Lawrence | Oct 6, 2011 | cPanel, MySQL, Server Administration
Managing a database and its user is a simple task, when done from within cpanel. Creating a Database, assigning the DB user, and associated privileges.. all are covered in this quick...
by Hamish Oscar Lawrence | Dec 8, 2010 | MySQL, Server Administration
Most of us are familiar with LAMP, the most popular free/open source solution stack in use today. There is an, not as popular, alternative that database intensive site owners might be interested in: LAIP. While LAMP stands for Linux, Apache, MySQL and PHP; LAIP swaps...
by Hamish Oscar Lawrence | Nov 22, 2010 | MySQL, Server Administration
The MySQL replication team have been hard at work improving the features of MySQL replication. In this part, I’ll be talking about a few more features included in MySQL 5.5 Automatic Relay Log Recovery If this features is enabled, when a Slave recovers from a...
by Hamish Oscar Lawrence | Nov 19, 2010 | MySQL, Server Administration
There have been many advancements in MySQL 5.5, a majority of them have been towards improving performance and scalability. InnoDB is now the default storage engine, which provides higher levels of performance and reliability than MyISAM. InnoDB 1.1 that is, a...
Recent Comments