mirror of
https://github.com/MariaDB/server.git
synced 2025-07-19 01:38:13 +02:00
04ef45cb5b
- In Spider, calling cmp_ref() can be very expensive. In ha_partition.cc
we don't anymore sort rows according to position for the Spider
engine.
- Removed Spider specific call info(HA_EXTRA_STARTING_ORDERED_INDEX_SCAN)
from handle_ordered_index_scan(). It's caused performance issues and
does not change results for queries with ORDER BY.
- The visible effect of this patch is that for some storage engines,
rows may be returned in a different order if there is no ORDER BY clause.
- Based in Spiral Patch 052:
052_mariadb-10.2.0.add_partition_skip_pk_sort_for_non_clustered_index.diff
MDEV-7748
- The major difference from original patch is that there is no variable to
get the old behaviour.
- Other things:
- Optimized ha_partition::cmp_ref() and cmp_part_ids() to make them
simpler and faster.
- Changed arguments to cmp_key_part_id() to be same as cmp_key_rowid_part_id
to simplify code.
Original author: Kentoku SHIBA
First reviewer: Jacob Mathew
Second reviewer: Michael Widenius
|
||
|---|---|---|
| .. | ||
| hs_client | ||
| mysql-test/spider | ||
| scripts | ||
| CMakeLists.txt | ||
| configure.in | ||
| ha_spider.cc | ||
| ha_spider.h | ||
| Makefile.am | ||
| spd_conn.cc | ||
| spd_conn.h | ||
| spd_copy_tables.cc | ||
| spd_copy_tables.h | ||
| spd_db_conn.cc | ||
| spd_db_conn.h | ||
| spd_db_handlersocket.cc | ||
| spd_db_handlersocket.h | ||
| spd_db_include.h | ||
| spd_db_mysql.cc | ||
| spd_db_mysql.h | ||
| spd_db_oracle.cc | ||
| spd_db_oracle.h | ||
| spd_direct_sql.cc | ||
| spd_direct_sql.h | ||
| spd_environ.h | ||
| spd_err.h | ||
| spd_i_s.cc | ||
| spd_include.h | ||
| spd_malloc.cc | ||
| spd_malloc.h | ||
| spd_param.cc | ||
| spd_param.h | ||
| spd_ping_table.cc | ||
| spd_ping_table.h | ||
| spd_sys_table.cc | ||
| spd_sys_table.h | ||
| spd_table.cc | ||
| spd_table.h | ||
| spd_trx.cc | ||
| spd_trx.h | ||
| spd_udf.cc | ||
| spd_udf.def | ||
| spd_udf.h | ||