Thanks, please do more on MariaDB Xpand, Galera and Columnstore.
@snowiblindАй бұрын
bro wasted no time
@DatabaseDiveАй бұрын
Exactly! :D
@bimithmaramveettill2 ай бұрын
In which database we need to run this query?
@DatabaseDive2 ай бұрын
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.
@tomaskiss27232 ай бұрын
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
@DerBarde20123 ай бұрын
wtf ever heard of SmartArt? No1 can read this
@KrManishPatelofficial3 ай бұрын
Is it working for live hosted website?
@DatabaseDive2 ай бұрын
These tips work for local and live databases alike.
@lawrencevelez30143 ай бұрын
'promo sm' ☀️
@jorgevalencia69263 ай бұрын
thanks!
@DatabaseDive3 ай бұрын
You're welcome!
@sun1only14 ай бұрын
Rate of speech is too high.You need to speak slowly and explain more about the features,thanks.
@DatabaseDive4 ай бұрын
Already improving that, thank you!
@marcinbadtke4 ай бұрын
Thank you. Application that uses a database is the weakest point of computer system. What advices do you have to secure it?
@DatabaseDive4 ай бұрын
Each application is different, but minimizing the attack surface and following the recent release of OWASP Top 10 should be a good starting point 🙂
@bhaskardabhi5 ай бұрын
I can even read this on internet without fast forward. Shit video
@davionalexander1475 ай бұрын
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!
@DatabaseDive5 ай бұрын
Yeah, I'm keeping that in mind! Thanks :D
@sudikshabhatt6895 ай бұрын
I am using MYSQL workbench and when I am checking secure file privacy it’s showing null
@DatabaseDive5 ай бұрын
Are you sure you're checking for "secure-file-priv" instead of something else? Might be a typo.
@saurabhsalunkhe39396 ай бұрын
Thank you creator ❤ This was very helpful.
@DatabaseDive5 ай бұрын
You're very welcome!
@nadeemtalib69407 ай бұрын
❤❤❤
@habibbialikafe3398 ай бұрын
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.
@DatabaseDive8 ай бұрын
What SQL query are you using?
@joseprathesh8 ай бұрын
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
@DatabaseDive8 ай бұрын
Glad to hear that - hope your finals went well!
@Thebetadeveloper9 ай бұрын
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. 😎
@DatabaseDive8 ай бұрын
Thanks!
@Thebetadeveloper9 ай бұрын
Great video. Takeaway: for large amounts of unstructured data seems NoSQL is a better option for handling big data and dynamic querying.
@Thebetadeveloper9 ай бұрын
Great and short overview. Good format. Thanks
@somethingelse40110 ай бұрын
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.
@DatabaseDive10 ай бұрын
Thank you! I'm keeping that in mind :D
@ecruz1542 Жыл бұрын
Great explanations! I had to slow the speed of the video down to 0.5 to keep up - hope that helps others.
@DatabaseDive Жыл бұрын
Thanks, I'll keep that in mind for the next one!
@ecruz1542 Жыл бұрын
Thanks for putting this out there. Appreciate that it was done in 40 seconds or less!
@DatabaseDive11 ай бұрын
Glad it was helpful! Check out other videos too! :-)
@husorpandiangan2488 Жыл бұрын
can u show tutorial about physical bacup ?
@DatabaseDive Жыл бұрын
Of course! Be on the lookout for a video 🙂
@Robin-ju3wc Жыл бұрын
offset should be 2 right? for finding 3rd highest
@DatabaseDive Жыл бұрын
Yup, that's correct.
@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.