×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Freeing up disk space from information_schema

Freeing up disk space from information_schema

Freeing up disk space from information_schema

(OP)
I have unexpectedly inherited a MySQL deployment. The server is running low on disk space. Running the query below it looks like infromation_schema has 24,700MB free space. My OS is Ubuntu/Linux. MySQL version 5.7.22. My disk currently has 4% free space available.

SELECT table_schema "database name",
sum( data_length + index_length ) / 1024 / 1024 "database size in MB",
sum( data_free )/ 1024 / 1024 "free space in MB"
FROM information_schema.TABLES
GROUP BY table_schema
order by sum( data_free )/ 1024 / 1024 desc;

Any help into how I can reclaim some of this space?

Side note I have been told there are also 2 slave servers that are no longer synching pointed at this server as their master. Priority #1 is free up disk space and keep this server going. Priority #2 is get replication working again.

fyi-
This server/ aka: Master info
--------------------------------------------------------------
SHOW MASTER STATUS;
# File, Position, Binlog_Do_DB, Binlog_Ignore_DB, Executed_Gtid_Set
mysql-bin.002605, 50840918, '', '', ''

Slave 1 info
--------------------------------------------------------------
SHOW SLAVE STATUS;
Master_Log_File, Read_Master_Log_Pos,Relay_Log_Pos, Slave_IO_Running, Slave_SQL_Running
mysql-bin.001426,25768038, '376757', 'No', 'No'


Slave 2 info
--------------------------------------------------------------
SHOW SLAVE STATUS;
Master_Log_File, Read_Master_Log_Pos,Relay_Log_Pos, Slave_IO_Running, Slave_SQL_Running
mysql-bin.001676, 97815725, 4, 'No', 'Yes'

RE: Freeing up disk space from information_schema

Might be best to just get a larger hard drive and migrate the data over.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close