优化记录 --- skywalking 使用MySQL存储，索引优化记录

别看了，数据量大起来MySQL 没啥用，还是老老实实的用 ElasticSearch 吧。。。

create index segment_time_service_index_1
    on segment (service_id, time_bucket, endpoint_name);

create index segment_time_service_index_2
    on segment (service_id, time_bucket, is_error, endpoint_name);

create index segment_time_service_index_3
    on segment (service_instance_id, time_bucket, is_error, endpoint_name);

create index segment_time_service_index_4
    on segment (service_id, service_instance_id, time_bucket, is_error, endpoint_name);

create index segment_time_service_index_5
    on segment (service_id, start_time, end_time);

create index segment_time_service_index_6
    on segment (service_instance_id, start_time, end_time);

create index segment_time_service_index_7
    on segment (service_id,service_instance_id, start_time, end_time);

create index segment_time_service_index_8
    on segment (trace_id, start_time, end_time);

create index segment_time_service_index_9
    on segment (trace_id, time_bucket);


create index segment_time_service_index_10
    on segment ( time_bucket, endpoint_name,latency desc);

alter table events
    modify parameters varchar(4096) null;