TiDB Weekly

News & blog posts

TiDB is an HTAP database that targets both OLTP and OLAP scenarios. TiFlash is its extended analytical engine. Last week, we published a post that introduces how TiFlash fuels TiDB to become a true HTAP database that lets users perform real-time analytics.

The full article is here:

Delivering Real-time Analytics and True HTAP by Combining Columnstore and Rowstore

Is there an easier way to write TiDB SQL statements, to test the compatibility, and to easily understand the difference between TiDB and MySQL? Yes. Now, you can run TiDB directly in a web browser.

Last week, we published another posts that introduces how you can run TiDB directly in a web browser, how it is possible, and what the limitations are.

The full article is here:

TiDB in the Browser: Running a Golang Database on WebAssembly

Community

New contributors

tidb:

• chenlx0
• CSFresh
• KuangBo
• zhongshanhao
• soobun

tikv:

• iswade

tidb-operator:

• silentred

Call for participation

• Vectorized Expression Working Group

  • Date or Time built-in functions (25/65)
  • Decimal built-in functions (19/31)
  • Int built-in functions (150/187)
  • JSON built-in functions (19/27)
  • Real built-in functions (46/49)
  • String built-in functions (80/133)
  • Duration built-in functions (17/45)
  • Last week, 54 PRs were landed in the expression component.

• Coprocessor SIG:

  • Improve the performance of Chunk Encoder
  • Implement more UDFs
  • Implement the new row format
  • Port BinaryJSON
  • Tracing
  • The maximum execution time of Per-request

• More issues to solve for TiDB

• More issues to solve for TiKV

Updates of the week

Progress

Last week, we landed 151 PRs in the TiDB repository, 13 PRs in the TiSpark repository, and 58 PRs in the TiKV and PD repositories.

Critical PRs

TiDB:

• Add the table_tiflash_replica table to check the status of tableTiFlashReplica
• Handle the deprecated configuration items in config-check
• Support using multiple bindings in the planner
• Add the PushSelDownAggregation transformation rule in the cascades planner
• Support innodb_lock_wait_timeout for the pessimistic transaction
• Push json_length to TiKV
• Add the tidb_cluster_config virtual table to retrieve all instance configurations
• Add binlog_status for the HTTP API and the TIDB_SERVERS_INFO table
• Limit the length of the index name when executing the CREATE TABLE statement
• Vectorize the hash calculation during probing
• Support the required rows for the arrow decode format

TiSpark:

• Fix the Stack Overflow error when reading from the partition table
• Fix OrderProjectLimitPushdown

TiKV and PD:

• Support the lock wait timeout
• Refactor DateTime
• Fix the issue that the value type is incorrect when parsing a number to JSON
• Refactor the storage module
• Fix the wrong Region size
• Use the store flow byte rate to make schedule decisions
• Fix the stale operator when scattering Regions
• Support the key range for schedulers