What's new in Vitess 21?
7:01
28 күн бұрын
Using vector search in MySQL
18:49
Vitess at Demonware
28:33
4 ай бұрын
What's new in Vitess 20?
3:53
5 ай бұрын
Пікірлер
@Shez-dc3fn
@Shez-dc3fn Күн бұрын
what if there were NO secondary keys?
@pattana_pu
@pattana_pu 4 күн бұрын
Thank you so much. I love this video.
@K.Huynh.
@K.Huynh. 7 күн бұрын
So cool! thank you so much for sharing!
@aFfoochen
@aFfoochen 8 күн бұрын
Thank you so much for this video. Really high quliaty and direct to the point. Learned a lot!
@PlanetScale
@PlanetScale 7 күн бұрын
Glad you got a lot out of it.
@bevedel
@bevedel 10 күн бұрын
AWESOME! thank you
@عليالعصفوري-ط4ض
@عليالعصفوري-ط4ض 12 күн бұрын
Is there a quey return data like [posts => [ Post=> 'hello', User => [ Id=>6, Name=>'jack' ]] as this
@TheErickds
@TheErickds 14 күн бұрын
maan! I just found this youtube channel, and I can say these 2 words about its content: Quality and Practicality!
@PlanetScale
@PlanetScale 14 күн бұрын
Thank you! Appreciate it.
@Smit-SundaramTech
@Smit-SundaramTech 15 күн бұрын
MySQL returning same select query result from buffer, where there is update query parallelly executing from client application, how to prevent this, so i can get updated result from mysql?
@PlanetScale
@PlanetScale 15 күн бұрын
Is the update and the select queries happening in a single transaction, or two separate ones? If the same, then just ensure you runt he update before the select. If the latter, you should ensure that the update transaction completed before you try to select the new data. If you are using PlanetScale (or something similar) and are updating on the primary and then selecting on a replica, there can be replica lag. In this case, you'd either have to live with it, or make both requests to your primary.
@Smit-SundaramTech
@Smit-SundaramTech 14 күн бұрын
@@PlanetScale I have multiple client connected with same DB table where counter field is getting updated first and then select query is being executed to get updated value, each client needs updated value but randomly on client PC I receiving old field value instead of updated one and when i fire query again in few seconds immediately its giving me updated value. How i can prevent this?
@SazianNULL
@SazianNULL 15 күн бұрын
Ok, but what if i some time need case sensitive and some time not?
@kasir-barati
@kasir-barati 18 күн бұрын
One more issue, id is most of the times uuid
@AnselmaRiemer
@AnselmaRiemer 19 күн бұрын
I really appreciate your efforts! Could you help me with something unrelated: I have a SafePal wallet with USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). What's the best way to send them to Binance?
@HollyGuevaraPS
@HollyGuevaraPS 21 күн бұрын
If you're confused about what happens to the exercises table that I mentioned we'd want to move to the sharded keyspace, it's because I only address it in the "Avoiding cross-shard queries" video (my bad!). Because it's hard/impossible to find a Vindex that guarantees all rows for a users exercises and exercise logs are on the same shard, we're actually going to utilize Vitess reference tables for that one. It allows you to make a copy of the table on every shard. This is a great option for smaller relatively static tables, such as exercises.
@ElevateCode
@ElevateCode 21 күн бұрын
I was trying to google how to pronounce paginate when I clicked on this LOL
@ahmad-murery
@ahmad-murery 21 күн бұрын
Nice. I wonder what exercise made Lily feel great?
@HollyGuevaraPS
@HollyGuevaraPS 21 күн бұрын
Just checked the exercises table. Looks like she was doing conventional deadlifts! Lily is my dog so I guess that's pretty impressive :D
@ahmad-murery
@ahmad-murery 21 күн бұрын
@@HollyGuevaraPS great, we'll have another Anatoly soon (if you know what I'm referring to 😁)
@HollyGuevaraPS
@HollyGuevaraPS 21 күн бұрын
@@ahmad-murery hahah she's got a sleeper build for sure!
@ahmad-murery
@ahmad-murery 21 күн бұрын
@@HollyGuevaraPS 😎
@HollyGuevaraPS
@HollyGuevaraPS 21 күн бұрын
Free database hat to the first person to timestamp when you hear my toddler screaming in the background! 😭
@ahmad-murery
@ahmad-murery 21 күн бұрын
14:42 - 14:44
@ahmad-murery
@ahmad-murery 20 күн бұрын
Hello once again Holly, I just wanted to let you know that I haven't received my "Free database hat" yet. I hope it's not due to bad weather 🤔😁 Just kidding, anyway, a digital form (of the hat) is accepted
@PlanetScale
@PlanetScale 17 күн бұрын
@@ahmad-murery Wow I just noticed YT held back my original response from my personal account 😭 email me [email protected]!
@ahmad-murery
@ahmad-murery 17 күн бұрын
@@PlanetScale YT algos are weird sometimes Sent you an email, please check
@leonardoisaiasmezanunez5598
@leonardoisaiasmezanunez5598 24 күн бұрын
Thanks for the video.
@gnatinator
@gnatinator Ай бұрын
The update videos are really nice.
@samgraham6355
@samgraham6355 Ай бұрын
First
@tomasprochazka6198
@tomasprochazka6198 Ай бұрын
Postgres for everything
@mihailborovik
@mihailborovik Ай бұрын
🎉🎉🎉❤❤❤
@ahmad-murery
@ahmad-murery Ай бұрын
The first time I dealt with embedding was to build an app that allows you to chat with documents, I struggled to to get the results/answers properly formatted. Now, It seems easier for me to understand what's going on and I should revisit my code. Thanks Ben!
@PlanetScale
@PlanetScale Ай бұрын
Awesome! What vector DB were you using for this project?
@ahmad-murery
@ahmad-murery Ай бұрын
@@PlanetScale I think it was chroma vector store
@PlanetScale
@PlanetScale Ай бұрын
@@ahmad-murery Cool!
@MikeCoutermarsh
@MikeCoutermarsh Ай бұрын
great teacher
@VV-xd2cv
@VV-xd2cv Ай бұрын
Very Good Explaination
@sheldon98c
@sheldon98c Ай бұрын
I never read about vector embedding but you explained the basics very easily.
@PlanetScale
@PlanetScale Ай бұрын
I'm glad you learned something!
@romanwbruce
@romanwbruce Ай бұрын
great video !
@ahmad-murery
@ahmad-murery Ай бұрын
I was a bit confused when I first read about Vector Embedding, now it's a little clearer. It's really funny how the most important point often comes in the next video. Thanks Ben!
@PlanetScale
@PlanetScale Ай бұрын
You are welcome! Appreciate your comments, and yes, stay tuned for a walkthrough of how to use it with PS.
@simbiat
@simbiat Ай бұрын
Images not fitting into squares was just... aaaaaaaaa
@AbhishekPrajapati-b1e
@AbhishekPrajapati-b1e Ай бұрын
Beautifully explained! I really appreciate it
@amrsaber5457
@amrsaber5457 Ай бұрын
What's that app he uses for the database?
@MD-mp7zm
@MD-mp7zm Ай бұрын
Amazing video, Is it possible to handle datetime ragnes based on timezone. Timezones are my nightmare these days.
@s8x.
@s8x. Ай бұрын
great video. learning from youtube is amazing BUT its all about finding the right video. this one has 58k views. should be way higher
@ukraineincolor
@ukraineincolor 2 ай бұрын
So when?
@Liam69696
@Liam69696 2 ай бұрын
Which work bench are you using???
@bytestarter
@bytestarter 2 ай бұрын
what about joinning?
@Sergey-jq5kz
@Sergey-jq5kz 2 ай бұрын
Unsigned int is perfekt
@anandhunt1000
@anandhunt1000 2 ай бұрын
pgadmin is best for postgresql
@vvsiva007
@vvsiva007 2 ай бұрын
So, by 2038, it will be YourSQL, no more mySQL 😂
@raghu8705
@raghu8705 2 ай бұрын
Hey planetscale, Thanks for the vitess mysq series. If there is any document which are still basic, would be helpful
@PlanetScale
@PlanetScale 2 ай бұрын
Are you referring to our Learn Vitess or MySQL for Developers? Those can both be found here: planetscale.com/learn/courses/vitess planetscale.com/learn/courses/mysql-for-developers Are you looking for an additional resource to learn more than these provide?
@raghu8705
@raghu8705 2 ай бұрын
@@PlanetScale yes, Im looking for resources more than this. The above resources uses vitess /mysql examples. Would be great if I get any docs or videos where they even write those example scripts, explanations of them,.
@PlanetScale
@PlanetScale 2 ай бұрын
@@raghu8705 For Vitess, here's a few resources you can try: The official docs: vitess.io/docs/ Our Vitess page: planetscale.com/vitess (also has links to other pages with more info) You can search around for Vitess on youtube, and there's a number of conference talks. For example: kzbin.info/www/bejne/fmWlZq2Cd8t6hJo
@fabiojonathanarifin1
@fabiojonathanarifin1 2 ай бұрын
a very easy to understand explanation! thank you
@Runval2701
@Runval2701 2 ай бұрын
6:09 not understand ? somebody can explain how does select count(1) from todos will execute or work ?
@kqvanity
@kqvanity 2 ай бұрын
Come in just about time. I wanted to obtain the rows count before, and my approach was to get the ids of the last few rows haha
@kqvanity
@kqvanity 2 ай бұрын
Your style of teaching is very unique!
@mingxiu-ee6px
@mingxiu-ee6px 3 ай бұрын
I am learning to use vitess, which is very helpful to us.
@mnouman1552
@mnouman1552 3 ай бұрын
Could you please explain what do you mean by "Scrolling and Throwing away that offset data". I believe you are talking at memory level things. It would be so helpful if you explain and show how pagination works at disk level,how pagination queries select data from disk partitiones stored in Binary tree format.
@vineetdev2009
@vineetdev2009 3 ай бұрын
How to do join operations after vertical sharding?
@PlanetScale
@PlanetScale 3 ай бұрын
You're probably referring to cross-shard (or cross-keyspace) queries. There's a blog post from Square that talks about these with Vitess that you might find interesting: developer.squareup.com/blog/cross-shard-queries-lookup-tables/
@vanshsharma4528
@vanshsharma4528 3 ай бұрын
how do we get the hostname
@PlanetScale
@PlanetScale 3 ай бұрын
What database are you looking for the hostname for? Your PlanetScale database? One elsewhere? If you are currently trying to import a DB into PlanetScale, I recommend opening a support ticket: planetscale.com/contact
@Sweetironman
@Sweetironman 3 ай бұрын
I have a question for you. I'm working with a table which has more than 3 billion rows and each month new 20-25 million rows are being added. And we have created 5 indexes for all efficient searching but when we access data for even a month it takes too long. And the recent data of the week access is good, the data is loaded fast ( here we also just access recent data for that month) but when our recent record touches more than 3-4 million rows after 4-5 days the quary again becomes very very slow? I'm thinking of creating a separate table for each year for balancing the load but I'm not able to understand why for 4-5 day of the start of the month it's working good but then after 4-5 million new rows it's becomes slow again. It's not making sense to me? Any suggestions will be really appreciated.
@PlanetScale
@PlanetScale 3 ай бұрын
Interesting scenario! Hard to say for sure without more details, but a few things could be happening here: (1) The queries fetching only recent results are able to mostly hit data that is already in memory. The ones that fetch larger and older data sets might have significantly more I/O, leading to drastically slower query times. (2) You said you created 5 indexes ... are you confident they are being used appropriately? If you are using planetscale you can use Insights to figure this out. If not, you can try running some EXPLAINs to see whats going on. You might find this useful for investigating: planetscale.com/blog/identifying-and-profiling-problematic-mysql-queries
@raghu8705
@raghu8705 3 ай бұрын
Hey, thanks for the walkthrough. Those anomalies detects similar latency issues. What’s different between the sort option in ran query table vs anomalies? Also does the anomalies detects some SQLi or any of similar things?
@PlanetScale
@PlanetScale 3 ай бұрын
In short, anomalies happen when there is a spike in queries executing *slower* than the 97.7th percentile for the query pattern. A query could have long latency but not trigger an anomaly (for example, if that query typically takes a long time). You can read more about anomalies here: planetscale.com/docs/concepts/anomalies
@raghu8705
@raghu8705 3 ай бұрын
@@PlanetScale but this can be seen inside the query table sort latency feature right?
@HollyGuevaraPS
@HollyGuevaraPS 3 ай бұрын
@@raghu8705 Yeah! You would see evidence of an anomaly in that tab as well. BUT not all query latency necessarily is an anomaly. When we call something an Anomaly, we are basically saying your database is not healthy. There's something abnormal going on that you should look into. Versus if you're looking through the query latency metrics in that Insights table, there may be some high query latency that yes may not be great, but it's not unusual and doesn't mean there's an issue with your database.
@jizhang75
@jizhang75 3 ай бұрын
you video tutorial has been always informative, and instructive, really really appriciate
@gokukakarot6323
@gokukakarot6323 3 ай бұрын
use configs can be bitmaps