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 [ “$com” = […]

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> SET GLOBAL query_cache_size = 1000000;
Query […]