Hey guys, I have a little problem. I have noticed that my queries are getting slower. Some update queries take about 48-50 seconds. Here’s how it looks: [image] [root@db-1 ~]# tail /var/lib/mysql/mysql-slow.log # Time: 131113 17:09:48 # User@Host: J[J] @ [10.xxx.xxx.35] # Query_time…

Queries are super slow

wagnerbianchi November 27, 2013, 4:15pm 3

Jaan,

Could you share with us the SHOW VARIABLES and SHOW STATUS of this MySQL instance in which you are running the query?

Cheers, WB

Topic		Replies	Views
update very slow Other MySQL® Questions	2	657	October 2, 2012
slow query w/ an inner join Other MySQL® Questions	1	433	April 25, 2007
Extremely slow update via primary key Other MySQL® Questions	1	2848	September 4, 2012
Slow query (i think) Other MySQL® Questions	0	308	February 17, 2008
Highly optimized queries are sometimes taking 20s to perform? Other MySQL® Questions	5	645	January 30, 2009