Linux: How to display PCI devices topology

[user@hostname ~]# lspci -tv
-+-[0007:80]-+-00.0  Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe
 |           +-00.1  Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe
 |           +-00.2  Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe
 |           \-00.3  Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe
 +-[0005:50]---00.0  Texas Instruments TUSB73x0 SuperSpeed USB 3.0 xHCI Host Controller
 +-[0004:01]---00.0  Mellanox Technologies MT27600 [Connect-IB]
 +-[0003:70]---00.0  IBM PCI-E IPR SAS Adapter (ASIC)
 +-[0000:01]---00.0  Mellanox Technologies MT27520 Family [ConnectX-3 Pro]
 \-[0000:00]-

UNIX: commands that can be used for performance-related issues

Here are summed up commands that can help identify performance related issues in UNIX systems:

IBM TotalStorage SAN Hosts Data Gathering

This TIP discusses IBM TotalStorage SAN hosts data gathering.

IBM HMC: Accessing the Product Engineering Shell (PESH) Command Line

On this site you can find manual how to access PESH in HMC.
http://www-01.ibm.com/support/docview.wss?uid=nas1dba3b86d228b9b6c862570d1008009fd

It can be used when solving problem with too big /var/hsc/log/hmclogger.log file and need to do any operation under root.
http://www-01.ibm.com/support/docview.wss?uid=isg3T1011162


The procedure in this document can be used to obtain an unrestricted shell on the HMC and log on as root.
Prerequisites: Obtain a pesh password from IBM support.
Right-click on the HMC desktop, select Terminals > rshterm . Run the lshmc -v command to obtain the HMC serial number (as stored in the BIOS). The serial number is listed in the SE field (in bold blue below):

How to recover one table from dump in MySQL

If you do dumps just of one table on regular basis then you are happy man :-)

1. Backup of one table:
   # mysqldump -u username -p password > /path/file.sql
2. Restore one table:
   # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql

If you do dumps of whole DB then do following:
Backup of DB:

1. # mysqldump -u username -p password > /path/file.sql

Restore of one table from dump of DB:

1. We have to know where one table starts and where ends:
   # grep -n 'Table structure' /path/file.sql
2. Then we have to separate part of file with required table into new file using line number gathered in previous command (where 7506 is start and 17684 is end):
   # sed -n '7506,17684 p' /path/file.sql > /path/new_file.sql
3. Then we can restore it into DB:
   # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql

UNIX and Linux command reference guide

Here are some commands from UNIX and Linux world.
Source:
http://www.ahinc.com/aix/
http://www.digilife.be/quickreferences/quickrefs.htm
AIX
http://www.tablespace.net/quicksheet/aix-quicksheet.pdf
http://www.tablespace.net/quicksheet/aix-quickstart.html
http://publib16.boulder.ibm.com/pseries/index.htm

	AIX		Linux
	Command	Comment	Command	Comment
Show directory size	du -ms /tmp	k KB,m MB, g GB	du -hs /tmp
Show disk size	bootinfo –s hdisk#	MB
List exported directories	lsfsexp showmount -e
Show FC Info	fcstat fcsX