General discussion

Locked

How to find Top N frequently using queries in MySql

By ankarao11 ·
Hi Gurus,

i have following tasks to finish for load testing.

1. How to find Top N frequently using queries in MySql?

2. Top N Frequently using Tables

3. Top N queries taking more response time

4. Avg. response time (Read/write) per query

any help should be appriciated

thanks

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

This should be a start

by Tony Hopkinson In reply to How to find Top N frequen ...

http://dev.mysql.com/doc/refman/5.1/en/query-log.html

Google is your friend

Collapse -

not find from google

by ankarao11 In reply to This should be a start

Hi Tony Hopkinson,

y'day i googled for several hours but not found even one post for

"Top N frequently using queries in mysql"

i expected that mysql senior people or loading people knew it that's why i posted it here,

Collapse -

Well I wouldn't call my self a mysql senior

by Tony Hopkinson In reply to not find from google

but I did find the right google string thru prior knowledge.

Teh trick with google is to reword you question going from detailed to more and more general.

myslq query performance
would have been a good start, there are some nice tools about that might be of interest by the look of it.

There's a knack to googling you develop as you go along.

Collapse -

Exactly

by mafergus In reply to Well I wouldn't call my s ...

Knowing how to look is almost as import as knowing...

http://dev.mysql.com/doc/refman/5.1/en/log-tables.html

this tell you exactly what u need to know, but education is a good thing. Mysql has a number of nice monitoring features built in.

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums