×
K5.1.1 is released (10 Jun 2018)

The Kunena team is pleased to announce Kunena 5.1.1 [K 5.1.1].
Please read the blog post for information:

Question Query mysql from kunena make cpu high

More
2 years 7 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
2 years 7 months ago #2 by 810
could you add the kunena report

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

More
2 years 7 months ago - 2 years 7 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! [ Click to expand ]

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! [ Click to expand ]
| Kunena integration settings:
Warning: Spoiler! [ Click to expand ]
| Joomla! detailed language files installed:
Warning: Spoiler! [ Click to expand ]

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: 2 years 7 months ago by tienndnguyenduc.

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

More
2 years 7 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
2 years 7 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 add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.096 seconds