![]() ![]() If you would like to know how to avoid downtime for your customers due to service failures, we would be happy to talk to you. By following a systematic debugging approach for service failures, we have been able to minimize the downtime involved. This enables us to prevent a service downtime for our customers who are web hosts. Reinstalling the server – In cases where the MySQL binary is corrupt or installation is incomplete, we reinstall the server and get the service functional.Īt Bobcares, our 24/7 server specialists constantly monitor all the services in the server and proactively audit the server for any errors or corruption in them.Adding more swap memory – If the service failure is due to lack of adequate memory, we resolve that issue by increasing the swap memory allocated to the server.Correcting the configuration errors – Any errors in the configuration file my.cnf or table corruptions are immediately pin-pointed and resolved.By detailed examination of these log files, we are able to pinpoint and resolve the issues. Examining the error logs – MySQL stores its errors in ‘hostname.err’ and ‘hostname.log’ files.Allocating enough disk space – If the disk space in the server is not enough, we resolve it by removing unnecessary files and folders or moving data to different partitions.The ownership and permissions of the data directory are set such that the mysql user can read and modify them. Fixing the permissions/ownership – We m ake sure that MySQL server can access the data directory.Out of memory – If MySQL process is not getting enough memory due to abusive processes or any other valid process, it cannot start or would keep crashing all the time.Lack of disk space – Another cause for MySQL failures is lack of adequate disk space in the server, which can be verified using ‘df -h’ command. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |