zabbix代理数据库items表字段优化

1、zabbix代理数据库在创建数据库时需要设置utf8编码(安装请看zabbix4.2分布式环境搭建 )

 create database zabbix_proxy character set utf8;

2、数据库导入空表

 mysql  -uroot  -p’123456’  zabbix_proxy  <  schema.sql

3、mysql默认的编码是不区分大小写，需要设置items表的字段区分大小写，utf8_bin(字段区分大小写，以二进制码存储)

某些需要区分大小写的监控，例如KEY值，因大小写问题，很可能不能入库

item表需要更改字段的编码的字段，可以参考如下(字段名称可能有更改)

#alter table items modify snmp_community varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify snmp_oid varchar(255) character set utf8 COLLATE utf8_bin;
alter table items modify name varchar(255) character set utf8 COLLATE utf8_bin not null default '' after hostid;
alter table items modify key_ varchar(255) character set utf8 COLLATE utf8_bin not null default '' after name;
#alter table items modify trapper_hosts varchar(255) character set utf8 COLLATE utf8_bin;
#alter table items modify units varchar(255) character set utf8 COLLATE utf8_bin;
#alter table items modify snmpv3_securityname varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify snmpv3_authpassphrase varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify snmpv3_privpassphrase varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify formula varchar(255) character set utf8 COLLATE utf8_bin;
#alter table items modify error varchar(128) character set utf8 COLLATE utf8_bin;
#alter table items modify logtimefmt varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify delay_flex varchar(255) character set utf8 COLLATE utf8_bin;
#alter table items modify params text character set utf8 COLLATE utf8_bin;
#alter table items modify ipmi_sensor varchar(128) character set utf8 COLLATE utf8_bin;
#alter table items modify username varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify password varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify publickey varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify privatekey varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify filter varchar(255) character set utf8 COLLATE utf8_bin;
#alter table items modify port varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify description text character set utf8 COLLATE utf8_bin;
#alter table items modify lifetime varchar(64) character set utf8 COLLATE utf8_bin;
#alter table items modify snmpv3_contextname varchar(255) character set utf8 COLLATE utf8_bin;