My Tips To You

strict warning: Non-static method view::load() should not be called statically in /home/webdevde/public_html/sites/all/modules/contrib/views/views.module on line 906.

strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home/webdevde/public_html/sites/all/modules/contrib/views/handlers/views_handler_filter.inc on line 0.

strict warning: Declaration of views_handler_filter::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /home/webdevde/public_html/sites/all/modules/contrib/views/handlers/views_handler_filter.inc on line 0.

strict warning: Declaration of views_handler_filter_boolean_operator::value_validate() should be compatible with views_handler_filter::value_validate($form, &$form_state) in /home/webdevde/public_html/sites/all/modules/contrib/views/handlers/views_handler_filter_boolean_operator.inc on line 0.

strict warning: Declaration of views_plugin_style_default::options() should be compatible with views_object::options() in /home/webdevde/public_html/sites/all/modules/contrib/views/plugins/views_plugin_style_default.inc on line 0.

strict warning: Declaration of views_plugin_row::options_validate() should be compatible with views_plugin::options_validate(&$form, &$form_state) in /home/webdevde/public_html/sites/all/modules/contrib/views/plugins/views_plugin_row.inc on line 0.

strict warning: Declaration of views_plugin_row::options_submit() should be compatible with views_plugin::options_submit(&$form, &$form_state) in /home/webdevde/public_html/sites/all/modules/contrib/views/plugins/views_plugin_row.inc on line 0.

I like MySQL and have been using each release of their GUI tools for Mac OS X and have slowly been getting used to the newer MySQL Workbench tool that replaced their previous GUI tools. I also use MAMP on some dev machines, so using both together is a must-do.

There is a way to setup MySQL Workbench with MAMP/MAMP Pro and these are the list of steps I did to get both apps to work together. There could be better ways so I'll update this post over time.

In my work MySQL plays a big part of the dynamic web data chain, especially for many PHP based sites (like Drupal). Here are tips I've collected along the way and of course YMMV (your mileage may vary).

MySQL Tuning notes

Disable or remove any extensions (or modules) not being used.

Separate the database onto its own server (Master), and try to have a (Slave) copy as a backup or for redundancy.

Master-Master configurations are not easy.

Use EXPLAIN to dig into queries and find where optimizations can be made for performance.

Profile MySQL during development using the SET PROFILING flag. Enable profiling, query information_schema table to review results. Disable profiling when done.

Enable and tune the Query cache.

Enable Table cache.

Enable (or raise) Key buffer.

Enable Slow Query Log to find bottleneck queries.

Use MyISAM table types for fast reads, but stick with InnoDB for transactional data.

Useful Commands

In my work Apache can play a big part of the web serving chain, especially for most PHP based sites (like Drupal). Here are tips I've collected along the way. Of course YMMV (your mileage may vary).

Conf settings

These settings can be placed inside various places, the best would be in the *.cnf file for your domain or site. At worst this stuff can go inside httpd.conf which is the global configuration file for Apache.

When you get comfortable with bash shell commands you may at some point be annoyed with duplicate commands coming up and forcing you to scroll through those repetitive shell commands. To have your shell ignore duplicate commands and even ignore specific commands (like ls) then follow these quick tips:

When using the command line, like Terminal for Mac OS X there are two quick ways to recall a command you entered previously. By using the Up & Down arrow keys on the keyboard allows you to scroll through your command history. When a command is much older than a minute or two ago then a auto-complete search is possible by pressing the Ctrl+R keys together and typing in any portion of a previous command. The auto-complete search is way cool; give it a try.

When administering a Linux/Unix computer, one of the most common (and important) commands is how to list the contents of a directory. On Linux/Unix, the following command will display all files in a directory, even if they are hidden.
ls -Flash

The command above has some flags set (otherwise known as parameters), which is the "-Flash" portion of the command. I prefer this set of flags, and in that order since it is easy to remember the word "Flash" versus random orders of each flash like "lhaFs". These set of flags I like show the list of files vertically with many attributes shown and colorful visual indicators.