Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Database is full alert

Avatar

Avatar
Validate 1
Level 1
Ramaswami
Level 1

Likes

0 likes

Total Posts

100 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
Ramaswami
Level 1

Likes

0 likes

Total Posts

100 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile
Ramaswami
Level 1

09-09-2020

Hi Team, 

 

i got an alert from adobe saying that database is full upto 82%. 

 

What i am doing is applying some data retention rules on the custom tables. 

For example : in my prod instance it has lot of custom tables with large data and i am applying a delete based on some criteria. 

 

i am using a javascript node : 

and executing a delete function like below : 

 

var delete = "delete from tablename where created date > some date"

sqlexec(delete);

 

Note : i am not commiting this. 

 

i am doing like this for two or three tables and checked the database capacity and it is still 82% 

 

So now i am getting doubt that should we use commit statement after "sqlexec(delete)" like ( sqlexect("commit")) OR is it okay to execute without commit. 

 

Does my assumption is correct ? ( that since i am not using commit the database percentage is not changing ) OR is it some other reason the percentage usage is not changing. 

 

What is the role of commit here. 

 

Also just to know i still needs to do clean up for more tables. also can you suggest any other steps to clean up the custom tables or anything to decrease the database space?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

256 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

256 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
DavidKangni
MVP

09-09-2020

Hi Ramaswami,

 

You may need to do a defragmentation of data across the database as it removes bloat from the system which is caused by constant deletes done to the schemas.

In high transactional databases, deletes performed on schemas cause bloat or empty spaces. This bloat continuously grows until a defragmentation is carried out.
Some of the indexes also need to be deleted or recomputed.

 

You can find more details Data model best practices  or Technical maintenance 

 

Basically, you will need a DBA to help with the maintenance, cleanup table, re-index tables etc. 

You can also get in touch with Adobe PS to complete a database usage plus instance audit and let you know what steps to take.

 

Thanks,

David

Answers (0)