The Joomla! Forum ™

For the past week, I have been researching why my Joomla 1.7 is very slow. I have avery fast Joomla 1.6 (yes, both with godaddy).
Is it easy to down grade to J1.6? Or are they any real solution for that?

I treid almosty all solutions execept the SQL stuff:
((query_cache_size=8M
tmp_table_size=62M
max_heap_table_size=32M
thread_cache_size=4
table_cache=72))
that was posted in "Joomla 1.6 VERY SLOW!!!"

(also my site is very slow at the backend as well)

Thanks,
Tony Dandalairo

Slow site normally equals slow host. You may want to check how many sites live on the same ip as your slow site.

Are both your sites on the same ip? Is one on an under provisioned server and the other on a heaving server?

You have to research it.

Good luck

_________________
It is in progress
http://www.poweredbyjoomla.net

Yes, I have both of them hosted on the same plan/server. The 2 are subdomains of the main one. Also, I have other PHP sites that runs fine on diff subdirectories. I have another HostGater account, I might want to try installing J1.7 there and see what is wrong. I also have J1.5 on the same server, runs very well. If this does not work, I will delete J1.7 and install J1.6.

Any help is appreciated.

Thx

Try upgrading to 1.72 which at least will get that out of the way.

_________________
It is in progress
http://www.poweredbyjoomla.net

I did last night. But it did not help. I'm spending few hours a day trying to troubleshoot this.

I'm using paid extensions such as: Ajax scroller and Ultimate News Feed.!!!

Having same issues. Upgraded site from Joomla 1.0 to 1.5 and to 1.7 and now with optimized and cleaned DB 1.7 works slower than 1.0 on same server! Even loading offline message takes forever. Done all tweaking of server. Tried with MyISAM and InnoDB, mysqli and mysql.

I have a lot of slow MySQL queries which does not occur on 1.0 or even 1.5. Something is broken with queries I guess. No extensions installed on 1.7 while 1.0 is full of everything and has much larger DB (4x larger DB than one used for 1.7).

And it is not slow host!

@tdandalairo: I feel your pain. Here is my conf
max_allowed_packet = 1M
key_buffer = 256M
sort_buffer_size = 32M
join_buffer = 512M
myisam_sort_buffer_size = 64M
read_buffer_size = 16M
read_rnd_buffer_size = 4M
table_cache = 512M
thread_cache_size = 16M
query_cache_size= 256M
query_cache_limit = 4MB
thread_concurrency = 8
max_heap_table_size = 512M
wait_timeout = 60
connect_timeout = 10
query_cache_type = 1
max_connections = 500
innodb_additional_mem_pool_size = 20M
innodb_thread_concurrency = 4
innodb_flush_method=O_DIRECT
innodb_buffer_pool_size = 3G
tmp_table_size = 3G

.
@_X_
What version of MySQL are you using?
Some of the parameters may be different now.
For example table_cache is now table_open_cache in 5.1.3+.
key_buffer vs. key_buffer_size

table_cache = 512M ? ? ?
Table cache is a number of tables.
You really want 512,000 tables cached?

thread_cache_size = 16M ? ? ?
Thread cache size is a number of threads.
You really want to have 16,000 threads cached?

max_connections = 500 ? ? ?
Some of the other settings are per-connection.
So if individual per-connection settings have been increased too much,
allocating too many connections can cause the server to run out of memory.
Generally with proper settings for thread cache and wait timeout a big number here is not needed.
This is usually the setting which is increased excessively by those new to MySQL tuning.
And it usually does more harm than good.

tmp_table_size = 3G ? ? ?
Really?

Some odd stuff there.
Simply increasing everything is not the way to do MySQL tuning.
Some excessive settings can actually cause things to slow down.
.

_________________
██ AllMedia4Joomla Project
██ http://sourceforge.net/projects/allmedia4joomla/
██ AllMedia YouTube Feed Gallery module released
██ Download: http://sourceforge.net/projects/allmedia4joomla/files/

Yes, agreed. However if 1.7 is slower than 1.5 then the difference would be more noticeable on some severs.

I have a 1.5 and 1.7 site on the same sever and have observed that sometimes the 1.7 site is very slow. I have not done any exact measurements and this is purely based on observation but 1.7 does appear to be 'heavier'.

On dedicated servers the difference may not be noticeable but on the shared server I use it s very noticeable on occasions. Yes I know in a perfect world we would all have fast servers. But in the real world many of us can only afford shared Hosting.

But that's the nature of software and programs, they get bigger and slower as they grow.

