Presto
RDBMS Resource Usage when Using PrestoDB #16179
-
|
When we querying mysql database using presto, is it means that we still using mysql’s resource like cpu or ram or not?. Thank you |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Yes. In the ideal scenario, MySQL will be able to utilize its own data structures and indices to answer the query before handing back the result to Presto. The real benefit to using Presto on relational databases is the ability to run queries from a single access point to multiple databases, or in particular, running federated queries (i.e. Joins and Unions) over multiple databases. There is no benefit to running Presto over a single relational database unless you plan to add more connectors in the future. The same doesn't apply to Hive or data lake connectors like Iceberg though. If this answers the question please accept and check on my profile to get in contact with me if you need any more information or something's still not clear. |
Beta Was this translation helpful? Give feedback.
-
|
I see. Thank you for the answer @bitsondatadev |
Beta Was this translation helpful? Give feedback.
Yes. In the ideal scenario, MySQL will be able to utilize its own data structures and indices to answer the query before handing back the result to Presto.
The real benefit to using Presto on relational databases is the ability to run queries from a single access point to multiple databases, or in particular, running federated queries (i.e. Joins and Unions) over multiple databases. There is no benefit to running Presto over a single relational database unless you plan to add more connectors in the future. The same doesn't apply to Hive or data lake connectors like Iceberg though.
If this answers the question please accept and check on my profile to get in contact with me if you need any …