Empty Process List

[jamesv]

I'm trailing a new install of MONyog 1.11 and so far have had a great impression of this. Unfortunately everything but the process list works:

Msg: “Empty Processlist. Consider changing Processlist filter.Change Filter”

I've looked at the MONyog.log and there are no errors except for a…

“[1.11] [2007-10-30 12:20:31] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away”

…but I don't think this is it.

Any ideas?

[peterlaursen]

1) Please try to execute SHOW FULL PROCESLIST as the same user. If you have SQLyog you can use the tools .. show menu.

2) What are the privileges of the user? Does he have PROCESS or SUPER privilege? (refer to the docs!)

3) What is the PROCESSLIST filter currently in action?

[jamesv]

peterlaursen wrote on Oct 30 2007, 12:19 PM:

1) Please try to execute SHOW FULL PROCESLIST as the same user. If you have SQLyog you can use the tools .. show menu.

2) What are the privileges of the user? Does he have PROCESS or SUPER privilege? (refer to the docs!)

3) What is the PROCESSLIST filter currently in action?

Thanks for your help!

I have to run 'SHOW FULL PROCESSLISTG' at mysql command line to get anything – when I do I get:

[codebox]mysql> SHOW FULL PROCESSLISTG

*************************** 1. row ***************************

Id: 9634

User: MONyog

Host: localhost

db: NULL

Command: Query

Time: 0

State: NULL

Info: SHOW FULL PROCESSLIST

*************************** 2. row ***************************

Id: 9667

User: MONyog

Host: localhost:46985

db: NULL

Command: Sleep

Time: 11

State:

Info: NULL

2 rows in set (0.00 sec)[/codebox]

2) the user has been given both Super and Process privileged.

3) The process filter is the default one.

[peterlaursen]

The only processes you get returned are processes of user 'MONyog'. And those are filtered away .. !

so either there are no processes of other users or the privileges don't work as expected!

What does

Code:

SHOW GRANTS for 'MONyog'@'localhost'

return?

[jamesv]

peterlaursen wrote on Oct 30 2007, 09:41 PM:

The only processes you get returned are processes of user 'MONyog'. And those are filtered away .. !

so either there are no processes of other users or the privileges don't work as expected!

What does

Code:

SHOW GRANTS for 'MONyog'@'localhost'

return?

Thanks for this – the grants looked fine but I moved it to the root user just to be sure and still getting the same thing.

Looking at the MONyog.log file I get:

[root@lightershade-ds-03 MONyog]# tail -f MONyog.log

[1.11] [2007-10-30 22:46:52] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)

[1.11] [2007-10-30 22:46:54] ./MONyog/processlistmgr.cpp(235) ErrCode:2003 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)

[1.11] [2007-10-30 22:46:54] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)

[1.11] [2007-10-30 22:46:55] ./MONyog/processlistmgr.cpp(235) ErrCode:2003 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)

[1.11] [2007-10-30 22:46:55] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)

[1.11] [2007-10-30 22:46:56] ./MONyog/processlistmgr.cpp(235) ErrCode:2003 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)

[1.11] [2007-10-30 22:46:56] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)

[1.11] [2007-10-30 22:48:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away

[1.11] [2007-10-30 22:48:53] ./lib/webyog/src/ysftp.cpp(154) ErrCode:-1 ErrMsg:Could not open file '/var/run/mysqld/mysqld.pid': sftp server : Permission denied

[1.11] [2007-10-30 22:48:53] ./MONyog/populatesystem.cpp(139) ErrCode:-1 ErrMsg:GetMysqlPid

[1.11] [2007-10-30 22:50:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away

[1.11] [2007-10-30 22:52:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away

[1.11] [2007-10-30 22:54:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away

[1.11] [2007-10-30 22:56:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away

[1.11] [2007-10-30 22:58:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away

[1.11] [2007-10-30 23:00:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away

The break is when I set global read permissions so that MONyog can see the mysqld.pid file and read it.

I still get no processlist though 🙁

[Manoj]

Hi,

By default MONyog will filter ''SHOW FULL PROCESSLIST' for queries and queries which are not like ''SHOW FULL PROCESSLIST'. You can change this by using 'Change Filter' option. If you click 'Change Filter' you can see the filter is set to

SELECT *

FROM processlist

WHERE Command = 'Query'

AND info <> 'SHOW FULL PROCESSLIST'

ORDER BY time DESC

you can replace this filter with the fiollowing

SELECT *

FROM processlist

ORDER BY time DESC

it will display all threads.

[Author]

Posts