Tuning MySQL
Update - New Innodb tuning section added below. See also Common MySQL Queries.
How to Guides
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.
Apache Solr 3 on Drupal 7 Turtorial with screen shots
This page will cover how to Install and configure all the Drupal 7 modules to an existing Solr 3
Subject
Drupal 7 is slow, speed it up by turning off a few things
Slow>turn off some modules
I have also the experience that D7 is slower than D6, but after some tweaking I think the difference is minimal
Subject
Apache Log File Tools
AWStats Logfile Analyzer
I wanted to report on basic activity on my web server so I found and installed AWstats, which I really like.
Importing Apache logs into SQL
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.
Subject
Install Drupal 7 with Drush and composer
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/
Subject
Nagios Monitoring
Nagios, the most popular open source solution for system and network monitoring, is extremely robust, but it's also intensely complex.
Subject
How to optimize mysql tables in Drupal
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.
Video editing software for Linux
kdenlive is pretty good free and opensource.
http://www.kdenlive.com/