Re: [Nagios-users] NDOUtils mysql question?

2009-08-07 Thread Andrew Davis
My apologies... didn't mean to come across as rude. I figured that others may have tools like Cacti along with NDOutils on the same server and thus might find that they have multiple database types as well... hence my email to the Nagios list instead of the mysql list. In my case, I learned the

Re: [Nagios-users] NDOUtils mysql question?

2009-08-07 Thread Marc Powell
On Aug 7, 2009, at 3:15 PM, Andrew Davis wrote: > Really? You sure about that? I'm pretty confident that mysql > supports different types of databases (myISAM and InnoDB as two of > them) as well as different table types within a database. If you really wanted to be sure about that and not q

Re: [Nagios-users] NDOUtils mysql question?

2009-08-07 Thread Andrew Davis
Really? You sure about that? I'm pretty confident that mysql supports different types of databases (myISAM and InnoDB as two of them) as well as different table types within a database. Your reply did help, though, as when I ran it for the default mysql DB, I was reminded of the phrase "engine"

Re: [Nagios-users] NDOUtils mysql question?

2009-08-07 Thread David Rosenstrauch
On 08/07/2009 03:03 PM, Andrew Davis wrote: > Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses > an InnoDB database, while NDOUtils uses myISAM. The two are backed up > differently (example: mysqlhotcopy doesn't working on InnoDB databases). > Does anyone know what mysql c

Re: [Nagios-users] NDOUtils mysql question?

2009-08-07 Thread Andrew Davis
Okay, perhaps I inverted it then. My build of Cacti stores everything to a mysql DB, though it could admittedly be a myISAM DB with NDOutils being of the InnoDB type. However it works out, I'm pretty confident that I have two database types on one mysql server and I'm trying to figure out how t

Re: [Nagios-users] NDOUtils mysql question?

2009-08-07 Thread shadih rahman
I would double check these information. Cacti runs on rrd( round robin database). I have innodb for my ndoutils 1.47b. On Fri, Aug 7, 2009 at 3:03 PM, Andrew Davis wrote: > Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses an > InnoDB database, while NDOUtils uses myISAM

Re: [Nagios-users] NDOUtils mysql question?

2009-08-07 Thread Marc Powell
On Aug 7, 2009, at 2:03 PM, Andrew Davis wrote: > Our Nagios server also has Cacti on it. I'm pretty sure that Cacti > uses an InnoDB database, while NDOUtils uses myISAM. The two are > backed up differently (example: mysqlhotcopy doesn't working on > InnoDB databases). Does anyone know wha

[Nagios-users] NDOUtils mysql question?

2009-08-07 Thread Andrew Davis
Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses an InnoDB database, while NDOUtils uses myISAM. The two are backed up differently (example: mysqlhotcopy doesn't working on InnoDB databases). Does anyone know what mysql command you run to determine which type of DB is use