Top 84 MySQL Performance Tips
You can check the same tips from here.Here is very useful tips for all mysql DBA’s,
Developers these tips are noted from MySQL Camp 2006 suggested by mysql community experts.
centos start up some service
chkconfig –level 234 httpd on
install package in Solaris 10
# pkgadd -d . SFWgcc2l
bash for Solaris 10
-bash-3.00$ cat .profile
export TERM=”vt100″
export EDITOR=”vi”
export PATH=”/usr/local/bin:/opt/sfw/bin:/usr/ucb:/bin:/sbin:/usr/bin:/usr/sbin:$PATH”
export LC_CTYPE=”en_US.ISO_8859-1″
alias h=”history 300″
umask 022
CSHRC for Solaris
[code language=’sh’]
umask 022
set path=(/usr/ucb /usr/local/bin /usr/ccs/bin /usr/X/bin /usr/sbin /bin /usr/bin /etc)
#set prompt=”`whoami`@`hostname`:`pwd`% ”
if ( $?prompt ) then
set history=32
endif
#set prompt=”`whoami`@`hostname -s`:`pwd`%”
#alias cd ‘ chdir \!*; set prompt=”`whoami`@`hostname`:`pwd`%”‘
unset autologout
alias cd ‘chdir \!*; set prompt=”\n`whoami`@`hostname`:`pwd`% \n[%h] “‘
set prompt=”\n`whoami`@`hostname`:`pwd`% \n[%h] ”
alias pu ‘ pushd \!*; set prompt=”\n`whoami`@`hostname`:`pwd`% \n[%h] “‘
alias po ‘ popd; set prompt=”\n`whoami`@`hostname`:`pwd`% \n[%h] “‘
alias cp ‘cp -i’
alias mv ‘mv -i’
alias rm ‘rm -i’
alias del ‘rm -i’
alias m more
set path = ($path ./)
alias h ‘history 25’
alias j ‘jobs -l’
alias la ‘ls -a’
alias lf ‘ls -FA’
alias ll ‘ls -lA’
setenv LD_LIBRARY_PATH /usr/local/lib/mysql
alias joe ‘joe -asis -nobackups -noxon’
[/code]
How to restart sshd service in solaris 10
/lib/svc/method/sshd restart
正解:
svcadm restart ssh