×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

× Topics must relate to a currently supported version of Kunena. If you are unsure what is the current supported version of Kunena, please go to the download page.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Question Optimizing Kunena database tables

More
2 years 2 months ago #1 by Slacker
I have discovered that, when I try to optimize Kunena database tables with phpMyAdmin it is not possible and I get the advice to create a new table from the old one and then check it with analyze in phpMyAdmin. The reason I want to do this is that I have deleted about 30 % of mine forumposts.

I found this page with suggestions on how to do it:
www.geeksengine.com/database/manage-table/create-table-as.php

create table products_bk
as
select * from products
(naturally the table names are different than above for kunena)

This diminish my kunena_messages table with at least 50 % in size.
I guess after creating a new table I have to change name of both the old and new table.

I have looked for advice about this, but not found any, so I am grateful for input here.

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

More
2 years 2 months ago #2 by rich
You don't need to optimize the database. If you delete forum posts, it removes also the related rows in the database. But you must delete the messages permanently.

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

More
2 years 2 months ago #3 by wolfsauge
Why have a gotten a dozen notifications? This is not even my post!

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

More
2 years 2 months ago #4 by rich
I'm sorry, it was a error at the mail delivery for subscribers. Therefore you also got the mails.

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

More
2 years 2 months ago #5 by Slacker
I tried to optimize the kunena_messages table and it shrinked from 120 MB to 50 MB, but it did not work because when I posted I got: Kunena Internal Error: Please contact site administrator to fix this issue! so I had to revert to the original table. Don't try that.

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

More
2 years 1 month ago #6 by Slacker
I have digged deeper in this. kunena_messages table have an index with 12 keys and when I created the table it lacked index and thus got smaller but unfunctional. So it is no idea to create table because you have to create index, which will take a lot of space and you will gain almost nothing. kunena_messages_text dont have a big index, so it does not shrink in size.

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.161 seconds