超烦!!! 事多 且不顺 这学期买了个机柜把服务器都放了进去,可不知怎么了单位的三层交换好像总是有问题,几个VLAN之间的数据传输超慢,时断时续,看来得查查了
我的小宝这两天在发高烧 ,心痛ing 
有老数据一个，数据还是mysql 3.x时的，哪时数据库还没有什么字符，都是latin1
程序也老，现在错误日志满天飞，一直也没有整理过，头大
近来这阵比较空想写个小程序接管一下，人老了正好动动脑可以防老，嘿嘿
选取老数据库数据
$_sql = "select * from olddata.tables";
$db->Execute($_sql);
$_author = mb_convert_encoding($ors->fields['writer'],"utf-8","gb2312");
$_titler = mb_convert_encoding($ors->fields['title'],"utf-8","gb2312");
$db->query("set names utf8");
$_nsql = "INSERT INTO newdata.table(author,title) values('".$_author."','".$_title."')";
$db->Execute($_nsql);
mb_convert_encoding 要使用到 mbstring 库支持
嘿嘿... 不知这样效率如何
本想从数据库中用 mysqldump导入老数据再用 iconv来转换字符编码,不过总是有点小错误.
再一个,我想选择出想要的数据,去除不必要的字段,还有这样方便一点.
小记 备忘
cnc-a# cat nginx.conf
user nobody nogroup;
worker_processes 5;
#error_log logs/error.log notice;
error_log off;
#pid logs/nginx.pid;
events {
worker_connections 8192;
use kqueue; # for freebsd
}
http {
include mime.types;
include fastcgi_params;
default_type application/octet-stream;
sendfile on;
#tcp_nopush on;
keepalive_timeout 120;
access_log /dev/null;
gzip on;
gzip_comp_level 4;
gzip_min_length 1100;
gzip_buffers 4 8k;
gzip_http_version 1.0;
gzip_proxied any;
gzip_types text/plain text/xml text/javascript application/x-javascript text/css text/html application/xml;
## Default
include vhost-config/default.conf;
}
cnc-a# cat fastcgi_params
fastcgi_param QUERY_STRING $query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param SCRIPT_NAME $fastcgi_script_name;
fastcgi_param REQUEST_URI $request_uri;
fastcgi_param DOCUMENT_URI $document_uri;
fastcgi_param DOCUMENT_ROOT $document_root;
fastcgi_param SERVER_PROTOCOL $server_protocol;
fastcgi_param GATEWAY_INTERFACE CGI/1.1;
fastcgi_param SERVER_SOFTWARE nginx/$nginx_version;
fastcgi_param REMOTE_ADDR $remote_addr;
fastcgi_param REMOTE_PORT $remote_port;
fastcgi_param SERVER_ADDR $server_addr;
fastcgi_param SERVER_PORT $server_port;
fastcgi_param SERVER_NAME $server_name;
# PHP only, required if PHP was built with --enable-force-cgi-redirect
fastcgi_param REDIRECT_STATUS 200;
安装 /usr/ports/ports-mgmt/portconf/
会在/usr/local/etc/下创建 ports.conf 文件
在文件内写上make 参数,如 mysql
cat /usr/local/etc/ports.conf
databases/mysql*-server: BUILD_OPTIMIZED=yes|WITH_XCHARSET=all|BUILD_STATIC=yes
安装 portinstall databases/mysql50-server
ports的安装方法
cd /usr/ports/databases/mysql50-server/
make install clean && rehash
具体编译参数在ports.conf 里定义好就可以了,之后使用portupgrade更新起来,也不会出错了 
# top # display and update the top cpu processes
# mpstat 1 # display processors related statistics
# vmstat 2 # display virtual memory statistics
# iostat 2 # display I/O statistics (2 s intervals)
# systat -vmstat 1 # BSD summary of system statistics (1 s intervals)
# systat -tcp 1 # BSD tcp connections (try also -ip)
# systat -netstat 1 # BSD active network connections
# systat -ifstat 1 # BSD network traffic through active interfaces
# systat -iostat 1 # BSD CPU and and disk throughput
# tail -n 500 /var/log/messages # Last 500 kernel/syslog messages
# tail /var/log/warn # System warnings messages see syslog.conf
