Monitor mysql cache by fincore

Fincore is a perl script and can monitor the mysql cache.

[root@DB01 logs]# du -h performance_log_080318.MYD
1.1G performance_log_080318.MYD
[root@DB01 logs]# perl /tmp/fincore --justsummarize performance_log_080318.MYD
page size: 4096 bytes
497 pages, 1.9 Mbytes IN core FOR 1 file; 497.00 pages, 1.9 Mbytes per file.
[root@DB01 logs]# du -h performance_log_080319.MYD
229M performance_log_080319.MYD
[root@DB01 logs]# perl /tmp/fincore --justsummarize performance_log_080319.MYD
page size: 4096 bytes
28415 pages, 111.0 Mbytes IN core FOR 1 file; 28415.00 pages, 111.0 Mbytes per file.
[root@DB01 logs]#