| chat.freenode.net #tryton log beginning Fri Feb 28 00:00:01 CET 2014 | ||
| 2014-02-28 00:41 -!- pekka1(~pekka@cm-84.210.54.188.getinternet.no) has joined #tryton | ||
| 2014-02-28 01:04 -!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton | ||
| 2014-02-28 01:06 -!- cedk(~ced@2001:6f8:3aa:1:10ec:9f63:ed26:39f8) has joined #tryton | ||
| 2014-02-28 01:11 -!- cedk(~ced@85.26.36.239) has joined #tryton | ||
| 2014-02-28 01:48 -!- flox(~florent@unaffiliated/flox) has joined #tryton | ||
| 2014-02-28 01:50 -!- woakas1(~woakas@static.13.240.46.78.clients.your-server.de) has joined #tryton | ||
| 2014-02-28 01:57 -!- gremly(~gremly@190.85.36.58) has joined #tryton | ||
| 2014-02-28 01:59 -!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton | ||
| 2014-02-28 02:04 -!- udono1(~udono@ip-176-199-172-145.unitymediagroup.de) has joined #tryton | ||
| 2014-02-28 02:06 -!- rafiu(~Adium@host81-139-178-190.in-addr.btopenworld.com) has joined #tryton | ||
| 2014-02-28 02:15 -!- myrdd`(~myrdd@55d422c9.access.ecotel.net) has joined #tryton | ||
| 2014-02-28 02:25 -!- rafiu1(~Adium@host81-139-178-190.in-addr.btopenworld.com) has joined #tryton | ||
| 2014-02-28 02:30 -!- gremly(~gremly@190.85.36.58) has joined #tryton | ||
| 2014-02-28 03:28 -!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton | ||
| 2014-02-28 03:40 -!- udono(~udono@ip-88-152-168-173.unitymediagroup.de) has joined #tryton | ||
| 2014-02-28 05:35 -!- plantian1(~ian@174.135.6.172) has joined #tryton | ||
| 2014-02-28 06:06 -!- yangoon1(~mathiasb@p549F0C0A.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-02-28 06:41 -!- frispete_(~frispete@p54A9370C.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-02-28 07:07 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton | ||
| 2014-02-28 07:38 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-02-28 08:33 -!- jvblasco(~seba@62.43.196.37.static.user.ono.com) has joined #tryton | ||
| 2014-02-28 08:39 -!- jeancavallo(~giovanni@LVelizy-156-46-68-52.w80-12.abo.wanadoo.fr) has joined #tryton | ||
| 2014-02-28 08:59 -!- pjstevns(~Thunderbi@2001:981:7170:1:a8b1:db7e:7673:8995) has joined #tryton | ||
| 2014-02-28 09:00 -!- cons1L1(d9569fa4@gateway/web/freenode/ip.217.86.159.164) has joined #tryton | ||
| 2014-02-28 09:02 -!- nicoe(~nicoe@22.78-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2014-02-28 09:17 -!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton | ||
| 2014-02-28 09:24 <jvblasco> guys i'm having load and iowait peaks in a tryton server instance | ||
| 2014-02-28 09:25 <jvblasco> centos with postgres from their repo | ||
| 2014-02-28 09:25 <jvblasco> and tryton running in a virtualen with supervisor | ||
| 2014-02-28 09:25 <jvblasco> i think postgres may be de culprit here | ||
| 2014-02-28 09:26 <jvblasco> any tip for a postgres server tunning? | ||
| 2014-02-28 09:26 <jvblasco> i form of documentation | ||
| 2014-02-28 09:26 <jvblasco> in form* | ||
| 2014-02-28 09:27 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton | ||
| 2014-02-28 09:28 <pokoli> jvblasco: maybe this article on postgresql wiki is usefull for you https://wiki.postgresql.org/wiki/Performance_Optimization | ||
| 2014-02-28 09:29 <pokoli> jvblasco: have you incresed the memory of PostgreSQL? default settings are quite conservative | ||
| 2014-02-28 09:44 -!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton | ||
| 2014-02-28 10:10 <jvblasco> pokoli: i didn't, i found a python script called pgtune but i don't know how reliable it is | ||
| 2014-02-28 10:11 <jvblasco> pokoli: btw i think it may be the shared memory as u are saying, cause ppl complains about psql performance in openVZ and it seems the shared memory is the culprit | ||
| 2014-02-28 10:12 <jvblasco> pokoli: https://github.com/gregs1104/pgtune#readme | ||
| 2014-02-28 10:12 -!- cedk(~ced@85.26.36.239) has joined #tryton | ||
| 2014-02-28 10:28 <pokoli> jvblasco: I will prefer doing it manualy instead of using such script :P | ||
| 2014-02-28 10:35 <jvblasco> pokoli: i will try with the script first as i need to suffocate the fire, i will need to read that wiki page though this weekend for fine tunning and gaining control over it | ||
| 2014-02-28 10:36 <cedk> I find running postgresql on a virtual host, not very performant | ||
| 2014-02-28 10:36 <cedk> I think it requires a lot of tunning to be good as on bare metal | ||
| 2014-02-28 10:37 <cedk> also I always advise to run trytond and pg on the same host | ||
| 2014-02-28 10:40 <jvblasco> they are on the same "host" | ||
| 2014-02-28 10:41 <jvblasco> i think i have some problems with memory tunning | ||
| 2014-02-28 10:41 <jvblasco> also the machine is 1GB RAM in an openVZ instance | ||
| 2014-02-28 10:41 <jvblasco> but the postgres is killing the hypervisor with iowait and load peaks | ||
| 2014-02-28 10:43 <jvblasco> if we find that opportunity cost for tunning that postgres to be there without killing the hypervisor is very high, we will do some basic tunning and move to another technology like VMWare or OpenStack | ||
| 2014-02-28 10:44 <cedk> jvblasco: hahahah bare metal! | ||
| 2014-02-28 10:44 <jvblasco> the thing is that an out of load tryton (just a cron action every 5 mins attacking pingdom API) was killing the hypervisor, and my guess is postgres, not tryton | ||
| 2014-02-28 10:47 <pokoli> jvblasco: can I ask you about database size? | ||
| 2014-02-28 10:47 <jvblasco> pokoli: almost empty | ||
| 2014-02-28 10:51 <pokoli> jvblasco: I have run a 6GB on my laptop with postgresql default settings | ||
| 2014-02-28 10:52 <pokoli> jvblasco: and no run iowait and load peaks | ||
| 2014-02-28 10:53 <pokoli> jvblasco: so mabe the problem is how openVZ handles files | ||
| 2014-02-28 10:58 <jvblasco> pokoli: i also had tenloahora oversized and didn't run into any issues. But that machine is really limited | ||
| 2014-02-28 10:58 <jvblasco> pokoli: btw i think openVZ is doing some magic in the problem too | ||
| 2014-02-28 11:00 -!- Telesight(~anthony@77-175-168-222.FTTH.ispfabriek.nl) has joined #tryton | ||
| 2014-02-28 11:52 -!- mariomop(~quassel@181.110.66.240) has joined #tryton | ||
| 2014-02-28 12:20 -!- cons1L1(d9569fa4@gateway/web/freenode/ip.217.86.159.164) has joined #tryton | ||
| 2014-02-28 12:26 -!- hiaselhans(~hiaselhan@212.186.35.254) has joined #tryton | ||
| 2014-02-28 12:28 -!- smarro(~sebastian@190.105.85.74) has joined #tryton | ||
| 2014-02-28 12:33 -!- sharoonthomas(~sharoonth@115.243.127.100) has joined #tryton | ||
| 2014-02-28 12:35 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-02-28 12:38 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-02-28 13:10 <hiaselhans> hi there, heres the guy filing some of those silly bug reports some time ago... | ||
| 2014-02-28 13:11 <hiaselhans> sorry for that, but after playing around a bit with reports, i found it convenient to have the translation context inheritent aswell | ||
| 2014-02-28 13:11 <hiaselhans> so i added those few lines.. should i provide a patch for that (only a few lines) or is it not of interest maybe? | ||
| 2014-02-28 13:12 <udono> hiaselhans: hi, I don't understand | ||
| 2014-02-28 13:13 <hiaselhans> i inherited some report from companyreport for example | ||
| 2014-02-28 13:13 <hiaselhans> and set my name to something.something | ||
| 2014-02-28 13:14 <hiaselhans> and in order not to provide all translation context but use the one from sale.sale instead i have to call TranslationFactory with a different class property | ||
| 2014-02-28 13:15 <hiaselhans> other than __name__ which is something.something :) | ||
| 2014-02-28 13:18 <udono> hiaselhans: if you think your patch could be interesting for someone else, just send it to the tryton-contrib group. If you think it should be included in main tryton, file an issue and fight your codereview ;-) | ||
| 2014-02-28 13:19 <udono> hiaselhans: https://groups.google.com/forum/#!forum/tryton-contrib | ||
| 2014-02-28 13:22 <hiaselhans> thanks, ill just use the mailinglist :) | ||
| 2014-02-28 13:25 -!- pjstevns(~Thunderbi@2001:981:7170:1:a8b1:db7e:7673:8995) has left #tryton | ||
| 2014-02-28 13:38 -!- hyances(~humberto@181.141.36.235) has joined #tryton | ||
| 2014-02-28 14:06 -!- pablovannini(~pablo@181.47.176.42) has joined #tryton | ||
| 2014-02-28 15:53 -!- sharoonthomas(~sharoonth@115.244.8.152) has joined #tryton | ||
| 2014-02-28 16:16 -!- zodman(~zodman@50.115.163.209) has joined #tryton | ||
| 2014-02-28 16:19 -!- smarro(~sebastian@181.47.135.16) has joined #tryton | ||
| 2014-02-28 16:38 -!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton | ||
| 2014-02-28 16:43 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-02-28 17:29 -!- digitalsatori(~Thunderbi@114.92.199.176) has joined #tryton | ||
| 2014-02-28 17:48 -!- smarro_(~sebastian@host100.190-136-175.telecom.net.ar) has joined #tryton | ||
| 2014-02-28 17:52 -!- smarro(~sebastian@host100.190-136-175.telecom.net.ar) has joined #tryton | ||
| 2014-02-28 17:58 -!- hyances(~humberto@181.141.36.235) has joined #tryton | ||
| 2014-02-28 18:00 -!- lukio(~lukio@181.47.176.42) has joined #tryton | ||
| 2014-02-28 18:14 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton | ||
| 2014-02-28 18:28 -!- digitalsatori(~Thunderbi@114.92.199.176) has joined #tryton | ||
| 2014-02-28 18:31 -!- lukio(~lukio@181.47.176.42) has left #tryton | ||
| 2014-02-28 18:43 -!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton | ||
| 2014-02-28 18:50 -!- cedk(~ced@85.26.36.239) has joined #tryton | ||
| 2014-02-28 18:50 -!- zodman(~zodman@50.115.163.209) has joined #tryton | ||
| 2014-02-28 18:52 -!- mariomop(~quassel@181.110.66.240) has joined #tryton | ||
| 2014-02-28 18:54 -!- sisalp(~sisalpuse@gratoox.sisalp.net) has joined #tryton | ||
| 2014-02-28 19:02 -!- zodman(~zodman@50.115.163.209) has joined #tryton | ||
| 2014-02-28 19:15 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-02-28 19:38 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-02-28 21:22 -!- pablovannini(~pablo@181.47.176.42) has joined #tryton | ||
| 2014-02-28 21:52 -!- hyances(~humberto@181.141.36.235) has joined #tryton | ||
| 2014-02-28 23:30 -!- zodman(~zodman@50.115.163.209) has joined #tryton | ||
| 2014-02-28 23:39 -!- zodman(~zodman@50.115.163.209) has joined #tryton | ||
| 2014-02-28 23:43 -!- ArtGravity(~artgravit@2602:47:d89d:b600:7003:f174:5b10:713b) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!