Make your database queries 1000 times faster!

Подписаться 38 тыс.

Просмотров 49 тыс.

50% 1

Using PlanetScale Boost (planetscale.com/features/boost) you can make your queries up to 1000x faster.
If you want to learn more, you can view a technical deep dive on our blog: planetscale.com/blog/how-plan....
00:44 Overview of the sample database
01:50 Our sample query
03:00 Enabling PlanetScale Boost
04:00 A query with a 1000x improvement
06:22 PlanetScale Boost UI
07:57 How PlanetScale Boost works
------------------
📚 Learn more about PlanetScale
• Website: planetscale.com/
• Docs: docs.planetscale.com/
------------------
💬 Follow PlanetScale on social media
• Twitter: / planetscaledata
• TikTok: / planetscale
• Twitch: / planetscale
• LinkedIn: / planetscale

Наука

Опубликовано:

1 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 84

@wagnerbugs 10 месяцев назад

Do you know what the only problem with this channel is? Without a doubt, it's not having videos every day. 😂 Congratulations on yet another great video. ❤

@PlanetScale 10 месяцев назад

Thank you!

@softwaredevx 4 месяца назад

You guys are amazing. Love to watch your videos and learn new things.

@VuTuanIT 9 месяцев назад

I didn't give it a try but I'm curious: - The cache is updated in sync or async? will the updates be available right after we write the new values? - Will the cache work well on heavy write tables? Something like a data logs table that can have a thousand rows written per second

@GoncaloMangana 10 месяцев назад

So, the more materialized cached views you have using the same tables, the worst the write performance will be? How much impact does it have? I'm curious if it is an acceptable trade off, like if you get an extra 2s on a write but gain 60s on a read, I would be ok with that. Could you shed some light please?

@arthurmagamedov3179 10 месяцев назад

That's nice!! It's like IBM DB2 version of MQT with MAINTAIN BY SYSTEM option, but created automatically! That's cool!!

@m.h.6470 10 месяцев назад

As someone who works with bigger databases and complex queries on a daily basis, I can say, that this is quite unrealistic. The queries that take a lot of time are not the queries, that are run over and over again. Those repeated queries are usually optimized already. The big long queries are the queries that are very complex and have many dynamic parts (like different where clauses, changing group conditions, etc.) and can therefore not be cached or optimized in the way you are saying.

@captainchaos3667 7 месяцев назад

If something sounds too good to be true, that's probably because it's not true. If it was this easy to make every query a thousand times faster everyone would do that. Disappointing to see clickbait on this channel, but good to know.

@sampleshawn5380 9 месяцев назад

Man you are awesome, i am binge watching your stuff, kudos

@PlanetScale 9 месяцев назад

Thank you!

@micha-ix1iy 10 месяцев назад

Is this eventuell consistent or does writing block until boost’s caches are updated?

11 месяцев назад

This guy is very smart

@TomandJerryaredead 6 месяцев назад

Does Boost support ORDER BY queries? And does it support the use of NOW() in a WHERE clause?

@faiz_0000 7 месяцев назад

10:32 what about the data that already exist in the database? do you rewrite the entire data or just move the existing data to cache based on the query that we want to boost

@SeyedaMansour 10 месяцев назад

Just found your chanel, can't stop watching :D, great videos so far, keep up the good work. For things like this i tend to to add a redundant (count/calc/processed) column to the table and update it on created_at/updated at, it does just fine. your method is probably faster since you do less with db but u use more non-db resources, so it's trade off i guess.

@pau1phi11ips 9 месяцев назад

Same 🤓

@WaltersWatching 11 месяцев назад

You'd think a cache would be affordable, $100/month minimum is wild.

@otmanm4095 11 месяцев назад

This guy is very strong

@StevenGlrz 10 месяцев назад

Does this have a penalty on write performance?

@pietraderdetective8953 9 месяцев назад

Amazing! Love planetscale coz of these improvements they're doing 👍🏻

@user-ve9ix1fe9e 8 месяцев назад

Hi, that's great! Is there any introduction to the implementation of the boost acceleration function in the source code?

@PlanetScale 8 месяцев назад

The most technical documents we have on the implementation would be in the linked blog post! I think in the blog post there is also a link to the academic paper it's based upon

@user-ve9ix1fe9e 8 месяцев назад

@@PlanetScale This OSDI ’18 paper is really very detailed. I would like to know more code details. Is the source code of Boost function public? So which file is the entrance to the implementation in the github warehouse?😀

@Guilherme-qk9so 10 месяцев назад

Very cool!

@daguttt 11 месяцев назад

Sheeeesh

@DirkSchut 7 месяцев назад

Probably never gonna need this, but I'm curious why an 8GB cache is more than 8x as expensive as a 1GB cache.

@ucretsiztakipci6612 11 месяцев назад

Excellent feature but too expensive.

@DerClaudius 6 месяцев назад

Quick question... the switching looked instant, although I would expect that at least the first execution of the query should still be slow to fill the boost cache and setup the change listeners.. Did you just skip that for the vid?

@PlanetScale 6 месяцев назад

Boost fills the cache in the background. So until Boost is ready the queries don't run through it. As far as listeners, it just subscribes to the existing Vitess events so that part is pretty lightweight

@mehboobfazal 10 месяцев назад

Pretty old days my mysql 😊. Love to see this happen. I'll really give a shot in my next upcoming project.

@spicynoodle7419 10 месяцев назад

Write-through cache

@PlanetScale 10 месяцев назад

