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” = […]
Posted: February 12th, 2008 under Linux, Disaster Recovery.
Comments: none
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 […]
Posted: February 5th, 2008 under Linux, MYSQL.
Comments: none