Different Types of MySQL variables configuration methods | SESSION | GLOBAL | SET PERSIST

Sdílet
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!

Komentáře • 5

  • @DeveloperTharun
    @DeveloperTharun Před 2 lety +1

    Thanks Sri.

  • @matteraf
    @matteraf Před 2 lety +1

    hey Sri, how about the rollback plan? 💥
    Again, nice video!

  • @viewersthunai2313
    @viewersthunai2313 Před 2 lety

    Very useful

  • @mayanks6728
    @mayanks6728 Před rokem

    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

    • @ramesh___e
      @ramesh___e Před rokem

      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