• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 27
  • Last Modified:

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,
0
RGuillermo
Asked:
RGuillermo
  • 4
  • 3
2 Solutions
 
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now