niyunjiu
- 浏览: 836711 次
- 性别:
- 来自: 北京
-
最新评论
-
zjhzwx1212：
为什么用threadLocal后，输出值是从20开始的,而定义 ...
j2ee的线程安全--threadlocal -
aeoluspu：
不错 mysql 测试部分感觉不详细
用sysbench(或者super-smack）测试mysql性能 -
nanPrivate：
有没有例子，只理论，实践起来还是不会啊
JMS可靠消息传送 -
lwclover：
一个网络工程师 装什么b
postfix 如何删除队列中的邮件 -
maimode：
我也欠缺不少啊
理想的计算机科学知识体系
文章列表
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/opt/app/mysql-5.0.75 --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-thread-safe-client --disable-shared --enable-local-infile ...
specific Query Performance Tips (see also database design tips for tips on indexes):
Use EXPLAIN to profile the query execution plan
Use Slow Query Log
(always have it on!)
Don't use DISTINCT when you have or could use GROUP BY
Insert performance
Batch INSERT and REPLACE
Use LOAD DAT ...
- 2009-01-19 19:01
- 浏览 1413
- 评论(0)
一。安装php5.2.9
./configure --prefix=/opt/app/php-cgi --enable-fastcgi --enable-discard-path --enable-force-cgi-redirect --enable-sockets --disable-debug --with-gd --enable-gd-native-ttf --with-mysql --with-config-file-path=/etc/php-cgi
注意修改/etc/php-cgi/php.ini
cgi.fix_pathinfo = 1
make
s ...
smartctl -t long /dev/hda, to find out if there is physical damage to the hdd
- 2009-01-16 10:46
- 浏览 874
- 评论(0)
mbmon/xmbmon
lm-sensors
superkaramba
smartmontools
hddtemp
coretemp模块
ipmi
/usr/bin/ipmitool sensor list | grep 'Ambient Temp'
- 2009-01-16 10:22
- 浏览 1212
- 评论(0)
stresslinux
super pi
prime
mprime
nbench
cpuburn
gamut
mersenne prime
stress
cpu burn-in
memtester
memtest86
memtest86++
System Stability Tester
BONNIE＋＋/HPL_TEST(不是专门的压力测试软件）
http://www.ocforums.com/showthread.php?t=486495
- 2009-01-16 10:15
- 浏览 7311
- 评论(0)
unixbench5.1.2
HP DL380 G5 4G内存 raid1 RHEL4.4
结果如下：
========================================================================
BYTE UNIX Benchmarks (Version 5.1.2)
System: http: GNU/Linux
OS: GNU/Linux -- 2.6.9-42.ELsmp -- #1 SMP Wed Jul 12 23:27:17 EDT 2006
Machine: i686 (i386)
Languag ...
- 2009-01-15 14:12
- 浏览 1978
- 评论(0)
dmidecode
decode-dimms/i2c-tools
smartmontools
screentest
lspci
lshw
ethtool -i eth0
cfg2html
http://linuxshellaccount.blogspot.com/2008/08/displaying-system-information-on-linux.html
procinfo
http://spew.berlios.de/
- 2009-01-15 13:31
- 浏览 1469
- 评论(0)
Sysbench是一款流行的开源基准测试工具，用来测试不同操作系统平台即其上数据库的性能。由于我们目前讨论的是MySQL，我将重点讲解数据库测试部分。
Sysbench基准测试在测试OLTP时，先生成一张表，然后再运行一组查询命令。默 ...
system:
lmbench
unixbench5.1.2
ubench
freebench
nbench
ltp
xfbsuite
http://www.hermit.org/Linux/Benchmarking/
High Performance Linpack
geekbench
IO:
dd
orion
iozone
bonnie++
bonnie64
fio
iometer
dbench
piozone
tiozone
CPU:
nbench
network:
netper ...
mod_php:
./configure --prefix=/opt/app/php --with-apxs2=/opt/app/apache-bbs/bin/apxs --enable-sockets --disable-debug --with-gd --without-iconv --enable-mbstring --enable-gd-native-ttf --with-mysql --with-config-file-path=/etc
cgi:
./configure --prefix=/opt/app/php-cgi --enable-fastcgi --enab ...
ulimit
--------------
data seg size (kbytes, -d) unlimited
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 206129
stack size (kbytes, -s) 2048 #This ALSO affects -Xss !!!
max user processes ...
- 2009-01-13 18:33
- 浏览 1281
- 评论(0)
Simple tool to trace MySQL activity similar to MS SQL Server Profiler.
The program can also be used as a generic log monitor tool.
The LogMonitor application leverages the MySQL logging mechanism.
It monitors the general query log file produced by the MySQL server on
a schedule and displays the l ...
- 2009-01-13 11:27
- 浏览 1628
- 评论(0)
http://www.ibm.com/developerworks/cn/java/j-lo-p6spy/index.html
简介
P6Spy是一个可以用来在应用程序中拦截和修改数据操作语句的开源框架。
通过P6Spy我们可以对SQL
语句进行拦截，相当于一个SQL
语句的记录器，这样我们可以用它来作相关的分 ...
- 2009-01-13 10:56
- 浏览 1999
- 评论(0)