Hosting MySQL’s tips- Error 28 from Storage Engine

May 15, 2013

This is our final

If you have any experience with hosting MySQL systems you have probably come across the following error. Here are some tips on how to fix it.

Error 28 is a common error message from your MySQL storage engine.  This message indicates that the drive is full – meaning that one or more of the partitions on your server is out of space, and MySQL cannot write to the disk. You need to clear disk space for MySQL to operate. Note that, if you have a dedicated server, you may receive this error even if your control panel still shows free space. (For example, cPanel does not include the database disk space used—it just calculates the disk space of /home/cPanel_username (root directory) for the account.)

Often, the problem can be solved by cleaning up your /tmp directory, which can be overfilled with unnecessary files, like older backups from a scheduled backup script.

First, stop MySQL immediately.

On cpanel the /tmp directory is an image created on the / drive so removing files from it won’t help…
Some places worth checking on cpanel is the domlogs if they do not need stats or /home/cpbackuptmp as it is a temporary directory for backups so long as backups are not currently running. Also to check their actual backups and if they are on the same drive that they aren’t keeping too much retention vs available size on their drive… I.e if they have a 250gb drive and /home & /var/lib/mysql are 80gb keeping a daily & weekly will fill up the drive every time backups run.

Restart MySQL.

# /etc/init.d/mysql start

If your /tmp directory is not causing the error, you may also need to look into your /var/log  directory and remove or compress the logs.

Additionally, periodically optimizing your tables in MySQLcheck improves database performance.  Optimizing is a similar process to defragmentation.

mysqlcheck –all-databases –analyze –optimize -u root -p

You can also repair all tables in your database.

 mysqlcheck --all-databases --auto-repair -u root -p

Analyzing, optimizing, and repairing tables can also easily be scheduled as a cron job.

In PHPMyAdmin, table optimization is done by cleaning up table overhead.  Overhead is similar to hard drive defragmentation—database tables that are frequently accessed or updated store extra file size, called “Overhead,” that can take up a lot of space over time and requires maintenance.  To clear this space, login to PHPMyAdmin, select the applicable database, and you should see a list of all the tables in the database.  In the far right column, note the heading “Overhead.”  Check all the tables that have an “Overhead” value listed.  At the bottom of the window, you’ll find a drop-down menu.  Choose “Optimize Table” from the menu.  Overhead will be cleared, and if you click on the database name again, you’ll see all €œOverhead” values should be cleared.

Hope this helps anyone out there looking to solve issues with their hosted Mysql setup.

by Dan Salcedo
To learn more about SingleHop's Disaster Recovery and Business Continuity offerings and how they can help you prepare for disaster, visit our website, resource center or chat with one of our experts.
Read Also:
Making Your Private Cloud DevOps Ready The Hybrid RAID Diagnosis to Solution

Elders is just another name for Pastors…as is Bishop. They are all the same office. An EltsB/Paedor/rishop is the same man. Now, if a congregation feels that they need more than one Elder, then by all means, pick as many as you feel need of. But, an Elder ruling a Church is not a CEO/Dictator mentality. It’s an overseeing, leading, inspiring, shepherding role.David

Recent Tweets

Ready to Transform Your IT Strategy?

From groundbreaking server management software and automation platforms to custom, flexible managed infrastructure solutions, we win customers because we put customers’ unique needs at the center of every solution.

"I feel the customer service is light years better at SingleHop than with my previous provider. I love that I can call the 24 hour support line when things are simply easier to explain on the telephone than in a support ticket. "

Jane, SingleHop Customer

"Wonderful service. We really appreciate your willingness to work with us to help our business succeed. "

Aviva, SingleHop Customer

"As always I can depend on SingleHop Tech Support team for an assist whenever we need them. They’ve exceeded our expectations each and every time for the last 7 years. "

Rodney, SingleHop Customer

"Excellent! Hardware and software are important in this environment but what is truly outstanding is the tech support that comes with it!"

Kenneth, SingleHop Customer

"[The] completed task has made a serious difference in the server’s performance. Thanks for digging deeper. The efforts/findings were so worth the time taken, in my eyes!"

Michael, SingleHop Customer

"The crew is indeed outstanding. Everyone is involved with your case; they respond promptly and accurately.
They are always correct and incredibly fast."

Juliana, SingleHop Customer