Can't create/write to file '/var/tmp/mysql/ : Page 2

Can't create/write to file '/var/tmp/mysql/

manhta

folamour
Hi,
After further investigation, i think issue might not because of ja good template. Ja good layouts for mod_articles_category only use joomla module data, no extra db query. You can turn on the module, delete all ja good layout content and monitor this issue again. All layouts you can find at: /templates/ja_good/html/mod_articles_category

Because of your site have a mount of articles, i prefer mysql needs more memory. I made some tests and the result is:

SELECT @@key_buffer_size/1024/1024
128.00000000
SELECT @@max_allowed_packet/1024/1024
64.00000000
SELECT @@sort_buffer_size/1024/1024
8.00000000
SELECT @@read_buffer_size/1024/1024
2.00000000

Could you ask db team to increase key_buffer_size, max_allowed_packet, sort_buffer_size and read_buffer_size to 250M?

folamour

what this mean i have to delete ja good ? and ask to increase ? without ja good the site don't crash

manhta

folamour
Hi,
All queries you sent come from module mod_articles_category. This is a module of joomla core. Ja Good support some layout override for this module. To test out ja good makes your site crash or not, you can open all override layouts of module mod_articles_category, empty them and monitor template ja good again. The folder is /templates/ja_good/html/mod_articles_category.

Hope this clear.

folamour

I call them by phone to ask

folamour

ok that has to be seen by the level 2 support at hostpoint, but the engineer will be back tomorrow, so i get back in touch with you when he will be back

thanks you a lot for your support because our website is at risk and its 15 year of work,

kind regards,

folamour

i'm sorry i dont understood that :

you can open all override layouts of module mod_articles_category, empty them and monitor template ja good again. The folder is /templates/ja_good/html/mod_articles_category.

folamour

you want to said to open the file, empty them, save them, and retry ?

folamour

folamour empty the file make the module dont work

folamour

have you finished with the web site can i re activate admin tools ?

manhta

folamour
Nvm, please check my second thought, your mysql should be able to use more memory.
Regards

folamour

Does archiving 10k will fix the issue the host ask us to purchase a dedicated server to do your requested modification,

i've also open a thread on joomla.org

manhta

folamour
I think VPS with 4Gb ram would be enough. On VPS, you can custom your mysql config without asking hosting provider.

folamour

ok we have a vps under the hand, but at this time i have reactivated the template and the host said the load is correct

mahta can you tell me if you have modified something on the template and if this modification will be integrated on future release of ja good or not ?

thanks a lot, have a great afternoon

manhta

folamour
Hi,
I haven't done anything on your site except turning on joomla cache on Global Configuration > System > System Cache.
Although this might reduce the frequency of the issue, it is possible for MySQL to still crash under high load.

folamour

ok thanks manhta have a sweet evening thanks for the reply

« Previous Page