usefulthingsilearned.com

Useful things I learned

Useful things I learned. Counting your slow queries by seconds. July 30, 2013 1:42 PM. I needed to check the performance of a database after some changes. This gets me some raw numbers on the performance of the slow queries log in MySQL:. Tail -n 10000 log-slow-queries.log grep Query awk '{print $3}' awk -F . '{print $1}' sort -n uniq -c awk '{print $2" "$1}'. It outputs seconds taken, and number of times that amount has shown up in the logs. Continue reading Counting your slow queries by seconds. From t...

http://www.usefulthingsilearned.com/

OVERVIEW OF usefulthingsilearned.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR USEFULTHINGSILEARNED.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

September

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Wednesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.3 out of 5 with 4 reviews

5 star

1

4 star

3

3 star

0

2 star

0

1 star

0

Hey there! Start your review of usefulthingsilearned.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

CONTACTS AT USEFULTHINGSILEARNED.COM

Contact Privacy Inc. Customer 0129343592

Contact Privacy Inc. Customer 0129343592

96 M●●●● Ave

To●●to , ON, M6K 3M1

CA

1.41●●●●5457

us●●●●●●●●●●●●●●●●●●●●●●@contactprivacy.com

View this contact

Contact Privacy Inc. Customer 0129343592

Contact Privacy Inc. Customer 0129343592

96 M●●●● Ave

To●●to , ON, M6K 3M1

CA

1.41●●●●5457

us●●●●●●●●●●●●●●●●●●●●●●@contactprivacy.com

View this contact

Contact Privacy Inc. Customer 0129343592

Contact Privacy Inc. Customer 0129343592

96 M●●●● Ave

To●●to , ON, M6K 3M1

CA

1.41●●●●5457

us●●●●●●●●●●●●●●●●●●●●●●@contactprivacy.com

View this contact

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

DOMAIN REGISTRATION INFORMATION

REGISTERED: 2011 November 07
UPDATED: 2013 November 20
EXPIRATION: EXPIRED REGISTER THIS DOMAIN

BUY YOUR DOMAIN

DOMAIN AGE

13

YEARS
5

MONTHS
23

DAYS

NAME SERVERS

1: ns1.blueboxgrid.com
2: ns2.blueboxgrid.com
3: ns3.blueboxgrid.com

REGISTRAR

TUCOWS DOMAINS INC.

WHOIS : whois.tucows.com

REFERRED : http://domainhelp.opensrs.net

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

0

SITE IP

67.214.217.70

LOAD TIME

0.281 sec

SCORE

6.2

PAGE TITLE

Useful things I learned | usefulthingsilearned.com Reviews

<META> DESCRIPTION

Useful things I learned. Counting your slow queries by seconds. July 30, 2013 1:42 PM. I needed to check the performance of a database after some changes. This gets me some raw numbers on the performance of the slow queries log in MySQL:. Tail -n 10000 log-slow-queries.log grep Query awk '{print $3}' awk -F . '{print $1}' sort -n uniq -c awk '{print $2 $1}'. It outputs seconds taken, and number of times that amount has shown up in the logs. Continue reading Counting your slow queries by seconds. From t...

<META> KEYWORDS

1 by cj

2 no trackbacks

3 the syntax is

4 p file txt

5 rename table

6 2 automate

7 1 ubuntu

8 server1

9 server2

10 server3

CONTENT

Page content here

KEYWORDS ON PAGE

by cj,no trackbacks,the syntax is,p file txt,rename table,2 automate,1 ubuntu,server1,server2,server3,server4,x ssh,user@$,network dns disableipv6,innodb table recovery,gnome terminal,x /path/to/script,archives,other blogs,glenariff improvement group,grep

SERVER

Apache/2.2.14 (Ubuntu)

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Useful things I learned | usefulthingsilearned.com Reviews

https://usefulthingsilearned.com

Useful things I learned. Counting your slow queries by seconds. July 30, 2013 1:42 PM. I needed to check the performance of a database after some changes. This gets me some raw numbers on the performance of the slow queries log in MySQL:. Tail -n 10000 log-slow-queries.log grep Query awk '{print $3}' awk -F . '{print $1}' sort -n uniq -c awk '{print $2" "$1}'. It outputs seconds taken, and number of times that amount has shown up in the logs. Continue reading Counting your slow queries by seconds. From t...

