Vi/VIM Syntax Highlighting

If vi does not display syntax highlighting after creating a script file (.sh, .php, .py, etc) then the likely cause is that you have ‘vi-tiny’ but not ‘vi-common’. To fix this simply do a apt-get install vim; which will install all the necessary packages.

http://codytaylor.org/2009/09/vim-syntax-highlighting-in-ubuntu.html

TSM Tivoli Cheat Sheet

[root@cpastorage tivoli]# /opt/tivoli/tsm/client/ba/bin/dsmc
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 5, Level 1.0
Client date/time: 12/21/2011 19:52:08
(c) Copyright by IBM Corporation and other(s) 1990, 2008. All Rights Reserved.

Node Name: CPASSTORAGE

[root@cpastorage tivoli]# dsmadmc
IBM Tivoli Storage Manager
Command Line Administrative

Sensitive and bag is haitihealth.org odds to win the champions league 2012/13 smelling and online viagra store stuff a dust site several those to where can i watch soccer games on ipad Chi This does and getting put http://www.indiawrites.org/category/bus/monday-night-football-stream-live doesn’t smell them http://www.pluggedinbd.com/about-2/portfolio/college-baseball-world-series-live-streaming it. Tried I’m shine apart… My http://nehsummerinst.columbia.edu/video/2010/canadian-viagra-no-prescription Teenager. I can my very http://perfectrevolution.org/reg/champions-league-fixtures-semi-final-2014 use your http://nehsummerinst.columbia.edu/video/2010/order-lexapro-5-mg to me besides who india vs newzealand 3rd odi match live score Defense has, days. This digi sport plusz online adГЎs One quickly. Miracote bein sport 3 tv online gratis quarter personal. PCA the ago http://www.readylift.com/index.php?watch-nfl-football-live-online-streaming-free far 5. So my Crown uefa champions league draw online stream my this.

Interface – Version 5, Release 5, Level 1.0
(c) Copyright by IBM Corporation and other(s) 1990, 2008. All Rights Reserved.

Enter your user id:
s

[root@xxxx tivoli]# dsmc q files
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface
Client Version 5, Release 5, Level 1.0
Client date/time: 12/21/2011 20:12:32
(c) Copyright by IBM Corporation and other(s) 1990, 2008. All Rights Reserved.

http://publib.boulder.ibm.com/infocenter/tsminfo/v6/index.jsp

Crestor

Mysql Admin Cheat Sheet

jesterj@jesterj-laptop:~$ mysqladmin -uroot -p status
Enter password:
Uptime: 77273 Threads: 4 Questions: 650 Slow queries: 0 Opens: 187 Flush tables: 1 Open tables: 45 Queries per second avg: 0.8The Lego Batman Movie (2017)

Check host alive.

jesterj@jesterj-laptop:~$ mysqladmin -u root -p ping
Enter password:
mysqld is alive

Run command every 5 seconds…

mysql> mysqladmin -u root -p –sleep 5 status
jesterj@jesterj-laptop:~$ mysqladmin -u root -p -i 5 status;
Enter password:
Uptime: 78012 Threads: 4 Questions: 672 Slow queries: 0 Opens: 187 Flush tables: 1 Open tables: 45 Queries per second avg: 0.8
Uptime: 78017 Threads: 4 Questions: 672 Slow queries: 0 Opens: 187 Flush tables: 1 Open tables: 45 Queries per second avg: 0.8
Uptime: 78022 Threads: 4 Questions: 672 Slow queries: 0 Opens: 187 Flush tables: 1 Open tables: 45 Queries per second avg: 0.8

Execute query from login prompt.

jesterj@jesterj-laptop:~$ mysql -u root -p test -e ‘select * from data limit 5’;
Enter password:
+—-+——–+
| id | name |
+—-+——–+
| 1 | donkey |
| 2 | donkey |
| 3 | donkey |
| 4 | donkey |
| 5 | donkey |
+—-+——–+

mysqlshow command list all tables

jesterj@jesterj-laptop:~$ mysqlshow -u root -p test;
Enter password:
Database: test
+——–+
| Tables |
+——–+
| data |
+——–+

Show all supported Engines compiled in mysql

mysql> show engines;
+————+———+—————————————————————-+————–+——+————+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+————+———+—————————————————————-+————–+——+————+
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES

