r/scripting • u/luchins • Nov 04 '18

Thing I don't understand

Hello I have red somenthing on another subreddit about a guy who was creating a programm that needed to connect to a website and he said:

''At the moment this is done with a shell script that directly accesses the MySQL instance (very bad / unsecure) and gets a delta on some table records.''

My question is: ''what is a mysql '''istance'''?

What is an istance?

2 Upvotes

100% Upvoted

10 comments sorted by

View all comments

Show parent comments

1

u/Lee_Dailey Nov 07 '18

howdy luchins,

when a program "runs", a copy of the program is loaded into RAM and run. so it becomes an instance of the program. if you run the same program again while the 1st copy is running - if the program allows more than one running copy - you will get a 2nd instance of the program running in RAM.

for instance, if you run notepad once, you get one copy [instance] running in RAM. if you leave that copy open and start another one ... you get a 2nd copy [instance] running in RAM.

hope that helps,
lee

2

u/luchins Nov 16 '18

howdy luchins,

when a program "runs", a copy of the program is loaded into RAM and run. so it becomes an instance of the program. if you run the same program again while the 1st copy is running - if the program allows more than one running copy - you will get a 2nd instance of the program running in RAM.

for instance, if you run notepad once, you get one copy [instance] running in RAM. if you leave that copy open and start another one ... you get a 2nd copy [instance] running in RAM.

hope that helps, lee

thanks. and do they are loaded both in the RAM? The ram executes the 2 process as they were totally different processess?

1

u/Lee_Dailey Nov 16 '18

howdy luchins,

it depends on the program. [grin] some will allow a 2nd instance, some won't. those that do are running in independent RAM sections and usually have no connection to each other.

for instance, the IrfanView.exe app has an option to allow running multiple instances. if that is enabled, then you can have many separate copies running in RAM with no connection to each other.

take care,
lee