Comment 15 for bug 1430852
Revision history for this message
| Jason Hobbs (jason-hobbs) wrote Re: [Bug 1430852] Re: Very slow load times for view node pages in MAAS | #15 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
On 06/03/2015 09:31 AM, Blake Rouse wrote:
> Here is the breakdown of the query plan for the first one in the paste
> which is the slowest one.
>
> http://
>
> You can see that everything is using an index and that a LIMIT is set to
> 50, so the query should not be that long. Unless this information is
> cached to the disk and needs to be loaded into memory.
>
> Have you tried placing the MAAS machine on an SSD or maybe a PCI-E SSD
> to speed up the loading of indexes from the disk? Bcache might be
> something to look into to fix this issue.
Sure - SSD might help. If MAAS needs an SSD to be performant though,
that's not great.
> I really do not know of a way in MAAS to speed this up. With so many
> events in OIL I think you will need to look into upgrading the storage
> on the server that hosts the MAAS service.
How about giving us a way to clear out old events, or limit the number
of events?
Jason