blakee
2008-10-20 10:00
哥们儿,您好:
您用过solidDB for mysql这个存储引擎吗?能不能介绍一下这个怎么安装。谢谢
您用过solidDB for mysql这个存储引擎吗?能不能介绍一下这个怎么安装。谢谢
张哥,关注您的博客很久了。写的文章很棒。最近我们在做BIND+dlz+mysql出现问题了,我打开了named的调试,返回的信息这样的。
[root@localhost ~]# /usr/local/bind9/sbin/named -g -d 1 -c /usr/local/bind9/etc/named.conf 18-Oct-2008 11:51:54.113 starting BIND 9.5.0-P2 -g -d 1 -c /usr/local/bind9/etc/named.conf
18-Oct-2008 11:51:54.118 loading configuration from '/usr/local/bind9/etc/named.conf'
18-Oct-2008 11:51:54.119 listening on IPv4 interface lo, 127.0.0.1#53
18-Oct-2008 11:51:54.120 binding TCP socket: address in use
18-Oct-2008 11:51:54.120 listening on IPv4 interface eth0, 203.171.227.4#53
18-Oct-2008 11:51:54.120 binding TCP socket: address in use
18-Oct-2008 11:51:54.120 Loading 'Mysql zone' using driver mysql
18-Oct-2008 11:51:54.135 default max-cache-size (33554432) applies
18-Oct-2008 11:51:54.138 default max-cache-size (33554432) applies: view _bind
18-Oct-2008 11:51:54.140 /usr/local/bind9/etc/named.conf:8: couldn't add command channel 127.0.0.1#953: address in use
18-Oct-2008 11:51:54.141 ignoring config file logging statement due to -g option
18-Oct-2008 11:51:54.142 load_configuration: success
18-Oct-2008 11:51:54.142 zone authors.bind/CH: starting load
18-Oct-2008 11:51:54.142 zone authors.bind/CH: loaded
18-Oct-2008 11:51:54.142 zone hostname.bind/CH: starting load
18-Oct-2008 11:51:54.142 zone hostname.bind/CH: loaded
18-Oct-2008 11:51:54.142 zone version.bind/CH: starting load
18-Oct-2008 11:51:54.142 zone version.bind/CH: loaded
18-Oct-2008 11:51:54.142 zone id.server/CH: starting load
18-Oct-2008 11:51:54.142 zone id.server/CH: loaded
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone version.bind/CH: enter
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone hostname.bind/CH: enter
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone authors.bind/CH: enter
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone id.server/CH: enter
18-Oct-2008 11:51:54.142 running
18-Oct-2008 11:51:54.143 zone_timer: zone version.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone version.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_timer: zone authors.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone authors.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_timer: zone hostname.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone hostname.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_timer: zone id.server/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone id.server/CH: enter
18-Oct-2008 11:52:05.974
Query String: select zone from cdn_idns_records where zone='www.aa.com'
18-Oct-2008 11:52:05.975
Query String: select zone from cdn_idns_records where zone='aa.com'
18-Oct-2008 11:52:05.975
Query String: select zone from cdn_idns_records where zone='com'
18-Oct-2008 11:52:15.279
Query String: select zone from cdn_idns_records where zone='www.bb.com'
18-Oct-2008 11:52:15.280
Query String: select zone from cdn_idns_records where zone='bb.com'
18-Oct-2008 11:52:15.280
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='www'
18-Oct-2008 11:52:15.280 mysql driver unable to return result set for lookup query
18-Oct-2008 11:52:15.280
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='*'
18-Oct-2008 11:52:15.281 mysql driver unable to return result set for lookup query
18-Oct-2008 11:52:15.281
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='@'
18-Oct-2008 11:52:15.282 mysql driver unable to return result set for lookup query
18-Oct-2008 11:52:15.282
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='*'
18-Oct-2008 11:52:15.283 mysql driver unable to return result set for lookup query
[root@localhost ~]# /usr/local/bind9/sbin/named -g -d 1 -c /usr/local/bind9/etc/named.conf 18-Oct-2008 11:51:54.113 starting BIND 9.5.0-P2 -g -d 1 -c /usr/local/bind9/etc/named.conf
18-Oct-2008 11:51:54.118 loading configuration from '/usr/local/bind9/etc/named.conf'
18-Oct-2008 11:51:54.119 listening on IPv4 interface lo, 127.0.0.1#53
18-Oct-2008 11:51:54.120 binding TCP socket: address in use
18-Oct-2008 11:51:54.120 listening on IPv4 interface eth0, 203.171.227.4#53
18-Oct-2008 11:51:54.120 binding TCP socket: address in use
18-Oct-2008 11:51:54.120 Loading 'Mysql zone' using driver mysql
18-Oct-2008 11:51:54.135 default max-cache-size (33554432) applies
18-Oct-2008 11:51:54.138 default max-cache-size (33554432) applies: view _bind
18-Oct-2008 11:51:54.140 /usr/local/bind9/etc/named.conf:8: couldn't add command channel 127.0.0.1#953: address in use
18-Oct-2008 11:51:54.141 ignoring config file logging statement due to -g option
18-Oct-2008 11:51:54.142 load_configuration: success
18-Oct-2008 11:51:54.142 zone authors.bind/CH: starting load
18-Oct-2008 11:51:54.142 zone authors.bind/CH: loaded
18-Oct-2008 11:51:54.142 zone hostname.bind/CH: starting load
18-Oct-2008 11:51:54.142 zone hostname.bind/CH: loaded
18-Oct-2008 11:51:54.142 zone version.bind/CH: starting load
18-Oct-2008 11:51:54.142 zone version.bind/CH: loaded
18-Oct-2008 11:51:54.142 zone id.server/CH: starting load
18-Oct-2008 11:51:54.142 zone id.server/CH: loaded
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone version.bind/CH: enter
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone hostname.bind/CH: enter
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone authors.bind/CH: enter
18-Oct-2008 11:51:54.142 dns_zone_maintenance: zone id.server/CH: enter
18-Oct-2008 11:51:54.142 running
18-Oct-2008 11:51:54.143 zone_timer: zone version.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone version.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_timer: zone authors.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone authors.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_timer: zone hostname.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone hostname.bind/CH: enter
18-Oct-2008 11:51:54.143 zone_timer: zone id.server/CH: enter
18-Oct-2008 11:51:54.143 zone_maintenance: zone id.server/CH: enter
18-Oct-2008 11:52:05.974
Query String: select zone from cdn_idns_records where zone='www.aa.com'
18-Oct-2008 11:52:05.975
Query String: select zone from cdn_idns_records where zone='aa.com'
18-Oct-2008 11:52:05.975
Query String: select zone from cdn_idns_records where zone='com'
18-Oct-2008 11:52:15.279
Query String: select zone from cdn_idns_records where zone='www.bb.com'
18-Oct-2008 11:52:15.280
Query String: select zone from cdn_idns_records where zone='bb.com'
18-Oct-2008 11:52:15.280
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='www'
18-Oct-2008 11:52:15.280 mysql driver unable to return result set for lookup query
18-Oct-2008 11:52:15.280
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='*'
18-Oct-2008 11:52:15.281 mysql driver unable to return result set for lookup query
18-Oct-2008 11:52:15.281
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='@'
18-Oct-2008 11:52:15.282 mysql driver unable to return result set for lookup query
18-Oct-2008 11:52:15.282
Query String: select ttl,type,mx_priority, case when lower(type)='txt' then concat('"', ip, '"') when lower(type)='soa' then concat_ws(' ', ip ,resp_person, serial, refresh, retry, expire, minimum0 else ip end as mydata from cdn_idns_records where zone='bb.com' and host='*'
18-Oct-2008 11:52:15.283 mysql driver unable to return result set for lookup query
leexhwhy
2008-10-17 10:56
你好:
看了您写的ngnix负载均衡的配置,我们网站也使用了ngnix+tomcat,有个问题是,配置成功后,监控服务器性能发现,一台tomcat CPU负载很高,另外一台几乎没有负载,而且内存使用很多,达到90%。是不是我配置有什么问题啊。
我的配置文件 http://leexhwhy.javaeye.com/blog/254029
期待您的回复。
看了您写的ngnix负载均衡的配置,我们网站也使用了ngnix+tomcat,有个问题是,配置成功后,监控服务器性能发现,一台tomcat CPU负载很高,另外一台几乎没有负载,而且内存使用很多,达到90%。是不是我配置有什么问题啊。
我的配置文件 http://leexhwhy.javaeye.com/blog/254029
期待您的回复。
迷茫
2008-9-30 20:19
能加你Q聊不,我的 QQQ:44580844
有事请教~~
有事请教~~
wi4r
2008-9-22 13:42
http://hi.baidu.com/wi4r 张大牛,做个连接.. 学习下
http://blog.s135.com/read.php/373.htm