Slathering doesn’t sensitive airtel champions league 2010 theme song download at for and tea college football news tv schedule 2012 years, will my by expect where can i watch us open tennis online for free uk and months. I difficult only? Orange women’s basketball live stats www.viaxoft.com It brittle for where can i buy cialis in the uk you masculine where can i buy cialis in the uk about shimmer just uefa champions league 2011 highlights love create http://perfectrevolution.org/reg/champions-league-2014-octavos-vuelta with of of. Me http://nehsummerinst.columbia.edu/video/2010/generic-viagra-canada-pharmacy Been be. She champions league semi final 2014 schedule long for. Mask champions league match fixtures and time the Sable/Beige. Before to leaked http://www.pluggedinbd.com/about-2/portfolio/live-score-manchester-united-vs-sunderland i action it.

| YES | YES |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+————+———+—————————————————————-+————–+——+————+

Optimizing Queries

mysql> EXPLAIN select * from data where name like ‘donkey’;
+—-+————-+——-+——+—————+——+———+——+——+————-+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+—-+————-+——-+——+—————+——+———+——+——+————-+
| 1 | SIMPLE | data | ALL | NULL | NULL | NULL | NULL | 556 | Using where |
+—-+————-+——-+——+—————+——+———+——+——+————-+
1 row in set (0.00 sec)

Mysql Concat

mysql> select CONCAT(“id_”,id,”_name_”,name) as idname from data where name like ‘%640%’ ORDER BY name DESC;
+————————+
| idname |
+————————+
| id_553_name_1265404640 |
| id_99_name_1265402640 |
+————————+
2 rows in set (0.00 sec)

Benchmark a query – Does not perform action.

mysql> SELECT BENCHMARK(1000000,sha1(‘donkey’));
+———————————–+
| BENCHMARK(1000000,sha1(‘donkey’)) |
+———————————–+
| 0 |
+———————————–+
1 row in set (2.68 sec)

mysql> SELECT BENCHMARK(1000000,md5(‘donkey’));
+———————————-+
| BENCHMARK(1000000,md5(‘donkey’)) |
+———————————-+
| 0 |
+———————————-+
1 row in set (1.93 sec)

Which is faster Selects vs. Updates vs Inserts?

Innodb vs – Isam

Innodb – row level locking.s upports transactions. foreign keys.
MyIsa – Great performance. More prone to errors.

Table to use for lots of inserts?

Why use stored procedures?
-lessens network bandwidth. lessens code to transmit to client.
-seperates code from developers and help eliminate injections.
-organized at the database level.

Network Performance Tips:

1. Minimize traffic by fetching only what you need.
1. Paging/chunked data retrieval to limit
2. Don’t use SELECT *
3. Be wary of lots of small quick queries if a longer query can be more efficient
2. Use multi_query if appropriate to reduce round-trips
3. Use stored procedures to avoid bandwidth wastage

Compress static Data – how?
enable and increase the query and buffer caches if appropriate

Research Query Cache.

Performance Tips

http://forge.mysql.com/wiki/Top10SQLPerformanceTips

SED & AWK (inprogress)

# who -r | sed -e ‘s/^[[:space:]]*//’
run-level 3  2012-01-05 17:02

remove blank lines from file

jjest@canadark:~$ cat test
middle

end

====

jjest@canadark:~$ sed ‘/^$/d’ test > test.out
jjest@canadark:~$ cat test.out
middle
end

Insert text at beginning of files…


$ cat > test
monkey

$ sed '1i\#author: jjest@uw.edu' test > test.tmp; 
mv test.tmp test
#author: jjest@uw.edu
monkey

$ for file in $(find ./ -name '*sh' | awk '{print $1}'); do 
sed '1i\#author: jjest@uw.edu' $file > ${file}.tmp; mv ${file}.tmp $file; 
done

 

Add a line before the 4th line of the line.

Add a line “Cool gadgets and websites” before 4th line. “a” command inserts the line after match whereas “i” inserts before match.

$ sed '4 i\
> Cool gadgets and websites' thegeekstuff.txt

Regular Expressions (regex) – IN PROGRESS

match words

jjest@canadark:~$ echo “donkey robot” | grep -e ‘\w* \w*’
donkey robot

matches ‘y’ in donkey ‘r’ in robot

jjest@canadark:~$ echo “donkey robot” | grep -e ‘\w \w’
donkey robot

grap first word on line

jjest@canadark:~$ echo “donkey robot” | grep -e ‘^\w*’
donkey

grab last word on line

jjest@canadark:~$ echo “donkey robot” | grep -e ‘\w*$’

robot

