GNU/Linux

Access

Blog History

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 /...

read more

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...

read more