MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Server times out when GROUP BY has more than one group
Posted by: Peter Brawley
Date: February 16, 2021 10:32PM

Is f_avg_salary() a UDF compiled into your server (as described in https://dev.mysql.com/doc/refman/8.0/en/create-function-udf.html)?

Let's see its code, and the result of running Explain on the query.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Server times out when GROUP BY has more than one group
476
Mike Mohr
February 16, 2021 09:57PM
Re: Server times out when GROUP BY has more than one group
240
Peter Brawley
February 16, 2021 10:32PM
Re: Server times out when GROUP BY has more than one group
290
Mike Mohr
February 18, 2021 10:38PM
Re: Server times out when GROUP BY has more than one group
260
Peter Brawley
February 18, 2021 11:52PM
Re: Server times out when GROUP BY has more than one group
286
Mike Mohr
February 19, 2021 11:58PM
Re: Server times out when GROUP BY has more than one group
272
Peter Brawley
March 02, 2021 11:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.