_________________
http://weblinksonline.co.uk/joomla-faq.html

Those values are insane values after a week of tuning MySQL and joomla 1.7.

On default values it works just the same as with those. It all started with small increment here and there and after few days and lot of experimenting that is the last conf.

Server is dual core with 9gb ram and lot of storage. Joomla 1.7 with no additional extensions out of the box works slower than 4 years old joomla 1.0 with all kind of junk in it. On same server and same settings. I know that joomla 1.5 is little bit slower than 1.0 and I expected that 1.7 would be slower than that, but this is ridiculous.

So please don't pay too much attention at my conf because I know it is insane and it was posted as illustration of setup that still cannot run joomla 1.7 smoothly. Even with no additional config server runs out of memory very fast. Too many slow queries.

Just remembered that on the 1.7 site I forgot to enable Gzip in Global config. Have enabled it now and will monitor it for a while to see if there is a difference.

Another site on a shared Hosting Package on 1&1 without Gzip enabled appears fast all the time. The site was installed without Sample Data. Would be interesting to see if the slower sites had Sample data.

Also installing with Sample data then deleting it could cause a miss match of some sort perhaps

_________________
http://weblinksonline.co.uk/joomla-faq.html

I guess I did not clearly make any point (my fault).
There are some settings there which are clearly not optimal.
And there are some settings there which may do more harm then good.
With the server set-up described above you should not run "out of memory very fast."
Now knowing more server config info there are a number of things I would change right away.
But most of the MySQL tuning requires looking at the status variables, not the configuration.

What version of MySQL?
32 bit or 64 bit?

Joomla 1.7 does utilize more advanced MySQL features and may require better tuning.
Some portion of the performance issues may be managed with better database tuning.
And it may have a big effect on performance.
But there is a limit on what can be tuned away.
There may also be structural issues with Joomla itself (like in Joomla 1.5) which cannot be tuned away.
To find that out requires tuning first and then looking at the slow queries again.

If you would like some help with that, let me know.
.

_________________
██ AllMedia4Joomla Project
██ http://sourceforge.net/projects/allmedia4joomla/
██ AllMedia YouTube Feed Gallery module released
██ Download: http://sourceforge.net/projects/allmedia4joomla/files/

Can we keep this thread going?

It would be useful to pinpoint the bottlenecks for 1.7.

_________________
It is in progress
http://www.poweredbyjoomla.net

Because I use shared Hosting and the load on the server can vary it is difficult to be certain but it appears enabling Gzip in Global config makes a large difference. Another difficulty is how much third party extensions effect the issue.

Is there a site that has a free tool for checking the speed of individual pages ? I have Googled but can find nothing that suits the detail I'm looking for.

_________________
http://weblinksonline.co.uk/joomla-faq.html

Definitely interested in finding what is the reason for joomla 1.7 being such a memory hog.

Server is dual-core Xeon at 2 GHz with 5GB RAM and HDDs as storage. All "optimizations" removed.

1) There is one joomla 1.0 (1.0.15) with MyISAM DB that consists of 4,984,916 records (6,665 content in 37 categories and 8 sections) (708MB as dump). It works smoothly. Not publicly accessible.

2) There is one joomla 1.7 (1.7.2) with InnoDB DB and 30,952 records, (6635 content and 51 categories) (31MB as dump). Just login into backend admin takes more than 3mins. Site in off-line mode.

- MySQL is 5.0.51a

If you need any other info just ask

I would publish MySQL variables but there is no need to publish all of them since the list is long.

I think that yslow etc will only pick up on the front end components and not query times?

_________________
It is in progress
http://www.poweredbyjoomla.net

_________________
It is in progress
http://www.poweredbyjoomla.net

That is an old article, but, I tried all those tweaks and still no fix for slow Joomla 1.7.

here are queries that are dominant in slow-query-log


# Query_time: 402 Lock_time: 0 Rows_sent: 0 Rows_examined: 12
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END $
FROM j17_content AS a
LEFT JOIN j17_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN j17_categories AS c ON c.id = a.catid
LEFT JOIN j17_users AS ua ON ua.id = a.created_by
LEFT JOIN j17_users AS uam ON uam.id = a.modified_by
LEFT JOIN j17_contact_details AS contact on contact.user_id = a.created_by
LEFT JOIN j17_categories as parent ON parent.id = c.parent_id
LEFT JOIN j17_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM j17_categories AS cat JOIN j17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROU$
WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-10-22 14:06:11') AND (a.publish_down = '0000-00-00 00:00$
GROUP BY a.id
ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 0, 10;




