Optimization

The following query lists tables with free space greater than equal to 50MB to optimize mysql> select table_name, table_schema, round(data_length/1024/1024) as data_length_mb, round(data_free/1024/1024) as data_free_mb from information_schema.tables where round(data_free/1024/1024) > 50 order by data_free_mb;
Example response: +---------------------------------+-----------------+----------------+--------------+
| TABLE_NAME | TABLE_SCHEMA | data_length_mb | data_free_mb |

Memcached is a free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load Memcached is used in Drupal mostly for caching Database queries in memory to improve authenticated user experience and reduce load on database. Primarily cache tables are swapped to have a memcached backend. We can find a lot of tutorials to install Memcached on debian system including memcache PHP extension.

Improving Site Performance: 1. Disable all caching in the site and do benchmark for anon user 2. Benchmark for auth user for a particular page 3. Check logs to see if any notice or error is happening in the site. Solve the issue and notice BM 4. Disable unwanted modules if any and do another benchmark. Note the diff. 5. Modify or update apache or mysql setting minor if any to see noticiable change in benchmark 6. Optimize PHP and see if noticeable difference occurs 7. Install Devel and check queries and page rendering times