On 9 August 2013 15:26, Rory O'Farrell <ofarr...@iol.ie> wrote: > On Fri, 9 Aug 2013 14:53:00 +0200 > janI <j...@apache.org> wrote: > > > On 9 August 2013 13:43, Rory O'Farrell <ofarr...@iol.ie> wrote: > > > > > On Fri, 9 Aug 2013 12:40:25 +0100 > > > Rory O'Farrell <ofarr...@iol.ie> wrote: > > > > > > > On Fri, 9 Aug 2013 11:16:15 +0200 > > > > janI <j...@apache.org> wrote: > > > > > > > > > On 9 August 2013 11:05, FR web forum <ooofo...@free.fr> wrote: > > > > > > > > > > > >As of the time of this mail, the forum vm has been reconfigured > to > > > cope > > > > > > >with a higher load. > > > > > > No change for french forum, we still have error 1040. > > > > > > > > > > > > > > > > Apologies for my joke about snails, the vm is slower than a > sleeping > > > snail. > > > > > > > > > > All forums are handled identically, we dont have a phpBB running pr > > > forum, > > > > > so every forum must be experiencing this. It seems at the moment > the > > > vm is > > > > > swapping itself to a slow death. > > > > > > > > > > I will be on it, in max 30 minutes. > > > > > > > > > > > > > For information: > > > > en-Forum still out at 12:35 UTC+1. > > > > > > > > > > > > > > > > -- > > > > Rory O'Farrell <ofarr...@iol.ie> > > > > > > > > > > > It's back, but slooow! > > > > > > > yes very very slow. > > > > thx to cyrel I have been able to trace mysql while we had the situation, > a > > reconfiguration is highly needed: > > > > --- cut of the analysis result --- > > MySQL Version 5.1.70-0ubuntu0.10.04.1 x86_64 > > --> Should be at least 5.5 preferable 5.6 > > > > SLOW QUERIES > > The slow query log is NOT enabled. > > Current long_query_time = 10.000000 sec. > > You have 9115 out of 103343 that take longer than 10.000000 sec. to > > complete > > --> not real bad, but also not super > > > > WORKER THREADS > > Current thread_cache_size = 8 > > Current threads_cached = 0 > > Current threads_per_sec = 3 > > Historic threads_per_sec = 0 > > --> Threads created per/sec are overrunning threads cached, raise > > thread_cache_size > > > > MAX CONNECTIONS > > Current max_connections = 400 > > Current threads_connected = 254 > > Historic max_used_connections = 268 > > --> can be lowered to 300 > > > > INNODB STATUS > > Current InnoDB index space = 0 bytes > > Current InnoDB data space = 0 bytes > > Current InnoDB buffer pool free = 96 % > > Current innodb_buffer_pool_size = 8 M > > > > --> this shows how little the better performing innodb is used > > > > MEMORY USAGE > > Max Memory Ever Allocated : 19.02 G > > Configured Max Per-thread Buffers : 27.46 G > > Configured Max Global Buffers : 640 M > > Configured Max Memory Limit : 28.09 G > > Physical Memory : 1.96 G > > > > --> Max memory limit exceeds 90% of physical memory, increase phys mem. > > > > QUERY CACHE > > Query cache is enabled > > Current query_cache_size = 256 M > > Current query_cache_used = 11 M > > Current query_cache_limit = 4 M > > Current Query cache Memory fill ratio = 4.53 % > > Current query_cache_min_res_unit = 4 K > > --> query_cache_size seems to be too high. MySQL won't cache query > > results that are larger than query_cache_limit in size > > > > TABLE CACHE > > Current table_open_cache = 64 tables > > Current table_definition_cache = 256 tables > > --> there are 676 tables (384 open tables) > > Current table_cache hit rate is 0% > > --> while 600% of table cache is in use, increase table_cache and > > table_definition_cache value. > > > > TABLE LOCKING > > Current Lock Wait ratio = 1 : 4 > > --> selective use of InnoDB will be an advantage or at least setting > > low_priority_updates=1 and concurrent_insert=2. > > > > I will make the config changes later today, but not doubt about that we > > need a mysql upgrade, and while doing that also a httpd upgrade. I also > > noticed that ubuntu is not at 12.04, this is not a performance problem > but > > only a maintenance problem. > > > > I hope we will slowly see a faster forum, but give me a bit of time to > get > > it done, and please keep reporting errors ! > > > > rgds > > jan I > > > > > > > > -- > > > Rory O'Farrell <ofarr...@iol.ie> > > > > > > --------------------------------------------------------------------- > > I wasn't complaining, just reporting the situation. >
I took it as reporting, and please continue. > > A new error! Makes a change from error 1040 > New error is: > SQL ERROR [ mysqli ] > > Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) [2002] > you caught me redhanded restarting mysql, try again, now it runs with a bigger configuration, but we need more phys mem. rgds jan I. > > > -- > Rory O'Farrell <ofarr...@iol.ie> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > >
