×
Blue Eagle 5 v1.5.4 has been Released (13 Sep 2020)

The Kunena team has announce the arrival of Kunena template Blue Eagle 5 v1.5.4 which is now available for download. This version addresses most of the issues that were discovered in development.

Question Query mysql from kunena make cpu high

More
4 years 10 months ago #1 by tienndnguyenduc
Hi,

UPDATE u3gbc_kunena_users AS u
LEFT JOIN (
SELECT userid, MAX(expiration) AS banned FROM u3

Please view and recommend me how to optimize it

Kunena: 4.0.6
Kunena user total: 321848

Thankyou so much,

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #2 by 810
could you add the kunena report

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago - 4 years 10 months ago #3 by tienndnguyenduc
This message contains confidential information

Database collation check: The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Missing | PHP environment: Max execution time: 600 seconds | Max execution memory: 128M | Max file upload: 8M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : domain_db | author: domain.com | version: 1.0.0 | creationdate: Unknown

Kunena default template details : domain Mainsite Forum | author: domain Team | version: 1.0.0 | creationdate: 16/10/2013

Kunena version detailed: Kunena 4.0.6 | 2015-09-28 [ Pielungo ]
| Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: UddeIM 3.5

Third-party SEF components: sh404sef 4.6.0.2718

Plugins: Search - Kunena Search 3.1.1

Modules: Kunena Stats 3.1.1

Last edit: 4 years 10 months ago by tienndnguyenduc.

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #4 by tienndnguyenduc
Hi,

I found that the time to "Sending data" of query is very long,

Recommend me how to fix it,

Thanks,

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #5 by 810
mhh should be ok, do you have extra plugins installed, try to disable them, and enable it, until the cpu is high again.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.145 seconds