CNN.com- Police: Trayvon Martin's death 'ultimately avoidable'
- Man questioned in highway killings
- Flesh-eating infections: Scores per year
- Travolta accuser hires Gloria Allred
- Court upholds Mississippi pardons
- Facebook IPO: Internet glee, skepticism
- Do voters want moderates out of D.C.?
- Now it's the jury's turn in Edwards trial
- Breyer's D.C. home hit by burglary
- Opinion: Dimon's $23M isn't the problem
- BBC
- VIDEO: Help offered on bringing up baby
- China jails smuggler Lai for life
- Airport starts search for new MD
- Dementia patient 'had 106 carers'
- Quarter of buses have problems
- 'Escalator tore off my big toe'
- Sex offenders get police cautions
- VIDEO: Malawi babies who are fighting to grow
- VIDEO: UK prepares for Olympic flame arrival
- VIDEO: G8 leaders to meet at Camp David
- AL JAZEERA ENGLISH (AJE)
- 'Disco queen' Donna Summer dies at 63
- Facebook to go public in $104bn flotation
- Tunisia-uprising injured sew lips in protest
- DR Congo troops shell rebel bases
- UN chief blames al-Qaeda for Syria bombings
- China jails fugitive smuggler for life
- Mladic trial postponed over 'errors'
- Fitch downgrades Greece on euro exit fears
- New French cabinet takes pay cut
- Obama unveils 'new chapter' in Myanmar ties
Monthly Archives: July 2009
MySQL Slow Query Optimization Tips
Slow Query Example SELECT widget_id , widget_name , COUNT(DISTINCT type) AS num_types FROM widget GROUP BY type ORDER BY num_types DESC With lots (>100K) of rows, this query will get slow because it orders on an aggregate COUNT DISTINCT function. … Continue reading
How to Convert Seconds to Minutes in BASH
This is how to convert seconds into HH:MM:SS in bash: $ date -d ’1970-01-01 100 sec’ +’%H:%M:%S’ 00:01:40
How to fix: error while loading shared libraries: liblwres.so.50
To fix this error: # nslookup mydomain.com nslookup: error while loading shared libraries: liblwres.so.50: cannot open shared object file: No such file or directory Do this: # ldconfig # dig mydomain.com ; DiG 9.6.1-RedHat-9.6.1-2.fc11 mydomain.com … From the ldconfig manpage: … Continue reading
Posted in Linux, Troubleshooting
Leave a comment
How to Optimize MySQL Queries Using Indexes
When optimizing a query, the order of fields matter in a multi-field index. In general, you should use the most selective fields first. For example, in a hypothetical location index, use zip, city, state, rather than the reverse. Source: MySQL … Continue reading