Posts

Showing posts from 2014

ZFS Tricks

Adding swap space on a ZFS volume root@sys-082 # zfs create -V  20gb <ZPOOL-NAME>/swapvol root@sys-082 # swap -a /dev/zvol/dsk/<ZPOOL-NAME>/swapvol

Mysql Tips

List all tables and count in mysql SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'emsadmin' order by table_rows asc; Counting the number of rows in a large table select table_rows from information_schema.tables where table_name = 'HistoricalAlarm'; Create a csv file using name coloun of Ne Table.  select name from Ne limit 1,1470 into outfile '/tmp/nelist.csv' fields terminated by ',';