月度存档: 十二月 2009

10年

作者: 日期: 2009年12月31日 没有评论

不知道写什么,是回忆?还是幻想未来?
从现在开始做些改变.争取来年更加有趣!
飞说: 人生,不是你刺激别人,就是别人刺激你~
充满刺激的过去和未来,我来了!

MySQL Performance Tuning Primer Script

作者: 日期: 2009年12月21日 没有评论

http://www.eukhost.com/forums/f42/mysql-performance-tuning-primer-script-7204/

uning the performance of MySQL can be a really hard job to do.
There are many thinks to consider and no two servers are identical so there is no universal solution.
Tuning Primer is a script that will help you tune your mysql installation by providing very healthy recommendations based on past mysql records.
For the script to be efficient you must run the mysql server for at least 48 hours.

Installation is extremely simple:

1. Download The Script

wget http://day32.com/MySQL/tuning-primer.sh

2. Change the permissions for the file

chmod 755 tuning-primer.sh

3. Run It
./tuning-primer.sh

# Apply the sugesttions

How to configure Sundry MySQL Scripts and Docs

Found This Script Works Perfect!

Enjoy!
Jordan – SameerHosting Inc, http://sameerhosting.com/

切换oracle的归档目录

作者: 日期: 2009年12月6日 没有评论

下午技术支持的兄弟打来电话说某业务不正常了,发现ORA-00257的错误,
上服务器察看,发现归档日志的目录空间满了- -!!只有20G…
鉴于业务的特殊性,不想折腾oracle,遂换个目录写日志,记录下来,以免忘记:
alter system set log_archive_dest_1=’location=/data02/archive’ scope=both;
archive log list;