last data update: 2011/10/17, 10:30

Website loading time

during the test: 0.22 s

cable connection (average): 0.48 s

DSL connection (average): 0.73 s

modem (average): 14.25 s

HTTP headers

Information about DNS servers

imarketinghacked.comA66.96.134.8IN3600
imarketinghacked.comSOAns1.startlogic.comdnsadmin.startlogic.com201101116010800 3600 604800 3600 IN 3600
imarketinghacked.comTXTv=spf1 ip4:66.96.128.0/18 ?allArrayIN3600
imarketinghacked.comMX30mx.imarketinghacked.comIN3600
imarketinghacked.comNSns1.startlogic.comIN3600
imarketinghacked.comNSns2.startlogic.comIN3600
bonheurdesdames-essaouira.comTXTv=spf1 include:mx.ovh.com ~allArrayIN600
bonheurdesdames-essaouira.comA213.186.33.19IN43200
bonheurdesdames-essaouira.comMX1mx1.ovh.netIN43200
bonheurdesdames-essaouira.comMX5mx2.ovh.netIN43200
bonheurdesdames-essaouira.comMX100mxb.ovh.netIN43200
bonheurdesdames-essaouira.comSOAdns17.ovh.nettech.ovh.net201012140286400 3600 3600000 86400 IN 43200
bonheurdesdames-essaouira.comNSns17.ovh.netIN43200
bonheurdesdames-essaouira.comNSdns17.ovh.netIN43200
avantprime.comSOAns1.misk.comsupport.misk.com201006230914400 7200 950400 7200 IN 7200
avantprime.comMX10smtp.misk.comIN7200
avantprime.comA46.137.161.193IN7200
avantprime.comNSns1.misk.comIN7200
avantprime.comNSns2.misk.comIN7200
ckk.ok.pe.vpslink.comA38.113.1.225IN3600
inredamera.seSOAns1.crystone.netkonferens.businessbudapest.com127050446014400 20000 3600000 3600 IN 3600
inredamera.seA83.168.226.70IN3600
inredamera.seTXTv=spf1 a mxArrayIN3600
inredamera.seMX10vsp1.crystone.seIN3600
inredamera.seMX10vsp2.crystone.seIN3600
inredamera.seIN7200
inredamera.seIN7200
inredamera.seNSns2.crystone.netIN3600
inredamera.seNSns1.crystone.netIN3600
mobilrev.comA173.192.239.157IN14400
mobilrev.comSOAns2629.hostgator.comdnsadmin.gator1315.hostgator.com201110170086400 7200 3600000 86400 IN 43200
mobilrev.comMX0mobilrev.comIN14400
mobilrev.comTXTv=spf1 a mx include:websitewelcome.com ~allArrayIN14400
mobilrev.comNSns2630.hostgator.comIN43200
mobilrev.comNSns2629.hostgator.comIN43200
stimulnmall.com.vpslink.comA38.113.1.225IN3600
everythingabout.netSOAhidden-ns.everythingabout.netpostmaster.everythingabout.net200801150010800 3600 604800 3600 IN 43200
everythingabout.netTXTv=spf1 ip4:38.96.163.21 ip4:38.96.163.22 ip4:38.96.163.23 ip4:38.96.163.24 ip4:38.96.163.25 ip4:38.96.163.27 ip4:38.96.163.28 ~allArrayIN43200
everythingabout.netTXTspf2.0/pra ip4:38.96.163.21 ip4:38.96.163.22 ip4:38.96.163.23 ip4:38.96.163.24 ip4:38.96.163.25 ip4:38.96.163.27 ip4:38.96.163.28 ~allArrayIN43200
everythingabout.netA38.96.163.66IN43200
everythingabout.netMX10mx01.your-site.comIN43200
everythingabout.netNSns3.your-site.comIN43200
everythingabout.netNSns1.your-site.comIN43200
everythingabout.netNSns2.your-site.comIN43200
autoliber.esA217.116.0.144IN43200
autoliber.esSOAns1.dominioabsoluto.comhostmaster.ns1.dominioabsoluto.com200603094114400 3600 604800 7200 IN 43200
autoliber.esMX10mx.autoliber.esIN3600
autoliber.esNSns1.dominioabsoluto.comIN43200
autoliber.esNSns2.dominioabsoluto.comIN43200
ejepolitico.com.mxTXTv=spf1 a ip4:161.58.160.7 ip4:161.58.160.10 ip4:128.121.191.0/24 ip4:161.58.160.3 ip4:161.58.75.55 include:g13.spf.mxservers.net -allArrayIN3600
ejepolitico.com.mxMX50mail-fwd.mx.oemgrp.comIN3600
ejepolitico.com.mxA207.56.128.118IN3600
ejepolitico.com.mxSOAdns2.terra.com.mxcastmty.corp.terra.com.mx20080501013600 3600 1209600 3600 IN 3600
ejepolitico.com.mxNSdns3.terra.com.mxIN3600
ejepolitico.com.mxNSdns1.terra.com.mxIN3600
ejepolitico.com.mxNSdns2.terra.com.mxIN3600
msk.deA84.19.170.131IN43200
msk.deSOAns3.schlund.dehostmaster.schlund.de201108310228800 7200 604800 86400 IN 43200
msk.deMX20mx01.schlund.deIN43200
msk.deMX10mail.msk.deIN43200
msk.deNSns4.schlund.deIN43200
msk.deNSns3.schlund.deIN43200
latableditalie.beA82.98.86.165IN600
latableditalie.beSOAns1.sedoparking.comhostmaster.sedo.de200702150186400 10800 604800 86400 IN 43200
latableditalie.beNSns1.sedoparking.comIN43200
latableditalie.beNSns2.sedoparking.comIN43200
team-cheops.netA188.165.243.167IN14400
team-cheops.netSOAdns1.maven2-max2.comsupport.mavenhosting.com201104240286400 7200 3600000 86400 IN 43200
team-cheops.netMX0team-cheops.netIN14400
team-cheops.netNSdns1.maven2-max2.comIN43200
team-cheops.netNSdns2.maven2-max2.comIN43200
hlubocky.czMX10smtp-in.trilogic.czIN3600
hlubocky.czA81.0.199.18IN3600
hlubocky.czSOAns1.trilogic.czroot.trilogic.cz201103220328800 7200 1209600 300 IN 3600
hlubocky.czNSns1.trilogic.czIN3600
hlubocky.czNSns2.trilogic.czIN3600
sustainablecitiescollective.comSOAns57.1and1.comhostmaster.1and1.com201107180128800 7200 604800 86400 IN 43200
sustainablecitiescollective.comA72.32.52.107IN43200
sustainablecitiescollective.comMX10mx01.1and1.comIN43200
sustainablecitiescollective.comMX10mx00.1and1.comIN43200
sustainablecitiescollective.comNSns58.1and1.comIN43200
sustainablecitiescollective.comNSns57.1and1.comIN43200
rapid-search-engine.comA85.17.230.218IN14400
rapid-search-engine.comSOAns1.rapid-search-engine.comadmin.rapid-search-engine.com201006100686400 7200 1800000 86400 IN 43200
rapid-search-engine.comMX0rapid-search-engine.comIN14400
rapid-search-engine.comNSns0.xname.orgIN43200
rapid-search-engine.comNSns1.xname.orgIN43200
rapid-search-engine.comNSns7.leaseweb.netIN43200
rapid-search-engine.comNSns2.rapid-search-engine.comIN43200
rapid-search-engine.comNSns1.rapid-search-engine.comIN43200
de-ark.beSOAns1.proximedia.comhostmaster.online.be200703212486400 21600 3600000 180 IN 3600
de-ark.beMX10in-mx.online.beIN3600
de-ark.beNSns2.proximedia.beIN3600
de-ark.beNSns1.proximedia.comIN3600
stereocity.deA82.165.94.138IN10800
stereocity.deMX10mx01.kundenserver.deIN43200
stereocity.deMX10mx00.kundenserver.deIN43200
stereocity.deSOAns55.1und1.dehostmaster.1und1.de201007200128800 7200 604800 86400 IN 43200
stereocity.deNSns56.1und1.deIN43200
stereocity.deNSns55.1und1.deIN43200
aaairsoft.frA87.106.116.248IN10800
aaairsoft.frSOAns11.1and1.frhostmaster.1and1.fr200811210128800 7200 604800 86400 IN 43200
aaairsoft.frMX10mx01.1and1.frIN43200
aaairsoft.frMX10mx00.1and1.frIN43200
aaairsoft.frNSns11.1and1.frIN43200
aaairsoft.frNSns12.1and1.frIN43200
gamepark.czTXTgoogle-site-verification:26V6XfSq8oOJ2JQfM4VI39VKRkKcPmbgglNc-Od8_isArrayIN3600
gamepark.czMX30aspmx3.googlemail.comIN3600
gamepark.czMX30aspmx4.googlemail.comIN3600
gamepark.czMX30aspmx5.googlemail.comIN3600
gamepark.czMX10aspmx.l.google.comIN3600
gamepark.czMX20alt1.aspmx.l.google.comIN3600
gamepark.czMX20alt2.aspmx.l.google.comIN3600
gamepark.czMX30aspmx2.googlemail.comIN3600
gamepark.czSOAns.allstar.czadministrator.allstar.cz356900 600 86400 3600 IN 3600
gamepark.czA82.208.14.97IN3600
gamepark.czNSns2.allstar.czIN3600
gamepark.czNSns.allstar.czIN3600
itaf.beSOAns1.itaf.euinfo.itaf.be201108170010800 3600 604800 38400 IN 38400
itaf.beA188.93.83.2IN38400
itaf.beMX10mail2.itaf.beIN38400
itaf.beTXTv=spf1 a mx ptr allArrayIN38400
itaf.beNSns1.itaf.euIN38400
itaf.beNSns2.itaf.euIN38400
inmueblesensantafe.com.arTXTv=spf1 include:spf.hostmar.com ?allArrayIN14400
inmueblesensantafe.com.arMX0inmueblesensantafe.com.arIN14400
inmueblesensantafe.com.arMX5mx1.inmueblesensantafe.com.arIN14400
inmueblesensantafe.com.arA200.58.120.13IN14400
inmueblesensantafe.com.arSOAns3.hostmar.comroot.hostmar.com200905220128800 7200 2000000 86400 IN 14400
inmueblesensantafe.com.arNSns4.hostmar.comIN14400
inmueblesensantafe.com.arNSns3.hostmar.comIN14400
bakertillyczech.czMX20m0.itbt.euIN21600
bakertillyczech.czMX10m2.itbt.euIN21600
bakertillyczech.czSOAdns.tgc.plhostmaster.itbt.eu201109130110800 3600 604800 21600 IN 21600
bakertillyczech.czA212.244.73.77IN21600
bakertillyczech.czNSdns2.tgc.plIN21600
bakertillyczech.czNSdns.tgc.plIN21600
expoitalyonline.itSOAns1.register.ithostmaster.register.it201103010110800 3600 604800 86400 IN 900
expoitalyonline.itA195.110.124.133IN900
expoitalyonline.itMX10mail.register.itIN900
expoitalyonline.itNSns1.register.itIN900
expoitalyonline.itNSns2.register.itIN900
domtechniczny24.plTXTv=spf a mx ptr ip4:213.218.116.160/27 -allArrayIN43200
domtechniczny24.plMX10mail.hb.plIN43200
domtechniczny24.plMX10poczta.hb.plIN43200
domtechniczny24.plSOAns1.hb.pladmin.hb.pl3010122321600 7200 1209600 172800 IN 3600
domtechniczny24.plA94.23.9.111IN43200
domtechniczny24.plNSns1.hb.plIN43200
domtechniczny24.plNSns2.hb.plIN43200
deepsixbklyn.comA174.121.38.58IN14400
deepsixbklyn.comSOAns1179.websitewelcome.comsunnyjaswani008.gmail.com201008160086400 7200 3600000 86400 IN 43200
deepsixbklyn.comMX0deepsixbklyn.comIN14400
deepsixbklyn.comTXTv=spf1 a mx include:websitewelcome.com ~allArrayIN14400
deepsixbklyn.comNSns1180.websitewelcome.comIN43200
deepsixbklyn.comNSns1179.websitewelcome.comIN43200
pornvat.comA209.200.2.161IN43200
pornvat.comMX10filter.pornvat.comIN43200
pornvat.comSOAns.webair.netwebmaster.pornvat.com201010260110800 3600 604800 43200 IN 43200
pornvat.comNSns.webair.netIN43200
pornvat.comNSns2.webair.netIN43200
nn-immobilien.deSOAns12.verio.dehostmaster.verio.de200904301110000 3600 604800 86400 IN 43200
nn-immobilien.deMX50nn-immobilien.deIN43200
nn-immobilien.deA213.198.53.221IN43200
nn-immobilien.deNSns13.verio.deIN43200
nn-immobilien.deNSns12.verio.deIN43200
burlehouse.com.arA64.95.245.65IN14400
burlehouse.com.arTXTv=spf1 a:sinspam.com/24 a:fl64.sinspam.com/24 a:mia1.sinspam.com/24 ~allArrayIN14400
burlehouse.com.arMX20bkpI.sinspam.comIN14400
burlehouse.com.arMX30bkpII.sinspam.comIN14400
burlehouse.com.arMX10mxpri.fl65.sinspam.comIN14400
burlehouse.com.arSOAns1.sinspam.comsoporte.sinspam.com201110130914400 14400 604800 14400 IN 14400
burlehouse.com.arNSns2.sinspam.comIN14400
burlehouse.com.arNSns1.sinspam.comIN14400
cewekeksibisionis.wordpress.comCNAMElb.wordpress.comIN14400
film-promotionnel.comTXTv=spf1 include:mx.ovh.com ~allArrayIN600
film-promotionnel.comA213.186.33.87IN43200
film-promotionnel.comMX1mx1.ovh.netIN43200
film-promotionnel.comMX5mx2.ovh.netIN43200
film-promotionnel.comMX100mxb.ovh.netIN43200
film-promotionnel.comSOAdns18.ovh.nettech.ovh.net201105090086400 3600 3600000 86400 IN 43200
film-promotionnel.comNSns18.ovh.netIN43200
film-promotionnel.comNSdns18.ovh.netIN43200
bubev.deA78.47.243.57IN3600
bubev.deMX0remote.bildung-und-begabung.deIN3600
bubev.deSOAa.ns.linta.dehostmaster.bubev.de130933667416384 2048 1048576 2560 IN 2560
bubev.deNSa.ns.linta.deIN43200
bubev.deNSb.ns.linta.deIN43200
lekkos.noSOAdns.direkte.nohostmaster.direkte.no201009200310800 3600 604800 10800 IN 10800
lekkos.noMX2001-exchange.midpoint.seIN10800
lekkos.noA195.18.229.16IN10800
lekkos.noNSsec.direkte.noIN10800
lekkos.noNSdns.direkte.noIN10800
indianprinterpublisher.comA174.121.79.98IN14400
indianprinterpublisher.comSOAns1.indianprinterpublisher.comsystem-notifications.webserversystems.com201109080386400 7200 3600000 86400 IN 43200
indianprinterpublisher.comMX0indianprinterpublisher.comIN14400
indianprinterpublisher.comNSns2-r4-dallas.webserversystems.comIN43200
indianprinterpublisher.comNSns1-r4-dallas.webserversystems.comIN43200
boatmotors.comA209.63.105.8IN43200
boatmotors.comMX0mailbag2.iboats.comIN43200
boatmotors.comSOAdns1.iboats.comhostmaster.boatmotors.com131671993716384 2048 1048576 2560 IN 2560
boatmotors.comNSdns1.iboats.comIN43200
boatmotors.comNSdns2.iboats.comIN43200
arenamovil.comA173.199.156.193IN300
arenamovil.comSOAns1.name.comsupport.name.com110800 3600 604800 3600 IN 300
arenamovil.comNSns2.name.comIN300
arenamovil.comNSns4.name.comIN300
arenamovil.comNSns1.name.comIN300
arenamovil.comNSns3.name.comIN300
econservationcommerce.comSOAns1.star-domain.jproot.sv0.star-domain.jp010800 3600 604800 3600 IN 3600
econservationcommerce.comMX0econservationcommerce.comIN3600
econservationcommerce.comA125.206.115.96IN3600
econservationcommerce.comNSns1.star-domain.jpIN3600
econservationcommerce.comNSns2.star-domain.jpIN3600
econservationcommerce.comNSns3.star-domain.jpIN3600
adbux.orgTXTv=spf1 a mx a:adbux.org ip4:63.135.227.83 ?allArrayIN38400
adbux.orgMX5mail.adbux.orgIN38400
adbux.orgA63.135.227.83IN38400
adbux.orgSOAserver1.bidjit.comroot.server1.bidjit.com128787546510800 3600 604800 38400 IN 38400
adbux.orgNS198.31.248.130IN38400
adbux.orgNS198.31.248.134IN38400
adbux.orgNSserver1.bidjit.comIN38400
nicj.netA64.34.182.211IN43200
nicj.netTXTv=spf1 a mx ip4:64.34.166.71 ip4:64.34.182.211 ~allArrayIN43200
nicj.netSOAns1.geodns.netnicjansma.comcast.net3410800 3600 604800 86400 IN 43200
nicj.netMX10nicj.netIN43200
nicj.netNSns1.geodns.netIN43200
nicj.netNSns2.geodns.netIN43200

