Hi @Geoffrey Shelton Okot, Thank you for your response. Yes, we currently have that ibdata file on a disk- which we believe we can increase the size of the of the same disk. if we change the size of the same disk then do we need to update the location anywhere? As we are not changing location of the ibdata file. is that correct? Please suggest. ... View more

@Jay Kumar SenSharma - Can you please suggest based upon the requested information? ... View more

@Jay Kumar SenSharma ... Can you please suggest based upon the requested information? ... View more

@Jay Kumar SenSharma Thank you for your response. Here is the requested output : +--------------------+---------------+ | DB Name | DB Size in MB | +--------------------+---------------+ | ambaridb | 651.8 | | hivedb | 30274.0 | | information_schema | 0.1 | | mysql | 0.6 | | ooziedb | 7041.9 | | performance_schema | 0.0 | | rangerdb | 29.4 | +--------------------+---------------+ I have few followup questions: 1. If we delete the data from the table will ibdata1 file size will shrink? 2. Can we increase the disk size for that mount point where the ibdata1 file resides? what steps we will need to take? appreciate your help in this! ... View more

@Geoffrey Shelton Okot Thank you. I think Decommissioning is a best way to do this. Do I need to turn on maintainance mode while I do decommissioning datanode? Also Do I need to stop the services like - NodeManager, Ambari metrics for that datanode after decommissioning? ... View more

@Geoffrey Shelton Okot Thank you for your response. Instead of Decommissioning the node Can I stop it? What is the difference? Whats the best way to stop it or Decommission? ... View more