Description

Hello, anyone knows how to get all connection id (thread id) in server(MySQL) using Laravel? I have a task to get all concurrent connections. The implementation will be like this. When a user login into web/system, I will get his connection id (thread id) and store in in login table. In MySQL there's a syntax "select connection_id()" to get the specific or active connection of that user. Then, to list all connection is "show full processlist". What I've done so far? In my log-in controller I make query using DB query DB::select('select connection_id()'); but the problem is that when i checked it in my server the id that i queried is not in the list. I hope someone has idea. Thanks in advance.

0 1

Comments ({{ comments.length }})

{{ comment.comment }}

{{ comment.created_at_ago }}
© 2018 Larastream.com.