Received from the first DNS server

Received from the second DNS server

Subdomains (the first 50)

Typos (misspells)

bicj.net
micj.net
jicj.net
hicj.net
nucj.net
njcj.net
nkcj.net
nocj.net
n9cj.net
n8cj.net
nixj.net
nivj.net
nifj.net
nidj.net
nich.net
nicn.net
nicm.net
nick.net
nici.net
nicu.net
icj.net
ncj.net
nij.net
nic.net
incj.net
ncij.net
nijc.net
nnicj.net
niicj.net
niccj.net
nicjj.net

Location

IP: 64.34.182.211

continent: NA, country: United States (USA), city: Herndon

Website value

rank in the traffic statistics:

There is not enough data to estimate website value.

Basic information

website build using CSS

code weight: 98.23 KB

text per all code ratio: 63 %

title: NicJ.net

description: Home to Nic Jansma

keywords: nic jansma

encoding: UTF-8

language: en

Website code analysis

one word phrases repeated minimum three times

PhraseQuantity
the513
to303
and217
of184
for108
in104
that100
is92
on92
my79
this67
was67
with64
it56
as54
you51
be49
The46
MySQL45
are44
from44
or36
can36
will34
have33
character32
UTF-831
column31
your29
an29
columns29
some29
temporary28
if28
set26
but26
Cache-Control25
header25
by25
all25
so25
at24
which24
tables23
had23
how22
out22
should21
TEXT21
table21
I’ve21
what21
Expires21
latin121
script21
data21
query20
were20
these20
not20
into19
they19
has19
same19
characters19
only18
using18
back18
server18
their18
disk18
Paulo18
been18
two17
get17
first17
about16
time16
up16
work16
rows16
SELECT16
them16
would16
do16
when16
city15
found15
PHP15
I’m15
MyTable14
use14
problem14
201114
performance14
VARCHAR14
///14
me14
see14
content13
For13
like13
need13
database12
also12
one12
Kindle12
page12
FROM12
we12
Sao12
CloudFront12
Windows12
print12
WHERE12
could12
...12
conversion11
11
any11
TABLE11
just11
Economist11
other11
convert11
This11
then11
another11
lot11
Android11
years10
now10
via10
much10
on-disk10
there10
new10
couple10
simple10
more10
than10
BINARY10
several10
ALTER10
fields10
both10
bit10
over10
used9
conditionally9
web9
Oct9
started9
original9
able9
headers9
even9
It’s9
no9
before9
taking9
good9
after9
wanted9
reading8
still8
file8
example,8
If8
ETW8
may8
single8
doesn’t8
edition8
take8
cause8
t1.id8
MODIFY8
encoding8
our8
3048
Todoist8
static8
few8
causing8
long7
its7
version7
row7
projects7
issues7
don’t7
changed7
USING7
instead7
interesting7
app7
load7
going7
each7
bytes7
updated7
But7
pretty7
available7
against7
created7
learned7
know7
queries7
many7
GMT7
It7
images7
recently7
Collector7
way7
it’s7
resource7
date7
MyISAM7
MEMORY7
HTTP7
browsers7
NULL7
year7
though7
things6
Amazon6
similar6
site6
One6
CPU6
represented6
didn’t6
am6
changes6
change6
fresh6
Not6
website6
search6
F56
noticed6
stored6
actually6
you’re6
trace6
always6
Economist,6
probably6
look6
100%6
day6
HTTP/1.06
sets6
called6
t26
test6
type6
books6
something6
vs.6
missing6
why6
fields,6
NOT6
since6
returned6
live6
database,6
mysql6
people6
working6
GTD6
size6
default6
command6
MyColumn6
above6
those5
want5
strange5
085
tasks5
run5
São5
Sat,5
Jan5
(via5
specify5
specific5
such5
defaults5
Minifig5
simply5
did5
results5
looked5
VARCHAR(30000)5
tables,5
force5
SQL5
keep5
development5
week’s5
Linux5
well5
You5
most5
contained5
appear5
latest5
There5
because5
around5
browser5
5
issue,5
IO5
writes5
column,5
20105
storage5
great5
made5
(for5
being5
behavior5
code5
find5
end5
full5
utf8)5
In5
problems5
sure5
start5
issue5
TEXT,5
source5
I’ll5
FULLTEXT5
websites5
point5
tmp_table_size5
where5
My5
subsequent5
Microsoft4
little4
what’s4
too4
exact4
took4
hit4
re-validate4
field4
additional4
amazing4
table,4
(and4
2554
along4
activity4
Id4
bus4
ton4
share4
requests4
through4
wasn’t4
worked4
best4
disk. 4
in-memory4
metrics4
244
looking4
released4
variables4
server’s4
hours4
bag4
let4
XML4
work,4
4
4
simple,4
case4
public4
less4
send4
If-Modified-Since4
learn4
format4
As4
isn’t4
think4
fixed4
showed4
Since4
modify4
obvious4
t1,4
table24
t2.t1id4
try4
ORDER4
table14
determine4
characters.4
application4
came4
and,4
different4
t2.*4
BY4
LIMIT4
proper4
To4
fix4
data.4
DEFAULT4
types4
understand4
big4
longer4
IE4
0,4
every4
request4
point,4
Using4
public,4
past4
conditional4
response4
proxies4
there’s4
analysis4
tracing4
UTF-8,4
expiry4
max_heap_table_size4
104
applied4
free3
temporarily3
process3
database:server>3
5.13
lightweight3
last3
“Münchhausen”3
columns. 3
10k3
week3
CONVERT3
creative,3
approximately3
allows3
own3
help3
apps3
review3
server,3
display3
online3
update3
years,3
ways3
often3
Why3
tasks,3
caused3
ideas3
while3
separate3
resulting3
website’s3
including3
maximum3
Performance3
“ü”3
columns,3
above,3
BLOB3
looks3
here3
described3
00113
running3
went3
requires3
ever3
opposed3
engine,3
it.3
ran3
converts3
high3
Please3
latin1,3
needed3
retrieving3
“Graffiti3
Dolk3
These3
utf83
text3
economist.com’s3
across3
Converting3
sequences3
economist.com3
MySQL’s3
displaying3
invalid3
case,3
20093
number3
non-ASCII3
checked3
Series3
post3
initially3
API3
you’ve3
talking3
read3
(on3
term3
+----------------------+--------+3
January3
LIKE3
enough,3
xperf3
Paulo';3
system3
testing3
hope3
C#3
hard3
(ALTER3
program3
right3
really3
ago3
hundreds3
next3
uses3
projects,3
converted3
confirmed3
index3
São3
app,3
todoist.com3
data,3
paid3
better3
minifig3
make3
thing3
is,3
LEGO3
However,3
sequence3
decided3
line,3
Cache-Control:3
down3
show3
time. 3
So3
That3
large3
Expires:3
143
No3
navigations3
whatever3
header.3
files3
tag,3
investigating3
HTTP/1.13
until3
specified3
affected3
max-age3
price3
Chrome3
small3
increase3
current3
due3
reason,3
available,3
validate3
304s3
solution3
Unfortunately,3
subscription3
per3
header,3
Amazon’s3
303

two word phrases repeated minimum three times

PhraseQuantity
of the54
on the27
in the27
to the21
of my21
the same14
with the14
to be13
Sao Paulo12
all of12
Cache-Control header11
the column11
the Cache-Control11
for the11
temporary tables10
that the10
some of10
the script10
need to10
the problem10
and the10
the data10
at the10
wanted to9
able to9
the MySQL9
should be9
to work8
back to8
TABLE MyTable8
the Expires8
will be8
Expires header8
on-disk temporary8
which is8
the original8
ALTER TABLE8
on my8
to do8
the content8
the columns8
from the8
lot of8
into the7
the conversion7
Oct 20117
Paulo Sao7
one of7
character set7
the server7
The Economist7
if the6
can be6
the first6
the resource6
them to6
in latin16
by the6
MyTable WHERE6
is the6
I’ve been6
UTF-8 characters6
to BINARY6
the character6
via the6
MODIFY MyColumn6
MyTable MODIFY6
FROM MyTable6
to see6
have to6
is that6
time to6
it to6
if you6
to use6
column to6
the Android6
what was5
columns that5
Minifig Collector5
print edition5
WHERE city5
If you5
problem on5
Sat, 085
to UTF-85
to convert5
on your5
changed the5
fresh for5
fields to5
08 Oct5
of this5
temporary table5
you can5
USING utf8)5
my PHP5
how much5
as well5
well as5
the database5
For example,5
instead of5
rows in5
to get5
original Cache-Control5
and, The4
the other4
these two4
modify the4
available on4
of their4
set the4
Economist, and,4
from now4
the issue,4
that could4
my first4
in set4
against the4
your Kindle4
this query4
the two4
want to4
columns to4
script to4
it on4
ton of4
t1.id ORDER4
found that4
character in4
end up4
SELECT FROM4
ORDER BY4
the MEMORY4
t2.* FROM4
t2.t1id t1.id4
table1 t1,4
table2 t24
such as4
of your4
t2 WHERE4
WHERE t2.t1id4
FROM table14
BY t1.id4
exact same4
t1, table24
for another4
disk writes4
you should4
data in4
///4
/// 4
along the4
would be4
LIMIT 0,4
to share4
up with4
the bus4
try to4
the disk4
this week’s4
t1.id LIMIT4
/// 4
the UTF-84
to look4
tmp_table_size and4
the city4
you to4
the query4
but not4
There are4
to TEXT,3
the page3
It was3
was to3
the tmp_table_size3
as the3
the default3
no longer3
of these3
and to3
I’m not3
missing the3
so the3
and have3
of disk3
the additional3
and how3
out of3
the live3
TEXT fields,3
edition is3
the exact3
from my3
characters to3
run the3
command line,3
to take3
latin1 and3
latin1 columns3
to another3
do with3
what character3
using the3
start out3
tables and3
me to3
will only3
but they3
hundreds of3
column is3
You can3
to an3
there are3
database was3
though the3
Dolk and3
be able3
city column3
was using3
for all3
about the3
going on3
to new3
that are3
are not3
more than3
updated the3
the best3
column in3
my Windows3
proper UTF-83
about how3
on with3
get applied3
applied to3
the next3
MySQL doesn’t3
bit of3
but I’m3
Windows MySQL3
re-validate the3
latin1 column3
appear to3
vs. VARCHAR3
changes before3
is available3
websites and3
the table3
PHP script3
UTF-8 encoding3
single query3
to disk. 3
was causing3
so wanted3
One of3
columns in3
character encoding3
two TEXT3
TEXT fields3
disk activity3
the TEXT3
Cache-Control headers3
TEXT to3
that has3
for column3
was able3
when using3
2011 No3
Economist on3
This is3
page load3
and disk3
SELECT t2.*3
ETW and3
can cause3
that contained3
script will3
look into3
my tasks3
this case,3
it was3
reading The3
is no3
with my3
and max_heap_table_size3
the changes3
when you3
temporary tables,3
HTTP/1.0 proxies3
storage engine,3
causing the3
the results3
in UTF-83
since the3
see if3
server to3
set to3
and from3
that have3
to change3
Paulo ...3
specify the3
to my3
this point,3
all subsequent3
what the3
of books3
the Minifig3
header for3
resource will3
we see3
I’ve learned3
the print3
over the3
work with3
header is3
for several3
talking to3
there is3
number of3
the site3
if you’re3
taking the3
minifig is3
by Dolk3
how the3
which minifig3
I’ve always3
São Paulo3
“Graffiti by3
São Paulo3
row size3
allows you3
and even3
header should3
Amazon’s CloudFront3
way to3
should take3
cause the3
but the3
the resulting3
in my3

three word phrases repeated minimum three times

PhraseQuantity
Sao Paulo Sao7
all of the7
Paulo Sao Paulo7
some of the7
TABLE MyTable MODIFY6
the Cache-Control header6
MyTable MODIFY MyColumn6
FROM MyTable WHERE6
as well as5
08 Oct 20115
Sat, 08 Oct5
ALTER TABLE MyTable5
the original Cache-Control5
MyTable WHERE city5
t1.id LIMIT 0,4
table2 t2 WHERE4
/// ///4
BY t1.id LIMIT4
WHERE t2.t1id t1.id4
t1.id ORDER BY4
t2 WHERE t2.t1id4
ORDER BY t1.id4
table1 t1, table24
available on the4
Economist, and, The4
t2.* FROM table14
the column to4
t1, table2 t24
FROM table1 t1,4
t2.t1id t1.id ORDER4
one of the4
of the columns4
the problem on3
rows in set3
so wanted to3
applied to new3
get applied to3
to see if3
the resource will3
the Minifig Collector3
The Economist on3
tmp_table_size and max_heap_table_size3
the tmp_table_size and3
Sao Paulo ...3
on the live3
be able to3
“Graffiti by Dolk3
which minifig is3
to work with3
by Dolk and3
TEXT fields to3
my Windows MySQL3
on the server3
allows you to3
SELECT t2.* FROM3
the print edition3
was able to3
original Cache-Control header3
Cache-Control header should3
to do with3
on the Android3
in the first3
of the problem3
the exact same3

B tags

U tags

I tags

images

headers

H1

H2

Oh My Münchhausen!!!

What’s Going On?

The Problem With “ø” Is That It’s Not “ø”

It’s All Bits From MySQL’s Point of View

Why do they differ?

What To Do, What To Do

The Process

The Script

Final Words

H3

Oh My Münchhausen!!!

What’s Going On?

The Problem With “ø” Is That It’s Not “ø”

It’s All Bits From MySQL’s Point of View

Why do they differ?

What To Do, What To Do

The Process

The Script

Final Words

H4

Meta

H5

H6

internal links

addressanchor text
NicJ.net
Home
About
Code
Contact
Amazon S3/CloudFront 304s stripping Cache-Control headers
No comments
New Adventures: Why I’m Leaving Microsoft and What’s Next
8 comments
TiskTasks for Todoist
2 comments
gushed over how much I love todoist.com
second
MySQL: Converting an incorrect latin1 column to utf8
4 comments
http://nicj.net/files/mysql_convert_latin1_to_utf8.phps
Minifig Collector v4
No comments
Android development and the Minifig Collector app
No comments
MySQL: TEXT vs. VARCHAR Performance
14 comments
The Economist, and, The Kindle: Take 2
39 comments
The Economist on your Kindle
the economist_to_kindle.php PHP script
economist_to_kindle.phps
comments for details
slifox
crosscode
read the comments
economist_to_kindle.phps
economist_to_kindle.phps
Todoist.com (and TodoistBackup.exe)
8 comments
wiki
here
The Economist, and, The Kindle
14 comments
economist_to_kindle.phps
mobigen_linux v6.2 build 41
A new version of the script
Older Entries
about
contact
Life
Tech
Amazon S3/CloudFront 304s stripping Cache-Control headers
New Adventures: Why I’m Leaving Microsoft and What’s Next
TiskTasks for Todoist
MySQL: Converting an incorrect latin1 column to utf8
Minifig Collector v4
Android development and the Minifig Collector app
MySQL: TEXT vs. VARCHAR Performance
The Economist, and, The Kindle: Take 2
Todoist.com (and TodoistBackup.exe)
The Economist, and, The Kindle
Register
Log in
Top

external links

addressanchor text
Photos
TL;DR
fallback behavior
HTTP Cache headers
suggested way to set a far expiry date
should take precedence
CloudFront
S3
mod_expires
here
world-class browser
webperf
TiskTasks for Todoist
Android Market
Amazon Android Appstore
character
encodings
UTF-8
latin1
Unicode
ISO 8859-1
default character set
ALTER TABLE
ALTER DATABASE
mysql functions
phpMyAdmin
mysql extension
0xE3
represented in two bytes as described on the Wikipedia UTF-8 page.
htmlentities
iconv
Paul Kortman
fabio
fabio’s blog
ALTER TABLE
fabio’s script
4th series of collectible minifigures
minifigcollector.com
minifigcollector.com
Android OS
Minifigures
Minifig Collector
ZXing
MySQL 5.0.3
65,535 characters
InnoDB has different characteristics
TEXT and BLOB fields are not stored in-row
force the sort to use a disk-based temporary table
mysqltuner.sh
mysql tuning-primer.sh
tmp_table_size/max_heap_table_size
TEXT/BLOB field is included in the sort
Cacti
MySQL has Windows
Windows Performance Tools (WPT) Kit
trace capturing
visual analysis via xperfview
MySQL Slow Query Log
tells us this is the case for results that need temporary tables and have TEXT columns
can
internal temporary table
tmp_table_size
max_heap_table_size
CREATE TABLE
max_heap_table_size
MEMORY engine
VARCHAR
tmp_table_size
max_heap_table_size
here
InnoDB has different performance characteristics
This Week’s Print Edition
crosscode’s latest version
Getting Things Done: The Art of Stress-Free Productivity
GTD
todoist.com
Remember The Milk (RTM)
Todoist
Toodledo
Google Tasks
todo.txt
Lifehacker
covered todoist.com and RTM
Lifehacker: 88 Tech Tricks to Turbocharge Your Day
Upgrade Your Life: The Lifehacker Guide to Working Smarter, Faster, Better
todoist.com
Ajax’y
JSON
Json.NET
todoist.com’s API
The Economist
over $120 a year
$77 a year if you’re a student
this week’s Economist print edition
Kindle 2
customer request discussion on Amazon.com
something’s in the works from The Economist
KindleFeeder.com
Calibre
this post on the blog Fat Knowledge
economist.com
Mobi format
source code from the Fat Knowledge blog
MobiPocket’s /dev/ website
The Economist is (officially) available on the Kindle
Google
Youdao
Xian Guo
Zhua Xia
My Yahoo!
newsgator
Bloglines
iNezha
@nicj
WordPress
mg12
XHTML 1.1
CSS 3
Hosted by ServerBeach
WordPress Plugins