This on HN today: The Architecture Behind A One-Person Tech Startup.
Category Archives: Sys Admin
commandlinefu.com
Check out commandlinefu.com! “commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.”
socat
That’s a lot of databases
It’s true, that is a lot of databases.
8GB data reservation
In the news today: Why All My Servers Have an 8GB Empty File. The idea is to created a /spacer.img file to take up space, so in a crisis you can delete it to free up space.
Database Programming – An Intermediate MySQL Tutorial – Scripting, Data Types, Examples
I found this great collection of notes: Database Programming – An Intermediate MySQL Tutorial – Scripting, Data Types, Examples.
Prepared statement needs to be re-prepared
I have seen this error before, Prepared statement needs to be re-prepared, I’m not sure if I will see it again, but just in case I’m keeping this link…
MySQL admin with Ian Gilfillan
I was doing some reading today and I came upon an old series of articles over on www.databasejournal.com by a dude called Ian Gilfillan:
- MySQL backups
- Database Replication in MySQL
- Restoring lost data from the Binary Update Log
- Optimizing MySQL: Queries and Indexes
- Optimizing MySQL: Hardware and the Mysqld Variables
- MySQL’s Query Cache
- MySQL’s Over-looked and Under-worked Slow Query Log
For the ‘type’ in SQL ‘EXPLAIN’ Ian says: from best to worst the types are: system, const, eq_ref, ref, range, index, all.
It seems this Ian Gilfillan fellow has been rather prolific.
Disable KDE Wallet popup from Chromium
So today I found how to disable kwallet popups from chrome. That’s been annoying me for a while now…
KDEInit could not launch ‘/usr/bin/kcachegrind’
When I open *.xt files from Dolphin on my KDE Plasma desktop Dolphin would lock up while kcachegrind ran and then when I exited kcachegrind Dolphin would complain:
KDEInit could not launch '/usr/bin/kcachegrind'
So what I’ve done is to create a custom kcachegrind.sh script to run xcachegrind properly and then re-associated *.xt files (application/x-kcachegrind) with the new script in Dolphin.
Bug fixed!