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.
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..
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.