A.7 Monitoring Commands and Tips

A.7.1 SQL Database Monitoring Commands

Table A-1 SQL Monitoring Commands

To Find

Use This

MySQL DB size =

IMPORTANT:This is an important query for tuning the MySQL appliance.

  1. First, make sure that the total RAM is set to about 8% of the database size.

  2. Then set the innodb_buffer_pool_size to between 60 and 75% of the total RAM.

SELECT sum(round(((data_length + index_length) / 1024 / 1024 / 1024), 2))  as "Size in GB" FROM information_schema.TABLES  WHERE table_schema = "filr";

Number of Files =

select count(*) from SS_Attachments;

NOTE:This query will take some time. Divide the output number by 2.

Number of Folders =

select count(*) from SS_Forums;

Number of Net Folders (including Home Folders) =

select count(*) from SS_NetFolderConfig;

Number of Net Folder Servers =

Select count(*) from SS_ResourceDriver;

Number of users =

select count(*) from SS_Principals where type='user';

Number of Groups =

select count(*) from SS_Principals where type='group';

A.7.2 Monitoring Net Folder Synchronization

  • If you are running a re-index you can compare the numbers churning in the Administration Console > Search Index > Re-Index UI with the following DB query:

    select count(*) from SS_Forums;

  • During Net Folder synchronization, keep watch on the Search appliance's Ganglia graphs and keep an eye on /vastorage and /var during the sync.

  • If you are running a Net Folder sync you can compare the numbers in the Port 8443: Administration Console > Net Folders > Sync Status icon (click the churning wheel) with the following DB query:

    select count(*) from SS_FolderEntries;

A.7.3 Monitoring the Impact of Your Tuning Changes to the Overall System

  • Monitor all Filrsearch, MySQL and Filr appliances using top, df -h, du -h (on specific directories), through Ganglia and using the DB queries listed above.

  • There are 3rd party tools that can be used to specifically monitor the JVM, such as jvmtop.

  • Watch the top and Ganglia metrics.

    As you study the Ganglia graphs, consider the sequence of events that have occurred on the system, such as synchronization and indexing processes.

    When you read a Ganglia chart, make sure you understand the units represented. For example, look at the memory graphs in Figure A-1 that were retrieved from the example system.

    The maximum that the chart is showing is not 15 MB but rather 15 M x KIB. In other words, 15,000,000 KB or 15 GB. The units are shown to the left of the Y-axis. The minimum is about 200 MB (not 6 MB).