Solved

Slow Query Mysql

Posted on 2011-02-13
2
496 Views
Last Modified: 2012-05-11
In the log slow query in Mysql Server 5.5, the time that I can see is the time to process the query or the time to process the query + the time to send the results to the client?

Regards
0
Comment
Question by:lnrivera
2 Comments
 
LVL 14

Accepted Solution

by:
Scott Madeira earned 500 total points
ID: 34887336
It is the time to execute the query.  MySQL would have no knowledge of how long it took to do anything with the data after it produced the result.

http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
0
 

Author Comment

by:lnrivera
ID: 34932283
Then if I habe a slow wan connection to send the results, the time to send the results using the wan connection can increase the slow query log?
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
update joined tables 2 62
How to count in a table in php 22 49
How to extract database info from current month and year 7 32
show child records separated by commas 12 34
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question