Main menu:

Site search

Categories

Archive

Archive for February, 2008

quick script to check the status of a linux raid 3ware controller

3ware is a pretty common controller in linux boxes, there is a command utility tw_cli to check the status. You can automate the checking via a simple bash script that you can put into your cron. here is some code #!/bin/bash com=`/path_to_ tw_cli/tw_cli info c0 u0 status | awk ‘{print $4}’` echo $com if [ [...]

MySQL query_cache_size, how cache can help your website performance

here is a clipping from the MySQL manual regarding the query cache to help your website performance. mysql> SHOW VARIABLES LIKE ‘query_cache_size’; +——————+——-+ | Variable_name | Value | +——————+——-+ | query_cache_size | 41984 | +——————+——-+ For the query cache to actually be able to hold any query results, its size must be set larger: mysql> [...]