Login | Register
My pages Projects Community openCollabNet

Discussions > users > Re: [propel] Finding those slow queries

propel
Discussion topic

There will be a brief maintenance window every Friday at 17:00 Pacific.
For further details, see CollabNet's maintenance and upgrade policy.

Back to topic list

Re: [propel] Finding those slow queries

Reply

Author Łukasz Wojciechowski <LukaszWojciechowski at pronet dot lublin dot pl>
Full name Łukasz Wojciechowski <LukaszWojciechowski at pronet dot lublin dot pl>
Date 2009-07-21 00:29:26 PDT
Message Hi

Did You try mysql option log_slow_queries ?

In original MySQL version You cen define that You want to log queries
that takes longer then one second for example.

That could be the way for You to find queries that needs Your attention.

--
Best regards
Łukasz Wojciechowski

New Generation Software
+48 602 214 629
http://www.ngsoft.pl



2009/7/21 Murray Collingwood <murray@focus-com​puting.com.au>:
> Hi Propellers (is that what we are calling ourselves now?)
>
> I am starting to get a number of databases running on my web server and the
> traffic is starting to increase to the point where I am forced to begin
> optimising stuff (rather than just throwing more hardware at the server).
>
> So, I know I have some poor performance when I read this stat from my MySQL
> server:
> Handler_read_rnd_next 106 G The number of requests to read the next row in
> the data file. This is high if you are doing a lot of table scans. Generally
> this suggests that your tables are not properly indexed or that your queries
> are not written to take advantage of the indexes you have.
> That's a lot of sequential reads.  So, I'm missing some indexes... however I
> have some 20 databases and 623 tables.  That's 623 Propel Peer classes with
> maybe on average 5 queries per table.  Okay, so we're talking around 3000
> different queries defined.
>
> How do I find the fields that will benefit from indexing?
>
> Is there a nice little Propel configuration entry that will automatically
> tell me I should add an index to field 'A' on table 'B' in database 'C'?
> There is?  Excellent.  What is it?  Okay, so maybe that was a little bit
> hopeful.  What are other people doing?
>
> Cheers
> Murray
>
>
> --
> Murray Collingwood
> Focus Computing
> p +61 415 24 26 24
> http://www.focus-com​puting.com.au
>

« Previous message in topic | 2 of 11 | Next message in topic »

Messages

Show all messages in topic

Subject
Author
Full name
Date posted
+
[propel] Finding those slow queries Murray Collingwood <murray at focus-computing dot com dot au> Murray Collingwood <murray at focus-computing dot com dot au> 2009-07-20 23:02:52 PDT
     Re: [propel] Finding those slow queries Łukasz Wojciechowski <LukaszWojciechowski at pronet dot lublin dot pl> Łukasz Wojciechowski <LukaszWojciechowski at pronet dot lublin dot pl> 2009-07-21 00:29:26 PDT
         Re: [propel] Finding those slow queries Murray Collingwood <murray at focus-computing dot com dot au> Murray Collingwood <murray at focus-computing dot com dot au> 2009-07-21 02:30:13 PDT
             Re: [propel] Finding those slow queries Mickaël Adamadorassy <m dot adama at axidea dot fr> Mickaël Adamadorassy <m dot adama at axidea dot fr> 2009-07-21 03:07:31 PDT
             Re: [propel] Finding those slow queries Łukasz Wojciechowski <LukaszWojciechowski at pronet dot lublin dot pl> Łukasz Wojciechowski <LukaszWojciechowski at pronet dot lublin dot pl> 2009-07-21 03:18:51 PDT
             Re: [propel] Finding those slow queries Alan Pinstein <apinstein at mac dot com> Alan Pinstein <apinstein at mac dot com> 2009-07-21 06:06:29 PDT
                 Re: [propel] Finding those slow queries Murray Collingwood <murray at focus-computing dot com dot au> Murray Collingwood <murray at focus-computing dot com dot au> 2009-07-21 15:21:07 PDT
                     Re: [propel] Finding those slow queries Alan Pinstein <apinstein at mac dot com> Alan Pinstein <apinstein at mac dot com> 2009-07-21 16:17:33 PDT
                         Re: [propel] Finding those slow queries Justin Carlson <justin dot carlson at gmail dot com> Justin Carlson <justin dot carlson at gmail dot com> 2009-07-21 16:40:41 PDT
                         Re: [propel] Finding those slow queries Murray Collingwood <murray at focus-computing dot com dot au> Murray Collingwood <murray at focus-computing dot com dot au> 2009-07-21 17:39:56 PDT
                             Re: [propel] Finding those slow queries Alan Pinstein <apinstein at mac dot com> Alan Pinstein <apinstein at mac dot com> 2009-07-21 17:59:55 PDT
Messages per page: