What is Percona XtraBackup?
0:51
What is pgvector in PostgreSQL?
1:38
SQL Explained in 86 Seconds
1:26
4 ай бұрын
Why Migrate to MariaDB?
0:33
5 ай бұрын
What are Catalogs in MariaDB?
0:29
Пікірлер
@kvelez
@kvelez 19 күн бұрын
Thanks, please do more on MariaDB Xpand, Galera and Columnstore.
@snowiblind
@snowiblind Ай бұрын
bro wasted no time
@DatabaseDive
@DatabaseDive Ай бұрын
Exactly! :D
@bimithmaramveettill
@bimithmaramveettill 2 ай бұрын
In which database we need to run this query?
@DatabaseDive
@DatabaseDive 2 ай бұрын
These parameters need to be optimized within MySQL or any of its flavors - Percona Server or MariaDB Server. Tune these parameters once you open my.cnf (Linux) or my.ini (Windows): the exact location of the file may vary, but it's generally found in /var/lib/mysql/my.cnf.
@tomaskiss2723
@tomaskiss2723 2 ай бұрын
I use ubuntu 22 and after trying to put into secure_file_priv=/home/my_username/Desktop it cannot restart with: sudo systemctl restart mysql.service and prints following error: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details. I have no clue what to do, did anyone come across this? Thanks for help
@DerBarde2012
@DerBarde2012 3 ай бұрын
wtf ever heard of SmartArt? No1 can read this
@KrManishPatelofficial
@KrManishPatelofficial 3 ай бұрын
Is it working for live hosted website?
@DatabaseDive
@DatabaseDive 2 ай бұрын
These tips work for local and live databases alike.
@lawrencevelez3014
@lawrencevelez3014 3 ай бұрын
'promo sm' ☀️
@jorgevalencia6926
@jorgevalencia6926 3 ай бұрын
thanks!
@DatabaseDive
@DatabaseDive 3 ай бұрын
You're welcome!
@sun1only1
@sun1only1 4 ай бұрын
Rate of speech is too high.You need to speak slowly and explain more about the features,thanks.
@DatabaseDive
@DatabaseDive 4 ай бұрын
Already improving that, thank you!
@marcinbadtke
@marcinbadtke 4 ай бұрын
Thank you. Application that uses a database is the weakest point of computer system. What advices do you have to secure it?
@DatabaseDive
@DatabaseDive 4 ай бұрын
Each application is different, but minimizing the attack surface and following the recent release of OWASP Top 10 should be a good starting point 🙂
@bhaskardabhi
@bhaskardabhi 5 ай бұрын
I can even read this on internet without fast forward. Shit video
@davionalexander147
@davionalexander147 5 ай бұрын
hello, if I may add some harmless suggestions. I believe you should lower the music and talk just a tab bit slower. I say this in the most (Not disrespectful way) while your info is good your accent is kind of thick so hard to understand when you speak quickly. I know i could just move on to somebody else video, but i say this because I like your videos and want to support!
@DatabaseDive
@DatabaseDive 5 ай бұрын
Yeah, I'm keeping that in mind! Thanks :D
@sudikshabhatt689
@sudikshabhatt689 5 ай бұрын
I am using MYSQL workbench and when I am checking secure file privacy it’s showing null
@DatabaseDive
@DatabaseDive 5 ай бұрын
Are you sure you're checking for "secure-file-priv" instead of something else? Might be a typo.
@saurabhsalunkhe3939
@saurabhsalunkhe3939 6 ай бұрын
Thank you creator ❤ This was very helpful.
@DatabaseDive
@DatabaseDive 5 ай бұрын
You're very welcome!
@nadeemtalib6940
@nadeemtalib6940 7 ай бұрын
❤❤❤
@habibbialikafe339
@habibbialikafe339 8 ай бұрын
MySQL Workbench doesn't recognize secure_file_priv as a variable, and when I try to move my csv to the secure_file_priv location, I still cannot load the data.
@DatabaseDive
@DatabaseDive 8 ай бұрын
What SQL query are you using?
@joseprathesh
@joseprathesh 8 ай бұрын
Use AI voice to read this aloud and use a computer based background image bro...I'm sure all your videos will blow up. Btw this video really helped me I have finals tomorrow
@DatabaseDive
@DatabaseDive 8 ай бұрын
Glad to hear that - hope your finals went well!
@Thebetadeveloper
@Thebetadeveloper 9 ай бұрын
Would be nice to have a voiceover. Also, some visual examples of DB tables, example of dirty read vs non-dirty read would probably be beneficial for audience retention and general quality of provided information. Same for every other video. 😎
@DatabaseDive
@DatabaseDive 8 ай бұрын
Thanks!
@Thebetadeveloper
@Thebetadeveloper 9 ай бұрын
Great video. Takeaway: for large amounts of unstructured data seems NoSQL is a better option for handling big data and dynamic querying.
@Thebetadeveloper
@Thebetadeveloper 9 ай бұрын
Great and short overview. Good format. Thanks
@somethingelse401
@somethingelse401 10 ай бұрын
I like it. Short, sweet, and right to the point! If I had one recommendation, slow down each sentence so the viewer such as myself can take it in easier.
@DatabaseDive
@DatabaseDive 10 ай бұрын
Thank you! I'm keeping that in mind :D
@ecruz1542
@ecruz1542 Жыл бұрын
Great explanations! I had to slow the speed of the video down to 0.5 to keep up - hope that helps others.
@DatabaseDive
@DatabaseDive Жыл бұрын
Thanks, I'll keep that in mind for the next one!
@ecruz1542
@ecruz1542 Жыл бұрын
Thanks for putting this out there. Appreciate that it was done in 40 seconds or less!
@DatabaseDive
@DatabaseDive 11 ай бұрын
Glad it was helpful! Check out other videos too! :-)
@husorpandiangan2488
@husorpandiangan2488 Жыл бұрын
can u show tutorial about physical bacup ?
@DatabaseDive
@DatabaseDive Жыл бұрын
Of course! Be on the lookout for a video 🙂
@Robin-ju3wc
@Robin-ju3wc Жыл бұрын
offset should be 2 right? for finding 3rd highest
@DatabaseDive
@DatabaseDive Жыл бұрын
Yup, that's correct.
@DatabaseDive
@DatabaseDive Жыл бұрын
Update: we won't face an error if we use collate queries mentioned in this video. Instead, a warning will be written to the log.