2 replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
source | link

MariaDB 10.x | MyISAM

My question is very similar to thisthis one but regarding MyISAM.

I have a DB server that's running very low on disk space (2.5 GB free) and a MyISAM database with individual tables that are 3 GB and 8 GB in size. I've successfully deleted entries from the tables so I'm confident that some of the space is white space but I'm not sure how much.

I've heard conflicting statements from folks regarding what happens when running OPTIMIZE TABLE. Some people say it doesn't require any extra disk space... others tell me it will create a new table and copy individual rows into the new table... and only AFTER that's complete will it begin reclaiming disk space.

Can someone please clarify?

MariaDB 10.x | MyISAM

My question is very similar to this one but regarding MyISAM.

I have a DB server that's running very low on disk space (2.5 GB free) and a MyISAM database with individual tables that are 3 GB and 8 GB in size. I've successfully deleted entries from the tables so I'm confident that some of the space is white space but I'm not sure how much.

I've heard conflicting statements from folks regarding what happens when running OPTIMIZE TABLE. Some people say it doesn't require any extra disk space... others tell me it will create a new table and copy individual rows into the new table... and only AFTER that's complete will it begin reclaiming disk space.

Can someone please clarify?

MariaDB 10.x | MyISAM

My question is very similar to this one but regarding MyISAM.

I have a DB server that's running very low on disk space (2.5 GB free) and a MyISAM database with individual tables that are 3 GB and 8 GB in size. I've successfully deleted entries from the tables so I'm confident that some of the space is white space but I'm not sure how much.

I've heard conflicting statements from folks regarding what happens when running OPTIMIZE TABLE. Some people say it doesn't require any extra disk space... others tell me it will create a new table and copy individual rows into the new table... and only AFTER that's complete will it begin reclaiming disk space.

Can someone please clarify?

    Tweeted twitter.com/StackDBAs/status/770676266806763520
1
source | link

How much space is needed to reclaim space from a table in MyISAM

MariaDB 10.x | MyISAM

My question is very similar to this one but regarding MyISAM.

I have a DB server that's running very low on disk space (2.5 GB free) and a MyISAM database with individual tables that are 3 GB and 8 GB in size. I've successfully deleted entries from the tables so I'm confident that some of the space is white space but I'm not sure how much.

I've heard conflicting statements from folks regarding what happens when running OPTIMIZE TABLE. Some people say it doesn't require any extra disk space... others tell me it will create a new table and copy individual rows into the new table... and only AFTER that's complete will it begin reclaiming disk space.

Can someone please clarify?