Joomla makes a lot of request on the database

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
AntoB
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Nov 20, 2017 2:18 pm

Joomla makes a lot of request on the database

Post by AntoB » Mon Nov 20, 2017 2:21 pm

Hello everyone,

I have a lot of loads this weekend on my site and it looks like Joomla does not seem to hold up or there is a problem that I can not solve. My site is extremely slow due to joomla which makes a lot of calls on the database. Example: DELETE FROM `j25_session` WHERE` time` <'1511167067'

Is this a problem of Joomla 3.8.2? Is there a way to fix that? The problem only happens during busy times.
Top
itoctopus
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4025
Joined: Mon Nov 25, 2013 4:35 pm
Location: Montreal, Canada
Contact:
Contact itoctopus

Re: Joomla makes a lot of request on the database

Post by itoctopus » Tue Nov 21, 2017 12:15 pm

This particular query that you mentioned has been there for ages. Nevertheless, it is possible (depending on the version of Joomla that you were using) that Joomla now is issuing more queries.

A possible solution to the problem is to optimize the database for InnoDB (this should be done in /etc/my.cnf ) and make sure that your all tables, and the database itself, use InnoDB. If that fails, you should start optimizing the queries themselves, starting with the non-core queries.
http://www.itoctopus.com - Joomla consulting at its finest
https://twitter.com/itoctopus - Follow us on Twitter
Top
Locked

Return to “Performance - Joomla! 3.x”