Keyword

Overload on k2 comments table in SQL file

  • RicardoAbdala
  • RicardoAbdala's Avatar Topic Author
  • Offline
  • New Member
More
10 years 6 months ago #118441 by RicardoAbdala
Overload on k2 comments table in SQL file was created by RicardoAbdala
The database was disabled by the hosting. They said the k2 component was the cause of the problem and suggest me to optimize the database tables. Really, when I opened the SQL file I saw that K2_comments table was with 600 Mb. After optimization it dropped to 7 Mb. There was about 700.000 records (fake comments). How can I prevent that never happen it again?

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

  • RicardoAbdala
  • RicardoAbdala's Avatar Topic Author
  • Offline
  • New Member
More
10 years 6 months ago #118442 by RicardoAbdala
Replied by RicardoAbdala on topic Re: Overload on k2 comments table in SQL file
Perdão pessoal, não vi que cairia na comunidade Brasil. Traduzindo rapidamente o problema:
A LocaWeb derrubou o SQL do site alegando que o componente K2 estava sobrecarregando o servidor de bando de dados. Ela estava certa. A tabela k2_comments estava com 700 mil registros, cerca de 600 Mb. O problema é que não há nenhum item/categoria no site com Comments ativo. Alguma falha de segurança permitiu um loop de posts nesta tabela. Alguém já passou por isso?

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

  • RicardoAbdala
  • RicardoAbdala's Avatar Topic Author
  • Offline
  • New Member
More
10 years 6 months ago #118443 by RicardoAbdala
Replied by RicardoAbdala on topic Re: Overload on k2 comments table in SQL file
Então, mais estranho ainda é esse tipo de recomendação.

wiki.locaweb.com.br/pt-br/K2_Joomla

Alguém tem alguma recomendação? Isso já foi discutido neste grupo? Estou chegando atrasado?

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


Powered by Kunena Forum