Hp 3PAR System Reporter Software Uživatelský manuál Strana 232
- Strana / 239
- Tabulka s obsahem
- ŘEŠENÍ PROBLÉMŮ
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
Dumping the Entire MySQL Database
To create a dump of a MySQL database use the mysqldump program as follows
# mysqldump --host=hostname --user=username --password=passwd --opt dbname > dbname.sql
This creates a text file called dbname.sql that contains SQL commands to create the tables and
insert the data into the tables. You can simply source this file into MySQL to recreate the entire
database.
NOTE: When dumping data from a large database that is to be backed up to a different location
than the source, it is best to use sysbck as the data will be stored in multiple 2 GB files (if
necessary), and is easier to manage.
232 Troubleshooting System Reporter
- User Guide 1
- Contents 7
- 8 Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- 14 Contents 14
- Contents 15 15
- 16 Contents 16
- 1 Overview and Features 17
- 18 Overview and Features 18
- Creating Customized Reports 19
- Generating Email Alerts 21
- 22 Overview and Features 22
- Before You Begin 23
- System Reporter CD Contents 23
- System Requirements 24
- Sampling Parameters 27
- System Reporter Components 28
- Required Components 29
- ◦ installer.exe 29
- Optional Components 30
- Installing the Web Server 31
- Microsoft SQL 33
- 9. Click Next 38
- 10. Click Finish 38
- Installing MySQL Server 39
- Creating an Oracle database 42
- Adding Storage Systems 48
- ◦ Linux: /etc/certdir 49
- Verifying Installation 50
- 3 Getting Started 54
- Getting Help 56
- 58 Getting Started 58
- 60 Getting Started 60
- 62 Getting Started 62
- Deleting Excel Sheets 63
- Deleting Data Sheets 64
- Deleting the Query Log 64
- (Optional)” (page 50) 65
- Accessing Quick Reports 66
- Accessing Scheduled Reports 67
- Creating Custom Reports 68
- Sample Resolution 69
- Generating the Report 70
- Creating Custom Reports 71 71
- Controls Available by Report 73
- Report Selection 77
- Standard Report Types 78
- Creating Custom Reports 79 79
- Creating Custom Reports 81 81
- Select Summary Columns 83
- Max. Number 84
- Select Peak 84
- Group By 84
- Order By 85
- Time Selection 86
- Object Selection 87
- Select PDIDs 88
- Include Chunklets 88
- Select Cage IDs 88
- Select Disk Types 88
- Select Disk Speed 88
- Include PDs in States 89
- Select Usr CPGs 89
- Select Snp CPGs 89
- Select CPGs 90
- Select LDs 90
- Select RAID Types 90
- Select LD Usage 90
- Select LUN 91
- Select VVs 91
- Select Prov Types 91
- Select VV Types 92
- Select Port Types 92
- Select Port Rates 92
- Select Ports (n:s:p) 92
- Select Hosts 93
- Select Nodes 93
- Select To Nodes 93
- Select Queues 93
- Select QoS Rules 94
- Report Information 94
- Chart Lib 95
- Chart Types 95
- • Stacked Bars 96
- • Stacked Vert Bars 96
- • Stacked Area 97
- Figure 37 Chart Using Lines 98
- Figure 38 Chart Using Bars 98
- Chart X Pixels 99
- Chart Y Pixels 99
- Time Labels 99
- Legend Position 99
- Time Format 99
- Working with Excel Charts 100
- Refreshing Charts 101
- Retaining Charts 102
- Exporting Executable Reports 103
- Customizing Excel Reports 103
- Creating a Custom Chart 104
- Saving Customized Settings 105
- 5 Interpreting Report metric 106
- Space Reports 108
- PD Space Reports 109
- CPG Space Reports 109
- LD Space Reports 110
- VV Space Reports 110
- Performance Reports 111
- VV Cache Performance Reports 112
- CPU Performance Reports 113
- Link Performance Reports 113
- Adaptive Optimization Reports 114
- Configuring Sampling Policies 116
- Compacting Databases 117
- Editing Sampling Policies 118
- Adding a Storage System 119
- Removing a Storage Server 119
- Adding an Alert Rule 121
- Changing an Alert Rule 121
- Removing an Alert Rule 122
- Alert Rule Parameters 122
- Resolution 123
- Direction 124
- Scheduling Reports 125
- Adding a Scheduled Report 126
- Changing a Scheduled Report 127
- Removing a Scheduled Report 127
- About File Permissions 128
- 7 Web Queries 130
- About Reports and Options 131
- Report Options 132
- Report Options 133 133
- &compare=LD 134
- 134 Web Queries 134
- Report Options 135 135
- &refresh=2 136
- &charttab=chart 136
- 136 Web Queries 136
- Report Options 137 137
- 138 Web Queries 138
- &alllabels=1 139
- &timeform=relative 139
- Report Options 139 139
- &begintsecs=1121277634 140
- &endtsecs=1121277634 140
- 140 Web Queries 140
- Report Options 141 141
- &groupby=System 142
- 142 Web Queries 142
- Report Options 143 143
- &orderby=System 144
- 144 Web Queries 144
- &histbegin=1 145
- Report Options 145 145
- &selcageid=1 147
- Report Options 147 147
- &seldisktype=FC 149
- &seldiskspeed=10 149
- Report Options 149 149
- &selvv= 156
- &selvv=--All%20VVs 156
- 156 Web Queries 156
- Report Types 157
- Summary Report 158
- Options Available by Report 166
- 168 Web Queries 168
- 170 Web Queries 170
- Objects Present Reports 172
- 174 Web Queries 174
- Objects Present Reports 177 177
- 180 Web Queries 180
- 8 Using Adaptive Optimization 183
- Schedule 187
- Measurement Hours 187
- Adaptive Optimization Mode 188
- Adaptive Optimization Active 188
- VV Tiers Report 191
- The showvvcpg CLI extension 193
- 9 Database Schema 195
- The system Table 196
- The alertconfig Table 197
- The scheduled_report Table 197
- The adprovconfig Table 198
- The adprov_log Table 199
- The ldrgmoves Table 199
- The recentsample Table 200
- The pdspace Table 201
- The pdspaceinv Table 202
- The ldspace Table 203
- The ldspaceinv Table 203
- The vvspace Table 204
- The vvspaceinv Table 206
- The cpgspace Table 206
- The cpgspaceinv Table 208
- The statpd Table 211
- The statpdinv Table 212
- The statld Table 212
- The statldinv Table 213
- The statport Table 213
- The statportinv Table 214
- The statvlun Table 214
- The statvluninv Table 215
- The statvvcmp Table 216
- The statvvcmpinv Table 216
- The statcpu Table 216
- The statcpuinv Table 217
- The statlink Table 218
- The statlinkinv Table 218
- The statldrg Table 218
- The statldrg_timeinv Table 219
- The perf_timeinv Table 219
- The space_timeinv Table 219
- The statqos Table 220
- The statqosinv Table 223
- Troubleshooting Overview 224
- Installation Configuration 225
- Sampling Errors 225
- Sampler Service/Daemon Errors 226
- Dumping the Entire Database 231
- Contacting HP 233
- HP 3PAR documentation 233
- Typographic conventions 236
- HP 3PAR branding information 236
- 12 Documentation feedback 237
- 238 Index 238
Související produkty a manuály pro Úložný prostor Hp 3PAR System Reporter Software
Úložný prostor Hp StoreAll Storage Uživatelský manuál
(406 stránky)
(406 stránky)
Úložný prostor Hp Secure Key Manager Uživatelský manuál
(327 stránky)
(327 stránky)
Úložný prostor Hp 3PAR Application Software Suite for Microsoft Exch Uživatelský manuál
(23 stránky)
(23 stránky)
Úložný prostor Hp SAN Uživatelský manuál
(38 stránky)
(38 stránky)
© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.055 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce