Tuning MySQL
Update - New Innodb tuning section added below. See also Common MySQL Queries.
Update - New Innodb tuning section added below. See also Common MySQL Queries.
I wanted to use the web to capture all the tips and tricks I learned setting up an web sites including content management system (CMS). I have also added some other useful how to guides for phones, tablets, video, and backup power.
This page will cover how to Install and configure all the Drupal 7 modules to an existing Solr 3
I have also the experience that D7 is slower than D6, but after some tweaking I think the difference is minimal
I wanted to report on basic activity on my web server so I found and installed AWstats, which I really like.
Later I wanted to see more details so I started looking for a way to convert Log file entries to database tables. I found the following on goolge and listed them in the order I think will work best on linux.
Drush is a command line shell and Unix scripting interface that automates may administration tasks for Drupal. The new drush version 4 adds commands. You can read the documentation to explain more. There is also the drush.org web site at drush.ws. Look for examples at:<drush path>/examples/
Nagios, the most popular open source solution for system and network monitoring, is extremely robust, but it's also intensely complex.
How to optimize my Drupal database?
The easiest way is to install the DB Maintenance module. Information on how to install a Drupal module is available in our Drupal tutorial.
After the module is installed and activated, you can access it from your Drupal admin area > Administer > Site configuration > DB maintenance. Select the tables which you wish to optimize and click Optimize now.
kdenlive is pretty good free and opensource.
http://www.kdenlive.com/