Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Check the claims in this blog
Attachments
Issue Links
- is blocked by
-
MDEV-17474 Change Unicode collation implementation from "handler" to "inline" style
- Closed
-
MDEV-17502 Change Unicode xxx_general_ci and xxx_bin collation implementation to "inline" style
- Closed
-
MDEV-17511 Improve performance for ORDER BY with a CHAR(N) CHARACTER SET utf8_unicode_ci
- Closed
-
MDEV-17534 Implement fast path for ASCII range in strnxfrm_onelevel_internal()
- Closed
- relates to
-
MDEV-8872 Performance regressions with utf8mb4 vs utf8 in WordPress
- Closed
utf8_unicode_ci
# data set 03 -> mariadb-10.3.9
# data set 06 -> mysql-8.0.11
# data set 07 -> mariadb-10.4 baseline
# data set 08 -> mariadb-10.4 with inline collate
# read-only (short ranges)
#thd 03 06 07 08
1 6212.1 6744.6 5911.8 7197.8
2 11072 13233 10696 13491
4 21491 25630 21763 25607
8 38310 45858 39494 45109
16 72045 91982 69576 84109
32 94114 129141 91978 109944
64 89896 129005 89959 104324
128 90026 129264 89056 108373
256 92578 128756 91488 107215
most busy function in mysqld:
12.56% [.] my_uca_strnxfrm_onelevel_no_contractions_utf8mb3
call graph:
- 12.03% 11.86% [.] my_uca_strnxfrm_onelevel_no_contractions_utf8mb3
- my_uca_strnxfrm_onelevel_no_contractions_utf8mb3
- 99.81% my_uca_strnxfrm_no_contractions_utf8mb3
_ZN12Field_string11sort_stringEPhj
_ZL12make_sortkeyP10Sort_paramPhS1_
_Z8filesortP3THDP5TABLEP8FilesortP16Filesort_trackerP4JOINy
_Z17create_sort_indexP3THDP4JOINP13st_join_tableP8Filesort
_ZN13st_join_table10sort_tableEv
_Z21join_init_read_recordP13st_join_table
_ZN7AGGR_OP8end_sendEv
_Z24sub_select_postjoin_aggrP4JOINP13st_join_tableb
_ZN4JOIN10exec_innerEv
_ZN4JOIN4execEv