INTERNAL PAGES

usefulthingsilearned.com

1

How to rename a database in mysql 5.5 - Useful things I learned

http://www.usefulthingsilearned.com/2012/07/how-to-rename-a-database-in-mysql-55.html

Useful things I learned. How to rename a database in mysql 5.5. July 27, 2012 3:48 PM. In mysql 5.5 the RENAME DATABASE functionality went away, but the manual does show that RENAME TABLE works:. Current db.tbl name. Other db.tbl name;. While is is good, it's a pain when there lots of tables, and leaves lots of room for typos and human error. The best way to guard against this is scripting. Part 1: Create the new database. You need to create a database to rename the tables into:. This is as simple as:.

2

InnoDB table recovery - Useful things I learned

http://www.usefulthingsilearned.com/2012/03/innodb-table-recovery.html

Useful things I learned. March 25, 2012 7:29 PM. Recently I had a problem where an InnoDB table was corrupted. It was reporting a 2013 error and actually dropping all the connections to the database. This was all that was being reported:. Mysql select * corrupted table;. ERROR 2013 (HY000): Lost connection to MySQL server during query. Innodb force recovery = 4. Truncating the table wasn't an option. Finally I decided to move a backup of the database to another server to try more risky fixes. I skipped -...

3

Inspecting a particular line in a large file - Useful things I learned

http://www.usefulthingsilearned.com/2013/02/inspecting-a-particular-line-in-a-large-file.html

Useful things I learned. Inspecting a particular line in a large file. February 28, 2013 2:24 PM. I had a mysqldump that wasn't playing nice and would error out 745,273 lines into the dump. The error log wasn't useful so to look at the exact line, I did this:. Sed -n "745273 p" dump.sql. Sed -n " linenumber. Sed mysql single line from middle of a file. TrackBack URL: http:/ usefulthingsilearned.com/cgi-bin/movabletype/mt-tb.cgi/13. This page contains a single entry by CJ published on. To find all content.

4

Easily dual heading a laptop and a desktop - Useful things I learned

http://www.usefulthingsilearned.com/2012/07/easily-dual-heading-a-laptop-and-a-desktop.html

Useful things I learned. Easily dual heading a laptop and a desktop. July 24, 2012 10:14 AM. There are times when I need to use my netbook. And desktop together. I've used a KVM setup, but sometimes I want to offload some of my screen space on to the netbook, then it gets annoying. There is a great solution for this called x2vnc. This makes the netbook a second monitor. On my desktop. The setup is simple. Install a VNC server. Of your choice on your laptop. I use tightvnc. July 24, 2012 10:14 AM.

5

Disabling IPv6 in Firefox - Useful things I learned

http://www.usefulthingsilearned.com/2012/03/disabling-ipv6-in-firefox.html

Useful things I learned. Disabling IPv6 in Firefox. March 27, 2012 7:43 PM. Recently I had an issue where a site was restricting itself to a single IPv4 address. Unfortunately the new server that uses it also supported IPv6. When firefox hit it, the server reported that it wouldn't work with the new server. I used my favourite site, icanhazip.com to check, and it reported an IPv6 address. I then entered about:config in the address bad and searched for:. This page contains a single entry by CJ published on.

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

usefulthingsbeautifulthings.blogspot.com

Useful Things, Beautiful Things

Useful Things, Beautiful Things. Wednesday, 24 June 2015. It's been a very long time, hasn't it? It's the usual excuses from me - busy, tired, slight illness etc. We did go to Moscow in March which was fascinating and I am definitely going to write something about that. In fact, I've had an unfinished post about it languishing on Blogger for months - my bad. I've said it, so I have to do it now. Beautiful Things - Cathy. Links to this post. Saturday, 21 February 2015. Not the actual seats. I think I'm go...

usefulthingsforiphone.com

Iphone games apps wallpapers ringtones themes

