Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Data:
Database Machine: i3-2120T CPU @ 2.60GHz, Samsung SSD 840 Pro 256GB, 32GB RAM, debian 7.0

vmstat 1
http://pastie.org/private/lxyly9zvulchxht2yn1rva

top
http://pastie.org/private/ygnojx0vmxb8g36rwzmf8g (redis frequently has high cpu load)

/etc/sysctl.conf
vm.overcommit_memory=1
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle = 1

sar
pastie.org/private/zmtafb7mg18cka0ovg7v2w

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

share|improve this question
1  
Collect metrics with Cacti or Munin for a start. –  HTTP500 Jun 12 '13 at 12:26
    
pastie.org is unresponsive for me –  PP. Jun 12 '13 at 14:10
    
Run sar as well, you can paste results here. –  aseq Jun 12 '13 at 19:15
    
i added the "sar" output now... hope it helps :| –  unr3al011 Jun 13 '13 at 11:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.