# Query_time: 74 Lock_time: 0 Rows_sent: 0 Rows_examined: 12
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM j17_categories as c
LEFT JOIN (SELECT cat.id as id FROM j17_categories AS cat JOIN j17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY $
LEFT JOIN `j17_content` AS i ON i.`catid` = c.id AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND badcats.id is null
GROUP BY c.id
ORDER BY c.lft;

From that pageNot very good for Shared Hosting.

Also it is not a tool with desired output shown.

https://developers.google.com/pagespeed/ comes close to what I need
It tells me that for 'Leverage browser caching' the images 'expiry not specified'. Not sure what it means though.
Found http://www.quickonlinetips.com/archives ... ite-speed/ looks like it's an Apache module that does it. So that would depend on the server ?


It tells me that for 'Enable compression' 'Compressing resources with gzip or deflate can reduce the number of bytes sent over the network'. Then gives me a list of javascripts that and how much would be gained by compressing them. But gzip is on in Global config, perhaps that does not effect the files of 3rd party extensions.

_________________
http://weblinksonline.co.uk/joomla-faq.html

402 seconds!

_________________
It is in progress
http://www.poweredbyjoomla.net

how about knocking up an amazon instance with just mysql on it for testing?

_________________
It is in progress
http://www.poweredbyjoomla.net

Something else I have in mind would be why not allow the framework to use another DB without it being relational?

I think one of the top Joomla devs was looking into maybe mongo db. Do we really need mysql's relational abilities when php is performing all the reads and writes?

I am not a coder but I can see the speed and performance boosts that this setup would provide.

Do correct me if I am talking out of my arse.

_________________
It is in progress
http://www.poweredbyjoomla.net

Just installed a fresh 1.7.2 on my local wamp to test.

I am however running an ssd which would definitely effect times.

I will give it some grief.

_________________
It is in progress
http://www.poweredbyjoomla.net

LOL ... i did the same and had few BSOD because of MySQL going berserk with mem.

That query is the most basic one for Home that collects all featured articles from all categories, if I recall correctly.

in that slow 402 sec query there is something strange:
ELSE 0 END = 1 AND

# Query_time: 402 Lock_time: 0 Rows_sent: 0 Rows_examined: 12
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END $
FROM j17_content AS a
LEFT JOIN j17_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN j17_categories AS c ON c.id = a.catid
LEFT JOIN j17_users AS ua ON ua.id = a.created_by
LEFT JOIN j17_users AS uam ON uam.id = a.modified_by
LEFT JOIN j17_contact_details AS contact on contact.user_id = a.created_by
LEFT JOIN j17_categories as parent ON parent.id = c.parent_id
LEFT JOIN j17_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM j17_categories AS cat JOIN j17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROU$
WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-10-22 14:06:11') AND (a.publish_down = '0000-00-00 00:00$
GROUP BY a.id
ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 0, 10

if someone can explain where did that come from it would be nice.

My slow-log is full of those

SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as
FROM j17_content AS a
LEFT JOIN j17_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN j17_categories AS c ON c.id = a.catid
LEFT JOIN j17_users AS ua ON ua.id = a.created_by
LEFT JOIN j17_users AS uam ON uam.id = a.modified_by
LEFT JOIN j17_contact_details AS contact on contact.user_id = a.created_by
LEFT JOIN j17_categories as parent ON parent.id = c.parent_id
LEFT JOIN j17_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM j17_categories AS cat JOIN j17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-10-22 14:12:22') AND (a.publish_down = '0000-00-00 00:00:0 GROUP BY a.id
ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 0, 10;

where is this query generated?

Here:
line 132 > \components\com_content\models\article.php
line 234 > \components\com_content\models\articles.php

but only
line 236 > \components\com_content\models\articles.php has ELSE 0 END

Try
/com_content/models/article.php
Line Number: 87 CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state
and
/com_content/models/articles.php
Line Number: 219 $query->select('c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published');

Line Number: 236 $publishedWhere = 'CASE WHEN badcats.id is null THEN a.state ELSE 0 END';

_________________
http://weblinksonline.co.uk/joomla-faq.html

Another possible location
\libraries\joomla\application\categories.php
line 234-236

/components/com_contact/models/featured.php
Line Number: 127 $query->select('c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published');

Line Number: 135 $publishedWhere = 'CASE WHEN badcats.id is null THEN a.published ELSE 0 END';

_________________
http://weblinksonline.co.uk/joomla-faq.html