Iphone wallpapers games apps ringtones themes. Tired of wandering from one website to another in search of your favourite metal bands iphone 5 wallpapers? Here's your chance to stop and choose from our highest quality iphone 5 wallpapers. Apr 6, 2013. IPhone 5S or iPhone 6 prototype? Iphone apps games wallpapers themes. IPhone 5s or iPhone 6 prototype. Leaked iPhone 5s or iPhone 6 images. Apple didn't release any official statement about that. Even these images are fake they are very well done. 8226; Exp...

usefulthingsforme.blogspot.com

usefulthings

Usefulthings' in amacı yararlı, önemli bilgileri biriktirmektir. 6 Mayıs 2011 Cuma. Benden sonra ümmetim hakkında üç şeyden korkarım: Heva ve hevesât sapıklığından, mide ve kadın şehvetine uymaktan, iİlimden sonra gaflete düşmekten. Bu yayına verilen bağlantılar. 9 Mart 2011 Çarşamba. Allah’tan korkun ve doğru söz söyleyin. Çünkü böyle davranırsanız, Allah işlerinizi düzeltir ve günahlarınızı bağışlar.". Hz Muhammed (s.a.v.). Hz Mevlâna Celaleddin-i Rumî (k.s.). Bedenime, kulağıma, gözüme sıhhat ver!

usefulthingsiknow.blogspot.com

Useful Things I Know (.blogspot.com)

Useful Things I Know (.blogspot.com). Tuesday, January 15, 2013. Seagate GoFlex Home running Arch Linux ARM from ext3 partition with ext3 NAS partition. After using the guide here. To get the bootloader onto the GoFlex flash memory (it wipes the original boot sequence, so make sure you really want to do this—keep in mind it is great to do though! Before I began, I downloaded the arch linux ARM files:. Wget http:/ archlinuxarm.org/os/ArchLinuxARM-armv5te-latest.tar.gz. Or whatever the device address is).

usefulthingsilearned.com

Useful things I learned

Useful things I learned. Counting your slow queries by seconds. July 30, 2013 1:42 PM. I needed to check the performance of a database after some changes. This gets me some raw numbers on the performance of the slow queries log in MySQL:. Tail -n 10000 log-slow-queries.log grep Query awk '{print $3}' awk -F . '{print $1}' sort -n uniq -c awk '{print $2" "$1}'. It outputs seconds taken, and number of times that amount has shown up in the logs. Continue reading Counting your slow queries by seconds. From t...

usefulthought-s.blogspot.com

My Thoughts

Sunday, June 28, 2015. Posted by Faraz Haider. Sunday, June 28, 2015. Friday, December 12, 2014. The first book I ever read was Black Beauty. I remember that by the time I reached the end, i couldn't recall the first half of the book. Recently, I read The Notebook. And by the time I got to the end i couldn't help the tears. I am pleasantly surprised to find that a book can be so stirring. Can any of you recommend something that moved you like this? Posted by Faraz Haider. Friday, December 12, 2014. It is...

usefultidbits.com

Price Request - BuyDomains

Url=' escape(document.location.href) , 'Chat367233609785093432', 'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,width=640,height=500');return false;". Need a price instantly? Just give us a call. Toll Free in the U.S. We can give you the price over the phone, help you with the purchase process, and answer any questions. Get a price in less than 24 hours. Fill out the form below. One of our domain experts will have a price to you within 24 business hours. United States of America.

usefultidbitsofwisdom.info

Useful Tidbits of Wisdom

Useful Tidbits of Wisdom. Useful Sayings and Insights. The Advantages Of Elliptical Activity Machines Compared To Freestyle Running. Advantage #1: Less Strain. Advantage #2: Simulates Running. Advantage #3: Varying Levels Of Resistance. Benefit #4: Accessible Incline Options. Benefit #5: State-Of-The-Art Features. To get suggestions for the best elliptical trainers. Benefit #6: Comfortable and Entertaining. Some Great Natural Options For Migraine Headaches. To learn more, visit: this site. People who hav...

usefultigress.com

Useful Tigress Blog

A better world is possible, and we can make it real. Gloveboxes, Consent Practices, and Problematic Kinks. Our consent, negotiation, and safety practices are gloveboxes that let us handle dangerous material. The world of kink is generally made up of things that would not be okay to do outside the context of kink. We build structures around these things to answer the question, “how do you know when it. Okay to do that? The ways we engage with. You doing to attain, ensure, and enact consent? For some kinks...