A quick check of a MyODBC connection made from Access 2000 to a MySQL
database (with 5 tables open) shows as a single process in WinMySQLAdmin...
the total connections show up as 3 (including the WinMySQLAdmin connection,
I assume). Bumping that up to ten open tables and one open query increases
How to know how many sessions are currently open against a MySQL database ?
Gustavo,
MySQL manual 7.28 SHOW Syntax
Regards,
=dn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
]
Consulting: [EMAIL PROTECTED]
Technical: [EMAIL PROTECTED]
Web related: [EMAIL PROTECTED]
General: [EMAIL PROTECTED]
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Ing. Gustavo Edelstein [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 1:52 PM
Subject: Re
On Wed, 24 Oct 2001 14:36:45 -0300, Ing. Gustavo Edelstein
[EMAIL PROTECTED] wrote:
Thanks for your answer, but I need to know the names of the users currently
logged in the database.
Regards,
check your log files, normally found in the DATADIR, this will tell you who's
doing what and when.
Ing. Gustavo Edelstein wrote:
Thanks for your answer, but I need to know the names of the users currently
logged in the database.
Regards,
SHOW will do that as will 'mysqladmin processlist'.
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
b.
:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 1:37 PM
To: DL Neil; [EMAIL PROTECTED]
Subject: Re: Sessions
Thanks for your answer, but I need to know the names of the users currently
logged in the database.
Regards,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A
How to know how many sessions are currently open against a MySQL
database ?
MySQL manual 7.28 SHOW Syntax
Thanks for your answer, but I need to know the names of the users
currently
logged in the database.
Regards,
And he told you exactly where to find it. Try SHOW PROCESSLIST
Thanks,
Will try that out.
Adrian
On Thu, 31 May 2001, g_gosho wrote:
You can try this link: http://www.bonev.com/s
there is PHP session handling librarary and documentation how to use it
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: php general list
You can try this link: http://www.bonev.com/s
there is PHP session handling librarary and documentation how to use it
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: php general list [EMAIL PROTECTED]
Cc: Mysql Mailing List [EMAIL PROTECTED]
Sent: Wednesday, May 30,