I am running a local database server for 1 client machine.
My DB server runs redis (version 2.6.13) and mysql (5.5.31-30.3-log Percona Server (GPL), Release 30.3).
I have 1 Client machine that runs a java application that access both databases 24/7 and writes and reads data from it. After running my application for several hours, the performance decreases dramatically.
My applications throughput is about "50 operations" per second at the beginning but on the next day it is 0-1. My problem is to really detect where the bottleneck occurs. (internal measurement)
The phenomen is that when i reboot the database server when it is so slow, my application runs fine and fast again. so i think its not on the application side.
But after monitoring my DB server i cannot find any bottleneck.
Database Machine: i3-2120T CPU @ 2.60GHz, Samsung SSD 840 Pro 256GB, 32GB RAM, debian 7.0
http://pastie.org/private/ygnojx0vmxb8g36rwzmf8g (redis frequently has high cpu load)
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle = 1
I also noticed that firewall throughput incrased dramatically at about 4am this morning...
LINK = i.stack.imgur.com/L4dMq.png (sorry cant post more links because of reputation < 10)
Client Machine: i7-2700K CPU @ 3.50GHz, Samsung SSD 840 128GB, 8GB RAM, debian 7.0