Different Types of MySQL variables configuration methods | SESSION | GLOBAL | SET PERSIST
Vložit
- čas přidán 15. 09. 2021
- In this Video, I have tried to explain the various methods of MySQL variables configuration methods.
-- Session - set session
-- Global - set global
-- PERSIST - set persist
1) set persist
2) set persist_only
-- my.cnf
-- Command line
If you have any questions or suggestions please add it in comment section. Thanks!
Thanks Sri.
hey Sri, how about the rollback plan? 💥
Again, nice video!
Very useful
Hi, thanks great explanation , i have 2 questions if i use persist then on mysql restart, values will be picked from my.cnf or mysqld-auto.cnf or both , and what script alias "fg" you are using to connect
fg is used to get the recent background running process ro forground.
He is exiting mysql prompt by doing Ctrl+Z(its gng to background) now again to get it run fg is used. You can run jobs in linux terminal to get what are all jobs running in background and do fg {job number} to get a particular job to foreground