CODEWITHSUNDEEP
mysqljoomla
Gerri Jensen
Gerri Jensen

Reputation: 21

Joomla 2.5.14 mysql - memory issue

Can someone explain this Joomla error to me -- what to do to fix it. It shows up with debug on. We seem to have a memory leak? Mysql runs slow than site crashes.

Function    Location
JSite->dispatch()   /home/greatfam/public_html/index.php:52
JComponentHelper::renderComponent() /home/greatfam/public_html/includes/application.php:197
JComponentHelper::executeComponent()    /home/greatfam/public_html/libraries/joomla/application/component/helper.php:351
require_once()  /home/greatfam/public_html/libraries/joomla/application/component/helper.php:383
JController->execute()  /home/greatfam/public_html/components/com_content/content.php:16
ContentController->display()    /home/greatfam/public_html/libraries/joomla/application/component/controller.php:761
JController->display()  /home/greatfam/public_html/components/com_content/controller.php:74
ContentViewArticle->display()   /home/greatfam/public_html/libraries/joomla/application/component/controller.php:722
JView->get()    /home/greatfam/public_html/components/com_content/views/article/view.html.php:32
ContentModelArticle->getItem()  /home/greatfam/public_html/plugins/system/jat3/jat3/core/joomla/view.php:348
JError::raiseError()    /home/greatfam/public_html/components/com_content/models/article.php:172
JError::raise() /home/greatfam/public_html/libraries/joomla/error/error.php:251

Upvotes: 0

Views: 569

Answers (1)

Riccardo Zorn
Riccardo Zorn

Reputation: 5615

A nice and easy way to get started is: turn Joomla debug on in the Global configuration.

Then reload the frontpage, and examine closely the output at the bottom of the page.

There you will find the details of the memory used by each module, and the list of queries run. This will give you a head start and limit the number of items you need to debug (there will be a single module eating up all your memory).

If "after dispatch" is taking too long, then it could be either a plugin or the component being shown on the page.

If nothing "notable" shows up here (a lot of queries, more than 50, or high memory consumption, or long time for a single item, you might want to look at the apache error_log and mysql log and verify system limits.

Upvotes: 2

Related Questions