BLOG

Technical tips collected over several decades in IT

Use FORCE INDEX

Just putting this here as I have a SELECT in MySQL that was taking 1.946 sec to return 20 records from a table with 159884 records when using a ORDER BY DESC on a DATETIME field Creating an index and changing the FROM to FORCE INDEX () dropped it down to 0.00079 sec /...

glabels-3-batch on Fedora 25 segfault

The default glabels-3.4.x install on Fedora 25 through 29 segfaults when using the glabels-3-batch command. The following command fails: glabels-3-batch -o output.pdf -i crossdock-data.csv 150x200-crossdock-labels.glabels I found compiling from source with defaults...

seLinux won’t exec my .pl

This error in httpd error_log [Wed Jul 12 21:39:57.069313 2017] [cgi:error] [pid 16811] [client 127.0.0.1:35330] AH01215: (13)Permission denied: exec of '/home/rupert/Sites/client1-www/cgi-bin/refnum.pl' failed:/home/rupert/Sites/client1-www/cgi-bin/refnum.pl [Wed Jul...

Login

Blog History