NDOUtils mysql question?

Andrew Davis nccomp at gmail.com
Fri Aug 7 22:15:01 CEST 2009


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" in the output. Thus, now I see:

mysql -u root -p -e "show table status" mysql
Enter password:
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------------------------------------------------+
| Name                      | Engine | Version | Row_format | Rows | 
Avg_row_length | Data_length | Max_data_length    | Index_length | 
Data_free | Auto_increment | Create_time         | Update_time         | 
Check_time          | Collation       | Checksum | Create_options | 
Comment                                           |
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------------------------------------------------+
| columns_priv              | MyISAM |      10 | Fixed      |    0 
|              0 |           0 | 227994731135631359 |         1024 
|         0 |           NULL | 2009-02-12 10:21:04 | 2009-02-12 10:21:04 
| NULL                | utf8_bin        |     NULL |                | 
Column privileges                         

mysql> show engines;
+------------+---------+----------------------------------------------------------------+
| Engine     | Support | 
Comment                                                        |
+------------+---------+----------------------------------------------------------------+
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great 
performance         |
| MEMORY     | YES     | Hash based, stored in memory, useful for 
temporary tables      |
| InnoDB     | YES     | Supports transactions, row-level locking, and 
foreign keys     |
| BerkeleyDB | YES     | Supports transactions and page-level 
locking                   |
| BLACKHOLE  | NO      | /dev/null storage engine (anything you write to 
it disappears) |
| EXAMPLE    | NO      | Example storage 
engine                                         |
| ARCHIVE    | NO      | Archive storage 
engine                                         |
| CSV        | NO      | CSV storage 
engine                                             |
| ndbcluster | NO      | Clustered, fault-tolerant, memory-based 
tables                 |
| FEDERATED  | NO      | Federated MySQL storage 
engine                                 |
| MRG_MYISAM | YES     | Collection of identical MyISAM 
tables                          |
| ISAM       | NO      | Obsolete storage 
engine                                        |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)

An "engine" is another way of saying "database type". This is distinct 
from a table type. Of course, the above only shows me the engines that 
are already compiled in and available for use, but hopefully I can go 
forward from here... I'm thinking I can do a "show databases;", then 
pump that into a "for x in ..." to show the engine type for each DB.

Thanks for the assist...

  A. Davis
  Email:     nccomp at gmail.com

  "There is no limit to what a man can accomplish
   if he doesn't care who gets the credit." - Ronald Reagan



Marc Powell wrote:
> 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 what mysql command you run to  
>> determine which type of DB is used for various databases, especially  
>> considering you can run multiple types at once? I know I can use  
>> "mysqlshow" or the "show databases;" options to show the databases  
>> themselves, but it doesn't list the DB type.
>>     
>
> It's not a database level option. It's table level.
>
>   
>> Using mysqlshow with a -t and a DB name shows the table types, but  
>> again, not the database types. I'm sort of stuck on this. I want to  
>> make sure I know what DB types I'm dealing with so I can ensure I'm  
>> backing them up properly. Google searches aren't helping... the  
>> results all go back to the "mysql versus innodb" debate...
>>     
>
> My Google-fu seems to be more powerful.
>
> mysql -u Username -p -h database.hostname.com -e "show table status"  
> databasename.
>
> --
> Marc
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with 
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090807/7369270e/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null


More information about the Users mailing list