KsysGuard Not displaying cpu or network chart values.

All of the solutions that I found online say to delete .kd4/share/apps/ksysguard, or .kde/share/apps/ksysguard. On my arch box, I had to look in .local/share/ksysguard and delete these two files:

[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 &

Password Protect Apache’s Server-status Page

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.

How to split a large innodb table into many tables.

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

Continue reading “How to split a large innodb table into many tables.” »