how to check mysql services?

[ivia]

Any idea how to check mysql services in CACTi?

[fmangeant]

Hi

if you want to graph MySQL usage, nice templates are available here : http://forums.cacti.net/viewtopic.php?t=11010

[ivia]

Hi

if you want to graph MySQL usage, nice templates are available here : http://forums.cacti.net/viewtopic.php?t=11010

I need to know if mysql is still running or not cos rrd stopped updating even though its still polling periodically.

issue indicated at http://forums.cacti.net/viewtopic.php?t=15379

[Matt`G]

Depends on your distribution of linux. Most have init scripts that allow you to check the status of a running service with:

Code: Select all

/etc/init.d/mysql status

Or, you could always check manually for a running process:

Code: Select all

ps auxw | grep mysql

Finally, you could always try to manually connect to your mysql server from your localhost using the user/pw you created when you set up cacti:

Code: Select all

mysql -u youruser -p

[Matt`G]

As a matter of fact, if the problem is that the graphs have stopped graphing... you may want to get into the local mysql console and run this query:

Code: Select all

select count(*) from poller_output;

If it's some huge number, you can run the following query to try to get it working again:

Code: Select all

truncate table poller_output;

Note that the truncate command is dumping everything in that table, and I believe that you'll be losing data for your graphs... so if it starts graphing again you'll have a blank spot in the graph. However, I've had good luck getting my graphs to start again by doing this. So, yeah, use at your own risk.. but if your cacti server is in development anyway, no harm no foul right?

[ivia]

As a matter of fact, if the problem is that the graphs have stopped graphing... you may want to get into the local mysql console and run this query:

Code: Select all

select count(*) from poller_output;

If it's some huge number, you can run the following query to try to get it working again:

Code: Select all

truncate table poller_output

Note that the truncate command is dumping everything in that table, and I believe that you'll be losing data for your graphs... so if it starts graphing again you'll have a blank spot in the graph. However, I've had good luck getting my graphs to start again by doing this. So, yeah, use at your own risk.. but if your cacti server is in development anyway, no harm no foul right?

How to start CACTI db if its not running?

[Matt`G]

How to start CACTI db if its not running?

If mysql is running, the cacti DB is running. If mysql is not running, try starting it with:

Code: Select all

/etc/init.d/mysql start

This should work on most linux distributions.

BTW, I should have been more specific in my last post... Once you log into MySQL console as suggested a couple posts up, you need to issue this command:

Code: Select all

use cacti;

That will allow you to work right with the cacti database. After this, then you can do the other commands I suggested. Also, I forgot the semicolon at the end of the truncate line... I'll edit the post and put it in.

[ivia]

As a matter of fact, if the problem is that the graphs have stopped graphing... you may want to get into the local mysql console and run this query:

Code: Select all

select count(*) from poller_output;

If it's some huge number, you can run the following query to try to get it working again:

Code: Select all

truncate table poller_output;

Note that the truncate command is dumping everything in that table, and I believe that you'll be losing data for your graphs... so if it starts graphing again you'll have a blank spot in the graph. However, I've had good luck getting my graphs to start again by doing this. So, yeah, use at your own risk.. but if your cacti server is in development anyway, no harm no foul right?

Thanks to all, cacti is working now by 'truncate table poller_output'