MemSQL性能测试结果

最新推荐文章于 2024-07-08 09:06:57 发布

current_person

最新推荐文章于 2024-07-08 09:06:57 发布

阅读量3.9k

点赞数

分类专栏： sql 文章标签：性能测试 memsql mycat mysql 数据库

本文链接：https://blog.csdn.net/current_person/article/details/52399864

版权

sql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

1.查询的SQL

select count(subie.user_id) as count    
from sum_user_basic_info_exp subie 
join sum_user_lend_info_exp sulie 
on sulie.user_id=subie.user_id  
where subie.curr_user_role_cd='1' 
and subie.reg_dt >='2016-08-29' 
and subie.reg_dt <='2016-08-29'

结果：

mycat1 mycat2 memsql1 memsql2
2.24s 2.25s 0.67s 0.05s

2.查询的SQL

select count(subie.user_id) as count    
from sum_user_basic_info_exp subie 
join sum_user_lend_info_exp sulie 
on sulie.user_id=subie.user_id  
join sum_mk_coupon_info_exp smcie
on smcie.user_id=subie.user_id
and smcie.rcv_dt>='2016-08-20'
and smcie.coupon_status_cd in ('1','2','4')

结果：

mycat1 mycat2 memsql1 memsql2

6.63s 9.49s 1s 0.04s

3.查询的SQL

select count(subie.user_id) as count    
from sum_user_basic_info_exp subie 
join sum_user_lend_info_exp sulie 
on sulie.user_id=subie.user_id  
join sum_mk_coupon_info_exp smcie
on smcie.user_id=subie.user_id
and smcie.rcv_dt>='2016-08-20'
and smcie.coupon_status_cd in ('1','2','4')             
join fct_ld_lender_finances fllf
on fllf.user_id=subie.user_id
and fllf.fin_status_cd in ('4','9')
and fllf.is_renew=1
join ld_lend_by_lend_tm_stat llblts
on llblts.user_id=subie.user_id
and llblts.lend_tm>='2016-08-20'
where subie.curr_user_role_cd='1'
and sulie.bind_wx_dt is not null 
and subie.reg_dt >='2016-08-29' 
and subie.reg_dt <='2016-08-29'

结果：

4.查询的SQL

select platform_reg_chnl_cd,count(subie.user_id) as count    
from sum_user_basic_info_exp subie 
join sum_user_lend_info_exp sulie 
on sulie.user_id=subie.user_id  
join fct_ld_lender_finances fllf
on fllf.user_id=subie.user_id
and fllf.fin_status_cd in ('4','9')
and fllf.is_renew=1
join ld_lend_by_lend_tm_stat llblts
on llblts.user_id=subie.user_id
and llblts.lend_tm>='2016-07-20'
where subie.curr_user_role_cd='1'
and sulie.bind_wx_dt is not null 
and subie.reg_dt >='2016-07-29' 
and subie.reg_dt <='2016-08-29'
group by platform_reg_chnl_cd
order by platform_reg_chnl_cd;

结果：

、

5.查询的SQL

select platform_reg_chnl_cd,count(subie.user_id) as count              
from sum_user_basic_info_exp subie 
join sum_user_lend_info_exp sulie 
on sulie.user_id=subie.user_id  
join sum_mk_coupon_info_exp smcie
on smcie.user_id=subie.user_id
and smcie.rcv_dt>='2016-08-10'
and smcie.coupon_status_cd in ('1','2','3')
group by platform_reg_chnl_cd
order by platform_reg_chnl_cd;

结果：

mycat1 mycat2 memsql1 memsql2

6.89s 7.06s 0.08s 0.06s