Mysql server takes longer than usual to respond

Hello Experts ?
Sometimes Mysql server takes longer than usual to respond...
then back to normal...
why is this ?
Regards,
RGuillermoProject ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

theGhost_k8Database ConsultantCommented:
"Sometimes" is very unclear point and there are many possibilities. It could be a backup holding-up, some specific timed queries / processes causing load on server, table locks depending on what engine you use and may be more...

I'd suggest you to provide some more information & then point out few things you can look.

- Is there anything specific that goes on during that small-response-time periods. Eg. backups, load
- Enable slow query log (long query time=1) and look for poorly performing things
- Are you using all Innodb? Any myisam tables? Which mysql version?
0
RGuillermoProject ManagerAuthor Commented:
Hi,
There is no backup process, no timed queries yet,
all is inodb

this is a MYSQL 5.7 working on  a virtual box machine with win 10.
and received connections from two non virtual stations in the LAN.

there is only one test database no backgroud processes but this happens..

it sometimes slows down as much as 10 to 15 seconds where usually was working very fast..

Regards,
0
theGhost_k8Database ConsultantCommented:
when you say "slows down" what do you mean? queries slow down or VM slows down?
What is the configuration of your VM and host system?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

RGuillermoProject ManagerAuthor Commented:
The VM and host are win10 4GB ram, and 32 GB RAM respectively.
Both working ok.

INSIDE MYSQL server when a command like UPDATE goes wrong
the next update to the same record is like waiting for the previews to finish...
I guess the record is locked...
what can I do to free this record after a previously failed command...
REgards
0
RGuillermoProject ManagerAuthor Commented:
Please, How do I release a locked register after a failed update?
0
Prabhin MPEngineer-TechOPSCommented:
mysql> show processlist;

Let's kill one of these processes

mysql> kill put_process_id_here;
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
theGhost_k8Database ConsultantCommented:
What do you mean by "Update goes wrong"? Do you have autocommit ON?
If you're not auto-committing then you may need to identify success/failure and commit/rollback your transaction accordingly.
0
RGuillermoProject ManagerAuthor Commented:
Thank you so much, Experts!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.