Apache Compression, MySQL Caching

[keylope]

I've been reading some articles on how to speed up a Drupal site and was curious about what options are available specifically for my site.

1. Is it possible to enable Apache file compression?

2. Is it possible to enable MySQL query caching?

I know there was an issue trying to add php accelerators due to the mode that PHP is run, so I won't re-ask that question.

Thanks for the help!

[AndrewT]

1. We used to offer mod_gzip but found that it really just tends create problems. Content can't be downloaded in chunks, it messes up some CSS, etc. Just some all around less than ideal behavior. So in short, no, this is not available.

2. This is already enabled on all servers along with other MySQL performance tweaks. We tweak each server's MySQL configuration regularly to suit the needs of the server and the way that it is being used.

If you really want to speed up something, get rid of the PHP/SQL. Use a script to generate static HTML pages as needed. Granted, this is easier said than done in most cases.

[keylope]

Hey Andrew,

Thanks for the response. Drupal has caching built into it to help with response and speed, but I was just curious about server configurations as well.

Is it possible to know the approximate size the MySQL query cache is?

Thanks for your help!

[AndrewT]

We adjust the query cache size all the time based on how much it is being used, if it is getting filled, etc. so it can vary quite a bit. It also depends on the particular server as they are all tweaked differently. Knowing the size really doesn't help you much either.

[Buddha]

I'm currently generating gzip content from my static file and using this to push it:

<FilesMatch "\.(js|css|html)$">
RewriteEngine on
RewriteCond %{HTTP:Accept-Encoding} gzip
RewriteCond %{REQUEST_FILENAME}.gz -f
RewriteRule ^(.*)$ $1.gz [QSA,L]
</FilesMatch>

No major problems yet.