It's similar but PlanetScale Boost is more performant and less to maintain.

@spicynoodle7419 10 месяцев назад

@@PlanetScale I shall get to the bottom of this dark magic

@dechobarca 10 месяцев назад

Why does a simply query that returns just a thousand records take almost an entire second in first place?

@PlanetScale 10 месяцев назад

It's joining in a table that's an aggregate over a few million rows

@dechobarca 10 месяцев назад

@@PlanetScale ah I see, my bad. I don't use planetscale myself, but you do have some good SQL videos, so keep up the great work, cheers!

@blazed-space 10 месяцев назад

You guys have gotten my business, your product is amazing and prioritizes speed and affordability which is key for me

@michelvandermeiren8661 9 месяцев назад

Impressive ! Is the web interface for continuous testing opensource ?

@PlanetScale 9 месяцев назад

No unfortunately not!

@adarshchacko6137 10 месяцев назад

Curious question: Between the 2 which is faster and why ? QUERY 1: SELECT * FROM users; QUERY 2: SELECT FROM users;

@gileee 10 месяцев назад

Selecting a single column is less data. Less data needs to be read from storage, sent over the network and in the end displayed/processed, so it'll be faster. "*" in general means the db will need to first fetch what columns exist on that table in order to retrieve them. So it's never ideal for performance, even if you need all the data.

@adarshchacko6137 10 месяцев назад

@@gileee Thanks Didn't quite get the last part though "So it's never ideal for performance, even if you need all the data." What is not ideal... "SELECT *" ??

@gileee 10 месяцев назад

@@adarshchacko6137 Yeah. If you do * apparently the db has to first fetch the definition of the table to figure out which columns it has. So it would be slightly more performant to write "SELECT col1, col2, ..." and list all the columns.

@adarshchacko6137 10 месяцев назад

Understood... Thank you @gileee

@chinheiyung1303 10 месяцев назад

What is the sql client are you using? Look so sleek

@PlanetScale 10 месяцев назад

TablePlus!

@pinguluk1 10 месяцев назад

What are the disadvantages?

@ropoxdev 9 месяцев назад

Cost, but it’s free during beta

@mainakdas5819 11 месяцев назад

What is the application used for running SQL query?

@isakhansson917 11 месяцев назад

He literally said it in the video?

@PlanetScale 11 месяцев назад

TablePlus!

@mainakdas5819 10 месяцев назад

@@isakhansson917 maybe I missed 😅

@GottZ 10 месяцев назад

The auto creation of triggers to update cached representations / views on the fly on data changes sure is impressive.. how ever.. isn't this 101 of database architecture, anyone creating proper databases should know? This feels like a feature primarily targeted towards people with lacking database knowledge. Especially the video title.

@PlanetScale 10 месяцев назад

Sorry if it wasn't clear, this does not rely on triggers or views. It creates a query plan, inverts it, and incrementally updates the cache as new writes come in. It works for more than just counts, and it doesn't run the entire query again. The attached blog post goes into more detail if you're interested.

@icebox747 9 месяцев назад

Anyone knows the Vetez he is mentioning in the video?

@PlanetScale 9 месяцев назад

vitess.io!

@jacekkangaroo4402 10 месяцев назад

I hate when people do not use table/view aliases, it is a very bad habit, it makes complex queries difficult to analyze

@vickoalan 11 месяцев назад

if we use Planetscale Boost we don't need caches like radius right???

@PlanetScale 11 месяцев назад

For queries that are Boosted, you would no longer need a cache!

@fuxtnegrx 10 месяцев назад

Error Code: 1193. Unknown system variable 'boost_cached_queries' 0.141 sec

@stefanotorelli3688 10 месяцев назад

You forgot to explain the architecture of your solution, even if it OOB in MySQL.

@ComfyCosi 10 месяцев назад

Lenseless glasses T_T

@aarondfrancis 10 месяцев назад

🥸

@aarondfrancis 11 месяцев назад

This guy is very me

@OrangeNerd1 11 месяцев назад

light mode 🤨

@aarondfrancis 11 месяцев назад

@@OrangeNerd1 ¯\_(ツ)_/¯

@yousafwazir286 11 месяцев назад

How dose it make it 1000 x faster ?

@PlanetScale 10 месяцев назад

Boost deconstructs the query plans and applies incremental updates to the cache when data is updated. For more details check out the video or the linked post!

@Alekzv9 11 месяцев назад

This guy is very handsome

@dn5426 10 месяцев назад

your last name checks out!

@kskredderbakken 8 месяцев назад

why isn't boost standard......?

@kskredderbakken 8 месяцев назад

HOW isn't he question. WHY is the question. We have good enough chips to leave 1980 behind.

@PlanetScale 8 месяцев назад

It's a good question! The research paper was only released recently. We're among the few people in the world that have implemented it at a production grade. It's tough to deconstruct queries and apply partial updates to caches upon write instead of rerunning entire queries, so that's my guess.

@GackFinder 9 месяцев назад

5:28

@jwbonnett 7 месяцев назад

Sounds the same as a projection

@martintsekov7820 10 месяцев назад

Quite weird that he wears fake glasses..

@ousspero 10 месяцев назад

This is what we call a View

@obapelumi 10 месяцев назад

Not necessarily. A view gets re-created/re-calculated whenever it is read/queried. With planet scale boost it is re-calculated when the underlying data which the query represents is written to

@PlanetScale 10 месяцев назад

Kind of! In the video I explain why it's like a view, but fundamentally quite different.