Zum Hauptinhalt springen
••••••••••••••••••••••••••••••••••••••••
Intelligence View
⚡ tsecurity.de Intelligence

MySQL: Pluggable Table Functions, Part 2

HD Video
Pluggable Table Functions, Part 2
Video abspielen

Video von MySQL auf YouTube: Proposed MySQL pluggable table function enhancements could help developers implement SQL table functions through components, with…

Beitrag
0
Seite
0
↗ Quelle (MySQL)
Social ReaktionenReagiere als Erste:r — dein Feedback zählt!

Proposed MySQL pluggable table function enhancements could help developers implement SQL table functions through components, with additional data type operations and streaming access to reduce unnecessary materialization. Explore Tencent Cloud's work on JSON_TABLE compatibility, component services, and optimizer integration, and share feedback with the MySQL community: https://github.com/mysql/mysql-community/issues/92



Explore the continued development of pluggable table functions in MySQL, including component interfaces, data type operations, streaming execution, and query optimizer integration. In this MySQL Summit session, a Tencent Cloud developer presents the second part of a proposal to extend MySQL table function capabilities through the component framework, allowing additional table functions to be implemented outside the core MySQL server.



The presentation builds on an earlier proposal for a table function extension interface. During implementation, additional requirements emerged around accessing and manipulating MySQL data types from components. The session explains how existing component services expose values through handles but do not provide all the operations needed to implement complex table functions, particularly those working with strings, decimals, and JSON data.



To investigate these limitations, the project introduces additional component services for data type operations and uses JSON_TABLE as a reference implementation. A component-based function called JSON_TABLE_C demonstrates how much of the native JSON_TABLE behavior can be reproduced through the proposed extension framework.



The presentation compares the component implementation with MySQL's native JSON_TABLE function. Although the two implementations provide largely similar behavior, JSON_TABLE_C uses regular function syntax rather than the specialized column specification syntax supported by the native function. The session also reports that the component implementation is approximately 50% slower under heavy workloads, highlighting potential performance tradeoffs between component-based functionality and native server implementations.



The second major topic is streaming support for pluggable table functions. The initial interface relies on materializing results into temporary tables, which can consume significant memory, processing resources, and local disk space for large result sets.



The proposed enhancement introduces an iterator-style interface with open, fetch, and close operations. This would allow table functions to support either materialized execution or streaming access, potentially avoiding full result materialization when processing larger data sets.



The session also examines the additional information required by the MySQL query optimizer to select appropriate access methods for streaming table functions. More advanced capabilities, including projection and filter pushdown, would require further development.



The presentation raises architectural questions about the relationship between table functions and MySQL storage engines. While both can provide access to data through SQL, table functions may be particularly useful for temporary or external resources, such as files in data lakes and HTTP endpoints.



Finally, the session discusses integration with the MySQL hypergraph optimizer and the challenges of supporting the traditional optimizer alongside newer optimization approaches. Community feedback is requested on component interface design, optimizer requirements, streaming execution, and the appropriate division of functionality between the MySQL server and extensions.



These capabilities are part of an evolving development proposal. The presentation describes experimental implementations, performance observations, and design questions rather than generally available MySQL functionality.
🔍 CTI & Forensik

Cyber Threat Intelligence & Forensik

ATT&CK-Navigator · IoC-Radar · Exploit-Belege
CTI Threat Relationship Graph
Akteure · Techniken · Beziehungen
2 Knoten · 1 Relationen
CVE / Incident Threat Actor Software MITRE ATT&CK CWE Weakness IoC
Intelligence Digest — kostenlos Täglich die wichtigsten Security-News · jederzeit abbestellbar
Community Rating & Social Proof
⭐ Leser-Wertung
–
Ø / 5.0
Noch keine Leser-Bewertungen
War diese Seite hilfreich?
0
Jetzt Bewertung abgeben
🟢 Niedrig (1-3.9) 🟡 Mittel (4.0-6.9) 🔴 Hoch (7.0-8.9) Kritisch (9.0-10.0)

Verwandte Story-Cluster & Quellen (Vektor-KI)

Zum Aktualisieren ziehen
Nächster Beitrag