Score:1

slow environment with high CPU usage

sn flag

I'm new to Linux metrics

in our test environment we experiment a slowness, after investigation we have found that the disk space used to store backup data is full, but what is wired for me is that the disk i/o is not high at all

we are working with MySQL server

here is the output of the top commandenter image description here

djdomi avatar
za flag
if the disk is full its like driving uphill with handbrake, however this screenshot does tell nothing.
Hamza AZIZ avatar
sn flag
Thanks for your comment, what you need to know if this screenshots Do not say anything for you ?
ua flag
Find the slow query, show it to us, provide `SHOW CREATE TABLE` and `EXPLAIN SELECT ...` From there, we can drive downhill.
djdomi avatar
za flag
at first show us ` df -h ` and also the load level as also the output of lscpu for one cpu moreover how big is the db?
Hamza AZIZ avatar
sn flag
i check the log file for slow query, but there is nothing there, i'm sure this is about no more enough space in the disk partition of backups, because when i deleted old backups the CPU return to its normal state, my question is why the disk i/o is not high considering that the problem is from the disk partition of backups
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.