Re: [firebird-support] large system slows over time

2015-05-08 Thread Nick Upson n...@telensa.com [firebird-support]
Your mention of memory paging got me thinking. I expected the output below to show the memory was fully used such that more RAM would help but unless I'm reading this wrong only 5.3Gb is being used and 2.4 GB is unused so more RAM will be no help, can anyone confirm or put me right $ cat

Re: [firebird-support] large system slows over time

2015-05-08 Thread Nick Upson n...@telensa.com [firebird-support]
Hi Steve there is a significant time in iowait and this is a VM, so a disk contention issue at the hyper-visor level ? Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 8 May 2015 at 14:55, Steve Wiser

Re: [firebird-support] large system slows over time

2015-05-08 Thread Steve Wiser st...@specializedbusinesssoftware.com [firebird-support]
Hi Nick, Oops, I noticed on my first email that I said now out of memory when I should have said not out of memory.. Are you by chance using Amazon Web Services? If so I would say maybe your EBS volume was not prewarmed. Either way, it does sound to me that your CPU is waiting for the disk to

Re: [firebird-support] large system slows over time

2015-05-08 Thread Nick Upson n...@telensa.com [firebird-support]
Hi Steve no not AWS We've done tests and the disk does not appear to be under load, maybe we are just not seeing it Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 8 May 2015 at 16:25, Steve Wiser

Re: [firebird-support] large system slows over time

2015-05-08 Thread Steve Wiser st...@specializedbusinesssoftware.com [firebird-support]
Hi Nick, My interpretation of those stats is that you are now out of memory as I always look at the Swap Used. You aren't using any. My experience with Linux is that the OS will take as much memory as it can/needs so it can look like you are maxed out on RAM usage or something, but you really

Re: [firebird-support] large system slows over time

2015-05-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On May 5, 2015, at 2:38 PM, Jesus Garcia jeg...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: Hello, I think the problem is the database fragmentation along the time. I have databases in production 24x7x365. If I backup and restore on a test environment, the time

Re: [firebird-support] large system slows over time

2015-05-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Hi Nick, I have a system that is slowing down the longer it stays running and I'd like to know why. ... Is there any evidence I can gather before I reboot the system which I expect (from past experience) will return the system to the better performance Hmmm If rebooting will

Re: [firebird-support] large system slows over time

2015-05-05 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
El 5/5/2015, a las 12:15, Nick Upson n...@telensa.com [firebird-support] firebird-support@yahoogroups.com escribió: Hi I have a system that is slowing down the longer it stays running and I'd like to know why. The system is running firebird 2.1.5 on centos 5 with an average of 27

Re: [firebird-support] large system slows over time

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
On 5 May 2015 at 12:23, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] firebird-support@yahoogroups.com wrote: In my experience, GC collected by the gbak is different from sweep. I also have a problem with only my big customer (35Gb database) when the system

Re: [firebird-support] large system slows over time

2015-05-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 5-5-2015 12:15, Nick Upson n...@telensa.com [firebird-support] wrote: I have a system that is slowing down the longer it stays running and I'd like to know why. The system is running firebird 2.1.5 on centos 5 with an average of 27 transactions per second and has now been running for 112

Re: [firebird-support] large system slows over time

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
yes, large transaction gap was the first thing I checked Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 5 May 2015 at 12:01, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] firebird-support@yahoogroups.com

Re: [firebird-support] large system slows over time

2015-05-05 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Did you run a Sweep before backup? On 05/05/2015 08:02, Nick Upson n...@telensa.com [firebird-support] wrote: yes, large transaction gap was the first thing I checked Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On

Re: [firebird-support] large system slows over time

2015-05-05 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hi I have a system that is slowing down the longer it stays running and I'd like to know why. The system is running firebird 2.1.5 on centos 5 with an average of 27 transactions per second and has now been running for 112 days. The data throughput is unchanged, data is removed from the

Re: [firebird-support] large system slows over time

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
On 5 May 2015 at 12:09, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] firebird-support@yahoogroups.com wrote: Did you run a Sweep before backup? ​no but then the backup does gc, I'm interested in why the suggestion, I can try it​ Nick Upson, Telensa Ltd, Senior

Re: [firebird-support] large system slows over time

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
On 5 May 2015 at 12:12, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] firebird-support@yahoogroups.com wrote: How does your backup call look like? ​gbak, -user sysdba -pass x -backup hostname:/opt/pathtodb /pathto/backuparea ​ Nick Upson, Telensa Ltd, Senior Operations

Re: [firebird-support] large system slows over time

2015-05-05 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
In my experience, GC collected by the gbak is different from sweep. I also have a problem with only my big customer (35Gb database) when the system become slow and slow over time. The solution was do a gbak with Garbage collect and then a sweep after. First time you do this it will take