Display Slow Queries & Performance Issues in admincp

[Alpha1]

It would be very valuable for the XenForo addon scene if every install of xenforo would have the function to display slow queries to the admin. It would show the admin that users are experiencing slow loading pages and therefore they can act upon it, by:

• Reporting slow Queries to the addon developer
• Reporting hosting issues to the host

The report would need to include the stack trace as well as a few server configuration specifications, so that when the report is useful to to admin, host and the addon developer.
The reports could show in the same way as errors. In this case there would need to be a setting to ignore performance reports.

This would mean that developers are alerted much quicker about performance issues. And therefore it would also be easier for us to spot problematic addons.

Overall this would lead to higher quality standards for XenForo addons.

 

[Alpha1]

@Xon @siONtI @Nirjonadda @Alien please add your vote to this thread as well.

 

[Xon]

There are corresponding logs on the server, it is superfluous

Matching a query in the MySQL slow query log to an XenForo add-on is really non-trivial. Especially matching it to which part of a complex add-on.

For that you need a stack trace from php and the query.

 

[Ozzy47]

Care to eloborate? I don't know how to display slow queries with 2 requests honestly. Would be great to know how.

Were you provided with this yet?

 

[sbj]

Were you provided with this yet?

Like always, no.

 

[Ozzy47]

Like always, no.

Maybe it's not so easy to display the slow queries with the stack trace then.

 

[gogo]

I'm not sure if I understand this correctly. But is it good to require the developer to show the number of queries involved in the add-on on their add-on page? Or/and also other numerical indicators that'll affect server performance.

So that will become one of the indicators for potential users/buyers to pick that add-on. And because this is important, developers will put more attention on this area.

What do you think?

 

[Ozzy47]

No. Generally the number of queries are not a concern. 100 well written queries can preform better than one badly written one.

 

[gogo]

I got that impression because seems "how many queries in this add-on" is an FAQ for many add-ons.