MySQL concepts: session vs connection

mysql session connection terminology
Xiaofeng Tang picture Xiaofeng Tang · Jan 10, 2012 · Viewed 9.9k times · Source

I'm a bit confused by MySQL concepts: session vs connection.

When talking about connecting to MySQL, we use connection terminology, connection pool, etc.

However in the MySQL online doc: http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html it talks about session variables.

They are quite similar. How to distinguish them?

Thanks in advance.

Answer

newtover picture newtover · Jan 10, 2012

A session is just a result of a successful connection. Any MySQL client requires some connection settings to establish a connection and after the connection has been established it acquires a connection id (thread id) and some context which is called session.

Related questions

What is the length of a PHP session id string?

I'm making a table in a MySQL database to save some session data, including session_id. What should be the length of the VARCHAR to store the session_id string?

Read More
How I can set a session in codeigniter 3 database?

I'm using the new version(3.0.0). of CodeIgniter and I have a new problem, my sessions doesn't work. I mean, the code in the controller is correct because there are not errors but, when I try to print a PHP variable …

Read More
Write session start on 1 page or all pages?

All the tutorials say to put session start. They don't say if that should be in all pages on the website, or some, or only 1. And if it's only 1 page, does it have to be the main page? Or a …

Read More