Keyword

The table '(temporary)' is full

  • Tinchosan
  • Tinchosan's Avatar Topic Author
  • Offline
  • New Member
More
6 months 3 days ago #172303 by Tinchosan
Tinchosan created the topic: The table '(temporary)' is full
Hola, tengo el siguiente problema en un diario digital: The table '(temporary)' is full y la gente del host me dijo que el problema es que k2 esta generando tablas temporales de más de 4GB, ¿cómo puedo solucionar dicho error?

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

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
6 months 3 days ago #172305 by Fotis
Fotis replied the topic: The table '(temporary)' is full
This can be normal if your database is large. It's not a K2 or Joomla specific issue.

Depending on how (or if) MySQL/MariaDB is optimized, a temporary table can balloon to hundreds of GBs on a very busy site, e.g. from aggressive crawling or just traffic.

With proper database tuning (this is a good starting point for cPanel servers gist.github.com/fevangelou/0da9941e67a9c9bb2596 and this for Ubuntu/CentOS etc. servers gist.github.com/fevangelou/fb72f36bbe333e059b66 ) and the use of InnoDB as storage engine in all Joomla tables, your site will perform better and less temporary tables will be created.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Emanuel Rodríguez
  • Emanuel Rodríguez's Avatar
  • Offline
  • Moderator
  • Robustiana.com
More
6 months 3 days ago #172306 by Emanuel Rodríguez
Emanuel Rodríguez replied the topic: The table '(temporary)' is full
Hola. De acuerdo con Fotis, esta situación puede considerarse normal si la base de datos es muy grande especialmente en sitios con mucho tráfico. ¿Cuantos artículos tienes en K2? ¿Tiene el sitio tráfico muy pesado?

Puedes contactar a tu proveedor de hosting y preguntarles si pueden implementar las optimizaciones que compartió Fotis

Robustiana.com ... Tutoriales, guías de uso y resolución de problemas en Joomla! y K2

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

  • Tinchosan
  • Tinchosan's Avatar Topic Author
  • Offline
  • New Member
More
6 months 3 days ago #172309 by Tinchosan
Tinchosan replied the topic: The table '(temporary)' is full
Primero, gracias a ambos por la ayuda, segundo, al día de hoy, disponemos de: 11435 artículos publicados. El promedio de visitas diarias esta en 4000 más o menos. ¿Si quitaramos artículos viejos, esto mejoraría?

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

  • Emanuel Rodríguez
  • Emanuel Rodríguez's Avatar
  • Offline
  • Moderator
  • Robustiana.com
More
6 months 3 days ago #172310 by Emanuel Rodríguez
Emanuel Rodríguez replied the topic: The table '(temporary)' is full
Sí, sería esperable que al reducir la carga de artículos también se reduzca la carga en la base de datos. Para un promedio de 120 mil visitas mensuales se requiere un servicio de hosting medianamente avanzado. Cuál es el tamaño máximo permitido para bases de datos en el actual?

Robustiana.com ... Tutoriales, guías de uso y resolución de problemas en Joomla! y K2

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

  • Tinchosan
  • Tinchosan's Avatar Topic Author
  • Offline
  • New Member
More
6 months 3 days ago #172311 by Tinchosan
Tinchosan replied the topic: The table '(temporary)' is full
Estamos usando este proveedor: baehost.com/es-ar/web-hosting-argentina/hosting-corporativo el de alta demanda. Disculpa si la respuesta no es la acertada, ignoro bastante el tema servidores.

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

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
6 months 1 day ago #172321 by Fotis
Fotis replied the topic: The table '(temporary)' is full
Is this a VPS server you have root access to or just shared web hosting?

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Emanuel Rodríguez
  • Emanuel Rodríguez's Avatar
  • Offline
  • Moderator
  • Robustiana.com
More
6 months 1 day ago - 6 months 1 day ago #172327 by Emanuel Rodríguez
Emanuel Rodríguez replied the topic: The table '(temporary)' is full
Tinchosan, tienes acceso raíz al servidor o es un servicio compartido? En caso contrario podrías solicitar al proveedor que implemente las optimizaciones?

Fotis, according to the website it is a shared high demand web hosting service ($600+/month option). It doesn't say it very clear but the it is not in the VPS section.

Robustiana.com ... Tutoriales, guías de uso y resolución de problemas en Joomla! y K2
Last edit: 6 months 1 day ago by Emanuel Rodríguez. Reason: Grammar

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

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
6 months 1 day ago #172328 by Fotis
Fotis replied the topic: The table '(temporary)' is full
I'm guessing that too. In any case, ~11k items is not much. Either there are very strict limitations in place (e.g. if they use CloudLinux with cPanel) or they simply have no idea how to optimize the server's database (which is bad if you pay for a premium service).

If I were you, I would look into other hosting options.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Tinchosan
  • Tinchosan's Avatar Topic Author
  • Offline
  • New Member
More
6 months 15 hours ago #172333 by Tinchosan
Tinchosan replied the topic: The table '(temporary)' is full
El servidor, es compartido, los dedicados valen el doble o más. El diario esta funcionando ahora, pero sabemos que se puede caer sin previo aviso.

El error, aún persiste en la parte administriativa, dejo una captura del mismo.
Attachments:

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


Powered by Kunena Forum