MySQL, Oracle | HP System Reporter Media Kit instruction

System Reporter 2.8

3PAR System Reporter User’s Guide

SQLite supports only limited database concurrency because it relies on a single file lock for the entire database. The sampling process needs exclusive access to the database when inserting new samples. If the database is very large or if there are a large number of concurrent web requests, the sampler or the Web server can time out. Furthermore, database compaction (see

7.2.1Compacting Databases on page 7.3) cannot be done in parallel with sample insertion so there could be a large gap in samples during database compaction.

Sampling of multiple InServ Storage Servers is not supported with an SQLite database, either the MySQL or the Oracle database servers should be used instead.

For large databases (over about 1 GB) or a large number of concurrent Web users, either the MySQL® or the Oracle database servers should be used instead.

NOTE: The optionally licensed Adaptive Optimization feature is not supported with the SQLite database. Please consider another database if you plan on utilizing the storage optimization capabilities provided by Adaptive Optimization.

3.8.1.2 MySQL

A MySQL database server can be used with System reporter but is not included with it. You must purchase it separately. MySQL is a good choice for System reporter because it supports MyISAM tables. These tables do not support transactions (which are not required for System Reporter) and are consequently somewhat higher performance than Oracle for sample insertion and deletion.

3.8.1.3 Oracle

Beginning with the 2.4 release, System Reporter also supports an Oracle 11g database server but it is not included with it. You must purchase it separately. Compared with MySQL, Oracle is slightly slower and more resource intensive for sample insertion and deletion. However, Oracle is also a good choice for large and active System Reporter installation.

NOTE: System Reporter does not currently support Oracle RAC implementations.

NOTE: System Reporter requires the 32-bit Oracle client and does not support the 64-bit version.

Installing the Database Server

3.15

Image 51

HP System Reporter Media Kit, System Reporter E-Media Kit manual MySQL, Oracle

Contents

