innodb_stats_sample_pages to save a day
i’ve run into nasty instability in mysql’s query execution plan joining few tables with 10s of millions of rows. mysql 5.1’s innodb_stats_sample_pages seem to solve the problem.
[pl] asmax ar 901 + netia dsl z 8 publicznymi adresami ip
pare informacji o tym jak skonfigurowac publiczna podsiec /29 na routerze netii asmax ar-901.
lenny to squeeze upgrade – aftermath
few problems/differences i’ve noticed after upgrade of debian.
opera mini 6 + rss feed
opera mini is a great mobile web browser. new release just got out; yet rss [quite an important features for me] seems to be a sort of neglected functionality. here’s how to get it to work in v6.
andalucia/algarve/extramedura
seem that it is my yearly routine. i was in spain/portugal for 2 weeks visiting places i know and discovering some new ones. all in march 2011.
“This Update Package is not compatible with your system configuration” during dell firmware upgrade
i encountered that error while upgrading firmware for PERC6/I raid controller on dell’s poweredge 1950 server.
intel x-25m ssd problems under linux
i got my hands on INTEL SSDSA2M120G2GC disk. read performance was perfect but during writes it was throwing kernel errors left and right:
chmod gou+rwx -R / ?
once in a while i press enter too early. end result of changing permissions on the whole file system can be quite bad.
heartbeat – generic HA configuration
few configuration files i use on highly-available active-standby clusters running under debian.
spanish – useful web resources
some tests and flashcards: http://quizlet.com/subject/spanish/ fully-blown spanish learning websites: http://www.spanishdict.com/ http://www.spanishtown.ca/
201008 spain, portugal
10 days off – andalucia + algarve
php / adodb – memory usage
i’ve got seemingly simple php script running every night on one of my servers… on the same machine i started to experience nightly oom-killer. i’ve found out that adodb’s Execute statement can do something completely else than you would expect from it – it loads whole result into memory rather than going row-by-row.
firefox speedup
from this site. and it seems to be working. Go to MenuTools -> Error Console Paste the following in the “Code:” text-box: Press Enter or click Evaluate. The database will thence be vacuumed immediately.
setting compression level for GZIPOutputStream in java
i’m compressing quite a lot of data on the fly to save storage… until now i’ve been quite sure one cannot control compression level with oracle java’s GZIPOutputStream but apparently i was wrong.
squid3 – basic config and more
it’s been a while since i’ve set up any [non]caching proxy servers. i’ve mostly dealt with reverse proxies, apache2 in 90% of cases, nginx – in few. below few copy&paste configs.
samba, rsync, rdiff
sometimes my backups are not consistent. rsync / samba to blame?
istj
i’m one of them.
dd-wrt on dlink dir-600 b2 router
my old linksys router died violently – power led shines, but links on all lan ports were going down after few seconds from bootup. i bought replacement dlink dir-600 and decided to try dd-wrt firmware on it. it went better than expected!.
talking to SphinxQL from java
since a while Sphinx search can be queried not only by their own non-standard interface but also using regular mysql client. they call this feature SphinxQL.
replacement for esva
i’ve been happy user of ESVA / global-domination [virtual in my case] appliance for mail and antivirus filtering. unfortunately it seems that was one-man project and it’s pretty much dead by now. official website – http://www.global-domination.org/ no longer works since ~ march 2010.