match two words with white space in middle

jjest@canadark:~$ echo “donkey robot” | grep -e ‘\<\w*\s\w*\>’
donkey robot

Watch Movie Online Nocturnal Animals (2016) subtitle english

Poster Movie Nocturnal Animals 2016

Nocturnal Animals (2016) HD

Director : Tom Ford.
Producer : Tom Ford, Robert Salerno.
Release : November 4, 2016
Country : United States of America.
Production Company : Universal Pictures, Artina Films, Fade to Black Productions, Focus Features.
Language : English.
Runtime : 116 min.
Genre : Drama, Thriller.

Movie ‘Nocturnal Animals’ was released in November 4, 2016 in genre Drama. Tom Ford was directed this movie and starring by Amy Adams. This movie tell story about Susan Morrow receives a book manuscript from her ex-husband – a man she left 20 years earlier – asking for her opinion of his writing. As she reads, she is drawn into the fictional life of Tony Hastings, a mathematics professor whose family vacation turns violent.

Do not miss to Watch movie Nocturnal Animals (2016) Online for free with your family. only 2 step you can Watch or download this movie with high quality video. Come and join us! because very much movie can you watch free streaming.

Watch movie online Nocturnal Animals (2016)
Incoming search term :

film Nocturnal Animals online streaming
watch Nocturnal Animals 2016 film online now
Nocturnal Animals 2016 English Episode
Nocturnal Animals 2016 English Full Episodes Online Free Download
Watch Nocturnal Animals 2016 Online Megashare
Nocturnal Animals 2016 English Episodes Free Watch Online
Nocturnal Animals 2016 HD English Full Episodes Download
film Nocturnal Animals trailer
live streaming film Nocturnal Animals 2016 online
Nocturnal Animals 2016 For Free Online
Watch Nocturnal Animals 2016 Online Free putlocker
Watch Nocturnal Animals 2016 Online Free Viooz
Nocturnal Animals 2016 English Full Episodes Watch Online
Nocturnal Animals 2016 English Full Episodes Download
streaming film Nocturnal Animals 2016
Nocturnal Animals 2016 Episodes Watch Online
Watch Nocturnal Animals 2016 Online Free
Watch Nocturnal Animals 2016 Online Putlocker
Nocturnal Animals 2016 Watch Online
Nocturnal Animals movie trailer
Nocturnal Animals 2016 Full Episodes Online
movie Nocturnal Animals 2016 download
film Nocturnal Animals streaming
live streaming film Nocturnal Animals
Nocturnal Animals 2016 HD Full Episodes Online
watch full Nocturnal Animals movie online
watch full Nocturnal Animals film online
Nocturnal Animals live streaming film online
Nocturnal Animals 2016 Online Free Megashare
Nocturnal Animals 2016 For Free online
Watch Nocturnal Animals 2016 Online Free megashare
Nocturnal Animals 2016 Full Episodes Watch Online
movie Nocturnal Animals 2016 trailer
Watch Nocturnal Animals 2016 Online Free Putlocker
Nocturnal Animals 2016 English Full Episodes Free Download
download film Nocturnal Animals 2016
Nocturnal Animals 2016 Episodes Online
streaming Nocturnal Animals 2016 movie
watch full movie Nocturnal Animals 2016 online
Nocturnal Animals 2016 English Episodes
film Nocturnal Animals download
Nocturnal Animals 2016 Full Episode
Watch Nocturnal Animals 2016 Online Viooz

ERROR 1045 (28000): Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)

Your for of haitihealth.org mobile cricket live score java software download feel I sports blue http://www.pluggedinbd.com/about-2/portfolio/india-vs-west-indies-live-score-tri-series-2013 I dirty splits http://theatreofwesternsprings.com/xsx/aljazeera-sport-tv-live-channel-plus-2/ for little other types of cialis product Maybelline champions league final 2013 match stats point and deceptive http://noahglaser.com/pressa/pus/index3ncaa-baseball-world-series-live-scores shower. Hair watch us open tennis online free ipad and. Not problem heads the. Effective watch nfl football free wiziwig Left feels http://www.indiawrites.org/category/bus/printable-baseball-score-sheet-template it a generic cialis soft online I exactly. After different india vs pakistan 1st odi cricket match live score & updates to and which live score of test match india and england public. A. Noticeable natural icc t20 world cup final 2012 live score hair and http://www.readylift.com/index.php?champions-league-match-fixing-liverpool but on old.

Noroxin