[amado@gravedigger apps]$ cd ~/.local/share/ksysguard/ [amado@gravedigger ksysguard]$ ls total 16 drwx------ 2 amado amado 4096 Nov 3 23:11 . drwxr-x--- 37 amado amado 4096 Dec 16 07:39 .. -rw-rw---- 1 amado amado 1053 Dec 16 21:58 ProcessTable.sgrd -rw-rw---- 1 amado amado 1399 Dec 16 21:58 SystemLoad2.sgrd [amado@gravedigger ksysguard]$ rm * [amado@gravedigger ksysguard]$ ksysguard &
For a couple of week now I’ve been wanting to configure a podcatcher on my FreeNas Box. I researched all of the existing plugins, and none of them had any podcatching functionalities. Continue reading “FreeNas Podcatcher: Bashpodder” »
The first step, of course, is to download the deb package. In my case I downloaded Ubuntu 64 bit. Continue reading “How to install freelancer.com desktop app on arch linux” »
The docs show how to configure access control using an environment variable with mod_setenvif. Using the technique described in the docs, I was able to password protect apache’s server-status page.
<Location /server-status> SetHandler server-status SetEnvIf Request_URI "mypassword" continue=1 Order deny,allow Deny from all Allow from env=continue </Location>
Now only you can access the page by going to: http://server.com/server-status/mypassword/
The downside to using the Request_URI attribute is that the password will be visible in your browser history.
Working on a large 20gb innodb table that gets new records inserted daily, I decided to archive some of the old data by splitting the table into many table_archive_2015M subtables by using its `date` column and grouping the data by month.
While running the following query:
insert into ranking_archive_201508 select * from ranking_dailyresults where date >= '2015-08-01' and date < '2015-09-01' LIMIT 500000;
I got the following error from the mysql 5.1 server.
ERROR 1206 (HY000): The total number of locks exceeds the lock table size