3PAR System Reporter 2.8 User’s Guide Revision Notice Oractcl Copyright and License Page Page Page Preamble Page Page No Warranty Table of Contents Xii Installation, Configuration, Update, and Removal Removing the System Reporter Components Xiii Creating Custom Reports Xiv Working with Excel Charts Interpreting Report Metrics Xvi Web Queries Xvii Xviii Performance Reports Xix Using Adaptive Optimization Xxi Database Schema Xxii Troubleshooting Xxiii Xxiv User Interfaces Audience For information about… Read the… Related Documentation Organization Typographical Conventions AdvisoriesTypeface Meaning Example ABCDabcd About 3PAR System Reporter Overview and Features Configuring System Reporter Policy Settings Choosing a Method for Accessing Reports Report Name Description Report Metrics Cross Reference Creating Customized Reports Node Cache Performance Formatting Reports for Presentation Accessing Report Data using Web Queries Customizing the Reporting FormatGenerating Email Alerts Analyzing and Optimizing Storage Utilization Using the Database Schema to Build Custom Reports Before You Begin Installation, Configuration, Update, and Removal System Reporter CD Contents Win32-x86-openssl Installer.exeSetup.exe Apache2.2.14 System Component Minimum Requirement System Requirements InServ Storage Server System Requirements Using the System Reporter Sizing Spreadsheet System Reporter Sizing Spreadsheet Using the System Reporter Sizing Spreadsheet InServ Storage Server and User Interface Components System Reporter Components System Reporter Components Installing the System Reporter Components Installing the System Reporter Components Section Installing the Web Server Installing the Database Server Choosing the Appropriate DatabaseSQLite Oracle MySQL Comment SQLite MySQL Oracle Installing and Setting Up the MySQL Database Optional Installing MySQL Server Select Multifunctional Database then click Next Configuring the MySQL Database Maxallowedpacket=32M Setting the maxallowedpacket parameter Mysql -u root -p Creating MySQL Users and Schema Setting Up the Oracle Database Optional Start the Oracle Database Configuration AssistantCreating an Oracle database Creating the Oracle Users for System Reporter Creating the Oracle Net Service Installing or Upgrading the System Reporter Tools Installing or Upgrading System Reporter Tools on Windows3PAR System Reporter Installer window opens Installing or Upgrading the System Reporter Tools Installing or Upgrading the System Reporter Tools Installing or Upgrading the System Reporter Tools Installing System Reporter Tools on Linux Rpm --install sampleloop-2.8-1.i386.rpm Etc/init.d/sampleloop start 3PAR System Reporter window appears Adding InServ Systems Setting File Permissions Optional Verifying InstallationClick Submit Query Installing the Excel Client Optional About Apache Http Server Authorization and Access Control Directory cgi-bin/3par-rpts AuthType Basic Removing the System Reporter Tools on Windows Removing the System Reporter Components Removing the MySQL Database Optional Removing the System Reporter Tools on Linux Drop user cliuser drop user webuser Getting Started Accessing the Main System Reporter Interface Connection Dialog Box System Reporter Main Window System Reporter Main Menu Window Getting Help Using the Object Selection Controls Simple Selection ListFiltered Multi-Selection Control Starting the System Reporter Excel Client Accessing the Optional Excel Client Setting the Security for Excel Setting the Security Level for Excel Security Warning for Enabling Macros in Excell Setting the Security Level Macro Security Alert for Excel Setting the Security Level for Excel Trust Center Screen Click Trust Center Click Trust Center Settings Connecting to the Web Server from the Excel Client Connection Parameters dialog box appears Figure Changing the Excel Client Server and Resetting the Workbook Accessing the Excel Client Query Log Resetting the WorkbookChanging the Web Server Deleting the Query Log Deleting Data SheetsDeleting Excel Sheets Deleting Menu Sheets Saving and Exiting the Excel Client 10.Security Alerts Multiple Issues Accessing and Creating Reports Quick Reports Window Accessing Quick Reports Scheduled Reports Window Accessing Scheduled Reports Creating Custom Reports Custom Reports Window Building the Report Menu Report Sample Resolution Common Performance Metrics on page 6.11 for Option Purpose Select Systems Select Domains Report Menu for Daily Vlun Performance Generating the Report Creating Custom Reports Creating Custom Reports Query Results Report Selection Controls Available by Report Report Time SelectionObject Selection 3PAR System Reporter User’s Guide Format Selection Report Selection Standard Report Types Report Type Purpose Versus TimeAt Time Report Type Purpose Histogram Histogram AtTime Versus Time Report Example Versus Time with Compare=System Report Example Group By SystemHost At Time Report Example Histogram Versus Time Report Example 10.Histogram At Time Report Example Select Summary Columns Compare Select PeakGroup By Pdid System Reporter Order By Order by the CPG that the LD belongs to Low Bucket High BucketSum End Buckets End Time Time SelectionReload After mins Begin/At Time Count Object Selection Select PDIDsInclude Chunklets Select Disk Types Select Cage IDs Include PDs in States Select Disk Speed Select Usr CPGs Select CPGs Select Snp CPGs Select RAID Types Select LDs Select LD Usage Select VVs CTRL+CLICK Select Prov Types Select Ports nsp Select VV Types Select Hosts Select Port Types Select To Nodes Select Nodes Format Selection Web interface only Select QueuesReport Information 11.Example of a Table Chart Types Stacked Vert Bars Stacked Bars Lines Stacked Area Vert Bars Bars Chart X Pixels Chart Y PixelsTime Labels Select Space Unit Time Format Working with Excel Charts Choosing a Chart TypeChoose Change Chart Type 18.Change Chart Type Menu for the Excel Client Refreshing Charts 19.Data Range Properties Shortcut Menu External Data Range Properties dialog box appears 20.External Data Range Properties Dialog Box Retaining Charts Exporting Executable Reports Customizing Excel Reports Adding Custom Columns to a Data Sheet Creating a Custom Chart =H53+J53+K53=IFN530,H53/N53*100,0 Working with Excel Charts Chart Saving Customized Settings Summary Report Interpreting Report Metrics Metric Description Summary Report Metrics 3PAR System Reporter User’s Guide Metric Description PD Space Reports Space Reports LD Space Reports Usage Type Description Spare, Unused, FailedTotals VV Space Reports VV Space Report Metrics 3PAR System Reporter User’s Guide Common Performance Metrics Performance Reports 3PAR System Reporter User’s Guide VV Cache Performance Reports Node Cache Performance Reports CPU Performance Reports Link Performance Reports Adaptive Optimization Reports Accessing the System Reporter Policies Configuring the System Reporter Policy Settings Etc/clipwdir on Linux Configuring Sampling PoliciesPolicy Default Full path to directory containing InForm CLI password files See Compacting Databases on Compacting Databases Editing Sampling Policies Connection Dialog Box Adding, Removing and Re-Configuring InServ Storage Systems Click Remove InServ Adding a Storage ServerVerifying Addition of a Storage Server Removing a Storage Server Re-Configuring a Storage Server Sampling Click Add Alert Configuring Rules for Email AlertsAdding an Alert Rule 3PAR System Reporter Policies window appears Removing an Alert Rule Changing an Alert Rule Data Table Description Alert Rule ParametersData Table Click Remove Alert Resolution Resolution Description SystemMetric Metrics Description Data Tables Averaged over the sample Limit Value Direction Condition Value Example of an Alert RuleLimit Count Condition Scheduledreports/report directory/report name/YYYYMMDDHH Scheduling Reports Adding a Scheduled Report Choose the Scheduled Reports tabClick Add Scheduled Report Changing a Scheduled Report Removing a Scheduled Report About File Permissions Configuring Adaptive Optimization Modifying the Apache Http Server Configuration Files Modifying the Apache Http Server Configuration Files About Web Queries Web Queries Data Format Version Report System Reporter Version Report Option=value About Reports and OptionsReport Options Category Hourly CompareExample Daily Values LDUsage HostVVType ProvType Comparesel Rawspace InterruptsCtxtsws Totalspace Statld PdspaceVvspace Statpd Both CharttabChart Refresh Stackedarea CharttypeStackedbars Stackedvbars Graphx GraphyValue Graphlegpos TableformatBottom Right Excel Alllabels Begintsecs Timeform Tsecs Endtsecs Groupby PortNode Groupby=System Orderby Order results by Virtual Volume VV Type IO Size Service TimeIOPs Bandwidth Ctxt TotalAccessesIdle Intr Ldspaceunit Histbegin GB 109 bytes PdspaceunitExamples MiB 220 bytes Chunklets Vvspaceunit All cage IDs Selcageid Nrmavaildrty Selchunks Selchunkls=NRMAVAILCLEAN&selchunks=SPRAVAILCLEAN Selchunkls=NRMAVAILCLEAN Seldisktype SelcpgSelusrcpg Selsnpcpg Seldiskspeed All Disk TypesAll Disk Speeds Seldomain ALL DomainsDomainname Hostname SelhostDomain2 ALL Hosts Ldname SelldSellduse All LDs Log Selnode Selnsp All NodesAll Ports ALL PDIDs Selpdid Valid SelpdstateSelporttype All PD States Selraidtype All Systems SelsysSelraidtype= Selraidtype=1&selraidtype=5 Selvv Selprovtype Selvvtype Report Types Summary PdspacetimePdspacegroup Ldspacegroup Ldspacetime Vvspacetime VvspacegroupPdperftime Pdsvthist Pdperfgroup Pdsvthistvstime PortperftimePortperfgroup Compare=System PortsvthistPortsvthistvstime Ldperftime Ldperfgroup LdsvthistLdsvthistvstime Vlunperftime VlunperfgroupVlunsvthist Vlunsvthistvstime VvcmptimeVvcmpgroup Cpuperfgroup Cpuperftime Regiondensity example RegiodensityRegmoves Vvtier Options Available by Report Vvtier exampleReport Option M M Report Option Histsvtpd M M M M M M Objects Present Reports Http//localhost/cgi-bin/3par-rpts Using tableformat=excel Without using tableformat=excel Report Table values Objectspresent&objectpres= ldname on Sampletimes on Objectpres= cageid Objectpres= cpgname OutputObjectspresent&objectpres=cageid Objectspresent&objectpres=cpgname Objectpres= diskspeed Objectpres= disktype Objectspresent&objectpres=diskspeedObjectspresent&objectpres=disktype Objectpres= domainname Objectpres= hostnameObjectspresent&objectpres=domainname Objectspresent&objectpres=hostname Objectpres= ldname Objectspresent&objectpres=ldname Objectpres=node Objectspresent&objectpres=node Objectpres=pdid Objectspresent&objectpres=pdid Objectpres=port Objectspresent&objectpres=port Objectpres= system Objectspresent&objectpres=system using Objectpres= vvnameObjectspresent&objectpres=vvname Objectspresent&objectpres=vvnamenosnap Objectpres= vvnamenosnap Objectspresent&objectpres=porttype Objecctpres= porttype Time string with format yyyy-mm-dd hhmmss Sampletimes Objects Present Reports Objects Present Reports Overview Using Adaptive Optimization Overview Selecting an InServ for Adaptive Optimization Configuring Adaptive Optimization Adaptive Optimization Configuration Main Window Tier Definition CPG Name and GiB Configuring Adaptive Optimization Configuring Adaptive Optimization Measurement Hours Schedule Adaptive Optimization Active Adaptive Optimization ModeAdding an Adaptive Optimization Configuration Add Adaptive Optimization Configuration window appears Change Adaptive Optimization Configuration window appears Changing an Adaptive Optimization Configuration Removing an Adaptive Optimization Configuration Region IO Density Report Region IO Density with Adaptive Optimization Region IO Density without Adaptive Optimization VV Tiers Report Space Moved Report Adaptive Optimization Space Moved Report Cli% source showvvcpg.tcl Showvvcpg CLI extension CPG Showvvcpg CLI extension 10.1 Using The Database Schema Policy Table Administrative TablesTable Versions and Naming Conventions 10.2 Sampleinserv Table 10.3 System Table 10.4 10.5 Alertconfig Table Datatable value 10.6 Scheduledreport Table 10.7 10.8 Adprovconfig Table 10.9Scheduledreportlog Table 10.10 Adprovlog Table 10.11 Ldrgmoves Table 10.12 10.13 Sample Data and Inventory Tables 10.14Recentsample Table Pdspace Table 10.15 10.16 10.17 Pdspaceinv Table 10.18 Ldspace Table 10.19 10.20 Ldspaceinv Table 10.21 Vvspace Table 10.22 10.23 10.24 Vvspaceinv Table 10.25 10.26 Cpgspace Table 10.27 10.28 Cpgspaceinv Table 10.29 Common Performance Table Columns 10.30 10.31 10.32 10.33 10.34 10.35 Calculating Common Performance MetricsMetric SQL Expression Service Time Histogram Buckets 10.36IO Size Histogram Buckets Statpd Table 10.37 10.38 Statpdinv Table 10.39 Statld Table 10.40 Statldinv Table 10.41 Statport Table 10.42 Statportinv Table 10.43 10.44 Statvlun Table 10.45 Statvluninv Table 10.46 Statvvcmp Table 10.47 10.48 10.49 Statvvcmpinv TableSysuid Statcpu Table 10.50 Null CPU 10.51 10.52 Statcpuinv TableStatlink Table 10.53 Statlinkinv Table 10.54 Statldrg Table 10.55 Statldrgtimeinv Table 10.56 10.57 Perftimeinv TableSpacetimeinv Table 10.58 11.1 Troubleshooting Overview Troubleshooting the Sampling Components 11.2Sampling Component Log Files Installation Configuration InServ Sampling Errors11.3 Errors incurred by the CLI sampler process Troubleshooting Adaptive Optimization ComponentsSampler Service/Daemon Errors Errors incurred by the inservsample process Troubleshooting the Web Server Components Troubleshooting the Excel Client11.5 11.6 Extracting Data from the Database with sysbck 11.7 11.8 Examples of Using sysbck for Various Databases From MySQL to Oracle 11.9 11.10 11.11 Dumping the Entire Database 11.12Dumping the Entire SQLite Database Dumping the Entire MySQL Database 11.13 11.14 IX.1 Index IX.2 IX.3 IX.4 IX.5 IX.6 Release level Revision summary RH.1 RH.2 Configuration, Update, and Removal RH.3 RH.4 RH.5 RH.6 RH.7 RH.8