php , date_default_timezone_set
Sets the default timezone used by all date/time functions in a script
date_default_timezone_set( “Asia/Taipei” );
Archive for 27th March 2008
useful mysql command
show status like ‘Qcache%’;
explain select …..
分析 schema
echo “select * from tbl_item procedure analyse()\G” | mysql db_name > ana.txt
mysql turning off query cache
set GLOBAL query_cache_size=0
