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…
Category Archives: Sys Admin
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!
How To Use SSHFS to Mount Remote File Systems Over SSH
Some good doco from Digital Ocean over here: How To Use SSHFS to Mount Remote File Systems Over SSH.
Enabling XDebug for PHP under Apache2
Putting these settings in /etc/php/7.2/apache/php.ini did the job:
[XDebug]
xdebug.profiler_enable = 1
xdebug.profiler_output_dir = /tmp/xdebug
xdebug.profiler_output_name = cachegrind.out.%p.%u.%H.%R.xt
The cachegrind files are now written to /tmp/xdebug.
security.txt
This security.txt looks like a good idea.
The documentation system
Today I discovered The documentation system (over here). The four quadrants on two axes are:
- Tutorials
- How-to guides
- Reference
- Explanation
VSCode explorer tree indent size
So I was poking about in my VSCode settings, File -> Preferences -> Settings. And I found the Workbench > Tree: Indent options which controls the tree indentation in pixels. The default settings was 8 pixels, which is too small for my liking, so I cranked it up a notch to 37 pixels! Yay woo!
Wrap setting for Vim mode for VSCode
Over on the VSCodeVim chatroom a bloke called Chris pointed me to the ‘Whichwrap’ setting for Vim mode in VSCode. In VSCode click File -> Preferences -> Settings; then in the Extensions / Vim settings search for ‘Whichwrap’ and enter: l,h