Skip to main content
Unix & Linux

Return to Question

edited tags
Link
PersianGulf
PersianGulf
  • 11.3k
  • 11
  • 56
  • 83
Tweeted twitter.com/#!/StackUnix/status/529369590057283584
deleted 11 characters in body
Source Link
Ramesh
Ramesh
  • 40.6k
  • 45
  • 149
  • 222

I have a server that is running mysql and it's using a lot of memory. I run:

mysql > show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | Aborted_connects | 4 | | Connections | 98609 | | Max_used_connections | 20 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 1 | +--------------------------+-------+

But then if I run 'show processlist' as the root user I don't see anything. I've tried google for this but It always comes up with stuff related to connection errors. IfCould someone could please just explain why I can't see the connections and how to actually go in and see them I would?

I have a server that is running mysql and it's using a lot of memory. I run:

mysql > show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | Aborted_connects | 4 | | Connections | 98609 | | Max_used_connections | 20 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 1 | +--------------------------+-------+

But then if I run 'show processlist' as the root user I don't see anything. I've tried google for this but It always comes up with stuff related to connection errors. If someone could please just explain why I can't see the connections and how to actually go in and see them I would

I have a server that is running mysql and it's using a lot of memory. I run:

mysql > show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | Aborted_connects | 4 | | Connections | 98609 | | Max_used_connections | 20 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 1 | +--------------------------+-------+

But then if I run 'show processlist' as the root user I don't see anything. I've tried google for this but It always comes up with stuff related to connection errors. Could someone please just explain why I can't see the connections and how to actually go in and see them?

Source Link
Cody
Cody
  • 245
  • 1
  • 10

MySQL has over 95,000 connections but processlist is empty?

I have a server that is running mysql and it's using a lot of memory. I run:

mysql > show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | Aborted_connects | 4 | | Connections | 98609 | | Max_used_connections | 20 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 1 | +--------------------------+-------+

But then if I run 'show processlist' as the root user I don't see anything. I've tried google for this but It always comes up with stuff related to connection errors. If someone could please just explain why I can't see the connections and how to actually go in and see them I would