Categories
Programming/php

php , date_default_timezone_set

Sets the default timezone used by all date/time functions in a script

date_default_timezone_set( “Asia/Taipei” );

Categories
DATABASE

useful mysql command

show status like ‘Qcache%’;

explain select …..

分析 schema 

echo “select * from tbl_item procedure analyse()\G” | mysql db_name > ana.txt

Categories
DATABASE Programming/php System/Linux/Unix*

mysql turning off query cache

set GLOBAL query_cache_size=0

Categories
System/Linux/Unix*

File System Benchmarks for Postfix Mail Server

Categories
DATABASE System/Linux/Unix*

Protected: 在CentOS 4.5上安裝Oracle 10g

This content is password protected. To view it please enter your password below:

Categories
Copy_N_Paste System/Linux/Unix*

Protected: [轉貼] CentOS 5.1-初始環境設定

This content is password protected. To view it please enter your password below:

Categories
JOB

Protected: centos routing

This content is password protected. To view it please enter your password below:

Categories
DATABASE Programming/misc System/Linux/Unix*

adject file descriptors

On Unix, each TCP/IP connection uses a file descriptor, so you must increase the total number of descriptors available to the operating system, and also increase the maximum number of descriptors each process is allowed to use. All Unix style operating systems have a “ulimit” shell command (sh and bash) which can allow more open file descriptors to commands started in that shell, once the appropriate kernel tweak has been made. We recommend “ulimit -n 8192”. Here are our recommended kernel tweaks:

Linux: “echo 65536 > /proc/sys/fs/file-max” changes the number of system-wide file descriptors

FreeBSD: append to /etc/sysctl (or you can use sysctl -w to add these)

kern.maxfiles=65536
kern.maxfilesperproc=32768

Solaris: add the following to /etc/system and reboot:

set rlim_fd_max=0x8000
set rlim_fd_cur=0x8000

Categories
DATABASE

Top10SQLPerformanceTips

Categories
DATABASE

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.