mysql resources used by domain

[hardbrasil]

Hi fellas,
i am migrating some clients between Plesk panels
after migrate 10 domains the Health monitoring growup from MSQL from 1gb to 4.5gb
all 10 websites are small,

how can i see to identify which domain/subscription is consuming a lot of resources?

 

[Faris Raouf]

A very basic option would be:
#cd /var/lib/MySQL
#du -h --max-depth=1
This will show the size of all databases directories.
However, if your database names can't easily be matched to a Subscription, you might need to find a better way.

 

[hardbrasil]

Hi Faris, Thank you. i run the command and i got one database with 5.7 gb but without name.
do you know what is this?
see the print, latest DB

 

[Faris Raouf]

Ah. That's the total size of everything listed above.

Now, in my case, I felt that this number seemed larger than the total of all the individual directories. I don't know if this was really the case or not, and can't imagine why it would be bigger.

 

[Faris Raouf]

incidentally, rather than using du -h --max-depth=1 you can try just
# du -h | less

Then you can look in more detail at what is where.

You might also like to investigate ncdu
ncdu is a "graphical" version of du - it uses ncurses so works on the command line.
It is available in the epel repo if you happen to have that enabled on your machine.

 

[hardbrasil]

Hi Faris, i will try and i let you know.

many thanks

 

[hardbrasil]

Hello again, i found ibdata1 with 5gb space
i search on google about it and i found some tutorials that is telling to shrink mysql
http://vdachev.net/2007/02/22/mysql-reducing-ibdata1/

do you have an tip to make this as safe as possible regarding that this plesk has real customers on it
thanks!