[MDEV-12332] MariaDB spider performance Created: 2017-03-22  Updated: 2017-04-20  Resolved: 2017-04-20

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: hiller1 Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: need_feedback
Environment:

##spider###
spider_conn_recycle_mode = 1
optimizer_switch = 'engine_condition_pushdown=on,mrr=on,mrr_sort_keys=on'

spider_version:3.2.37


Issue Links:
Duplicate
is duplicated by MDEV-7698 Spiral patches Closed

 Description   

My I ask a question about spider's performance issues.

I am a financial company DBA, the project selected spider storage engine to do the table split, and now meet a problem, spider's performance has not been promoted up, I would like to ask which parameters should be adjusted? Thank you!

By the way ,when maxscale can support the table split?



 Comments   
Comment by Elena Stepanova [ 2017-04-19 ]

JIRA is not the best place for getting this sort of feedback. You can acquire wider variety of opinions and response by using community mailing llists, such as maria-discuss@lists.launchpad.net .

stephane@skysql.com, would you like to answer this here?

Comment by VAROQUI Stephane [ 2017-04-20 ]

Regarding Spider table split performance , we can't really provide performance improvement as of the state of MariaDB today. To Improve the performance MariaDB Server as to be modified and this is a work in progress that will happen in 10.3 with the sponsoring of many clients. I invite you to join this effort , that will give you access to some modify spiral release of 10.0 and 10.1 that work great for performance ends up with a 10.3 that will stop diverging from the trunk. When you get such a release i can guide you to get performance improvements.

Comment by Elena Stepanova [ 2017-04-20 ]

I assume it is MDEV-7698, then.

Generated at Thu Feb 08 07:56:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.