Tips for reducing repetitive stress injuries as a programmer

Workrave screenshot
Workrave screenshot

RSIs, or repetitive stress injuries, can spell doomsday for a programmer or web developer.  It’s what many of us fear the most; after all, it’s our life’s work, our passion, our love.  I think it is safe to say that pretty much every programmer has felt wrist pain at one time or another.  Many times, it goes ignored, which only worsens the problem.  There is a lot of research in this area, and as a result there are many preventative measures that can be taken to prevent RSIs. Continue reading Tips for reducing repetitive stress injuries as a programmer

Optimize PHP, Apache & MySQL for performance

Two MySQL tuner scripts

MySQLTuner (Perl) and MySQL Performance Tuning Primer (Shell) are two scripts that can help diagnose MySQL database performance issues, and provide recommendations on how to solve them.  While both scripts output similar information, the diagnosis can be slightly different with each script, so I like to use both.  Below are directions on how to use them, as well as a few screenshots.

# Download MySQLTuner and MySQL Performance Tuning Primer to ~/scripts.
# To avoid having to invoke Perl/SH each time, make both files executable.
chmod +x ~/scripts/mysqltuner.pl
chmod +x ~/scripts/tuning-primer.sh

# After that, give them a go!
~/scripts/mysqltuner.pl
~/scripts/tuning-primer.sh

Continue reading Optimize PHP, Apache & MySQL for performance

Major improvements in TPC! Memory Usage for WordPress

Over the past few weeks, I’ve been actively developing some long-awaited TPC! Memory Usage features.  The highlights of the latest release are listed below.  I believe that these will help WordPress developers and administrators improve scalability and performance of their blogs and custom applications.

  • Custom checkpoints allow administrators to measure memory usage anywhere a WordPress action is available.
  • Optional file logging allows administrators to have an effective way of tracking memory usage.
  • Improved Security Check, and listed additional variables in System Overview.
  • Fixed various bugs (special thanks to those who have taken the time to report issues).

As we continue to improve TPC! Memory Usage and implement new features, we would love to hear your thoughts.  Feel free to leave a message on the official TPC! Memory Usage page.  As always, thank you for your continued support.

Download TPC! Memory Usage