Home » Forums » Ubercart » Support

Minify and MySQL Tuning

Submitted by gash on Mon, 04/21/2008 - 13:07
gash
Posts: 70
 Joined: 04/14/2008

Kind of a two-fold question. First, I'd like to incorporate minify in my site. I'm using the garland template, and from what I can see in page.tpl.php, it appears the $head variable is set elsewhere, and I'm guessing that's what needs modifying to incorporate minify. Any quidance on where I can find the $head variable and tweak it?

Secondly, any suggestions on an optimal MySQL config? I've 129 MB of RAM available to me, 10 GB disk space. Specifically, any rules of thumb for sizing the query cache?

Much thanks,
Gash
permalink #1 Mon, 04/21/2008 - 13:30
gash
Posts: 70
 Joined: 04/14/2008

Any other JS/CSS aggregation modules or patches that can be applied?

Are there plans to build ubercart on a Drupal 6.X install? I believe 6.x has aggregation built in by default, if I'm not mistaken.

permalink #2 Mon, 04/21/2008 - 13:47
gash
Posts: 70
 Joined: 04/14/2008

Apologies -- I completely missed the page cacheing and css aggregation settings in admin/performance. Fixed that. Don't see any settings for JS aggregation -- is it built in as well, or necessary, for that matter?

Still curious about the MySQL tuning, however. Any suggestions are appreciated.

Gash

permalink #3 Mon, 04/21/2008 - 14:00
Ryan

Posts: 5245
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

JS caching wasn't introduced in D5, and I'm not sure if it finally made it into D6 or not. I won't be much help on the MySQL tuning side, though... you might just try searching Drupal.org in general or the High performance group on g.d.o.

And we are planning the update for D6 after the 1.0 release. Smiling

permalink #4 Mon, 04/21/2008 - 14:29
gash
Posts: 70
 Joined: 04/14/2008

I found a 5.x compatible JS aggregator module here that seems to be working fairly well. Between it and CSS aggregation, I've seen a fair decrease in page execution times. I think the real speed increases in page loads will come from tweaking my database config. I'll continue digging and see what I can come up with.

And that's 128 MB of RAM I have. Darned adjacent keys!

Gash

permalink #5 Mon, 04/21/2008 - 14:39
torgosPizza

Posts: 1290
 Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

There is a JS aggregation patch for D5, which I had to revert because it screwed up my ability to save Performance settings. =/

With regard to MySQL tuning, one thing I'd recommend is mysql query cache.

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com