By special request here is a post about the MySQL slow query log. MySQL has a wonderful feature that lets you keep track of all queries that took longer than a certain time to complete. To enable it simply add the following line to your my.cnf file:
log-slow-queries = [path to the log file]
Secondly it is [...]
Entries from August 2008
Enabling and using the slow query log in MySQL
August 26th, 2008 · 2 Comments
Tags: MySQL · Performance
Tomcat failure after Apache rebuild in CPanel
August 25th, 2008 · No Comments
After rebuilding Apache in CPanel using easyapache or WHM there are many things that can go wrong even if you use a stable branch of CPanel. For example Tomcat that was installed from CPanel can fail after the build and even if this might look unrelated to the apache build this can happen quite frequently.
Tags: cpanel
speedcabling – System Admin Olympics
August 7th, 2008 · 1 Comment
Funny. First appeared as “Nerdlympics, Summer 2008″ in IT world.
Speedcabling is a physical competition of sorts … Computer scientist and artist Steven Schkolne launched the first speedcabling contest earlier this year, and you can watch the thrilling final here
Tags: sysadmin
Drupal filebrowser configuration issue
August 5th, 2008 · No Comments
We have experienced a strange issue with our Drupal filebrowser module installation. We’re getting repeated error messages about open_basedir restriction in effect.
# warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/file-folder.png) is not within the allowed path(s): (/home/username:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/username/public_html/modules/filebrowser/filebrowser.module on line 338.
# warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/file-default.png) is not within the allowed [...]
Tags: Installation
