{"action":"closed","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/11588","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/11588/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/11588/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/11588/events","html_url":"https://github.com/owncloud/core/issues/11588","id":45807286,"number":11588,"title":"PUT requests very SLOW","user":{"login":"loripino21","id":6582956,"avatar_url":"https://avatars1.githubusercontent.com/u/6582956?v=4","gravatar_id":"","url":"https://api.github.com/users/loripino21","html_url":"https://github.com/loripino21","followers_url":"https://api.github.com/users/loripino21/followers","following_url":"https://api.github.com/users/loripino21/following{/other_user}","gists_url":"https://api.github.com/users/loripino21/gists{/gist_id}","starred_url":"https://api.github.com/users/loripino21/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/loripino21/subscriptions","organizations_url":"https://api.github.com/users/loripino21/orgs","repos_url":"https://api.github.com/users/loripino21/repos","events_url":"https://api.github.com/users/loripino21/events{/privacy}","received_events_url":"https://api.github.com/users/loripino21/received_events","type":"User","site_admin":false},"labels":[{"id":12406434,"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929","default":true},{"id":80995269,"url":"https://api.github.com/repos/owncloud/core/labels/performance","name":"performance","color":"fbca04","default":false},{"id":751771728,"url":"https://api.github.com/repos/owncloud/core/labels/status/STALE","name":"status/STALE","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":{"login":"DeepDiver1975","id":1005065,"avatar_url":"https://avatars2.githubusercontent.com/u/1005065?v=4","gravatar_id":"","url":"https://api.github.com/users/DeepDiver1975","html_url":"https://github.com/DeepDiver1975","followers_url":"https://api.github.com/users/DeepDiver1975/followers","following_url":"https://api.github.com/users/DeepDiver1975/following{/other_user}","gists_url":"https://api.github.com/users/DeepDiver1975/gists{/gist_id}","starred_url":"https://api.github.com/users/DeepDiver1975/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DeepDiver1975/subscriptions","organizations_url":"https://api.github.com/users/DeepDiver1975/orgs","repos_url":"https://api.github.com/users/DeepDiver1975/repos","events_url":"https://api.github.com/users/DeepDiver1975/events{/privacy}","received_events_url":"https://api.github.com/users/DeepDiver1975/received_events","type":"User","site_admin":false},"assignees":[{"login":"DeepDiver1975","id":1005065,"avatar_url":"https://avatars2.githubusercontent.com/u/1005065?v=4","gravatar_id":"","url":"https://api.github.com/users/DeepDiver1975","html_url":"https://github.com/DeepDiver1975","followers_url":"https://api.github.com/users/DeepDiver1975/followers","following_url":"https://api.github.com/users/DeepDiver1975/following{/other_user}","gists_url":"https://api.github.com/users/DeepDiver1975/gists{/gist_id}","starred_url":"https://api.github.com/users/DeepDiver1975/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DeepDiver1975/subscriptions","organizations_url":"https://api.github.com/users/DeepDiver1975/orgs","repos_url":"https://api.github.com/users/DeepDiver1975/repos","events_url":"https://api.github.com/users/DeepDiver1975/events{/privacy}","received_events_url":"https://api.github.com/users/DeepDiver1975/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/11","html_url":"https://github.com/owncloud/core/milestone/11","labels_url":"https://api.github.com/repos/owncloud/core/milestones/11/labels","id":697149,"number":11,"title":"backlog","description":"","creator":{"login":"MTRichards","id":1818977,"avatar_url":"https://avatars2.githubusercontent.com/u/1818977?v=4","gravatar_id":"","url":"https://api.github.com/users/MTRichards","html_url":"https://github.com/MTRichards","followers_url":"https://api.github.com/users/MTRichards/followers","following_url":"https://api.github.com/users/MTRichards/following{/other_user}","gists_url":"https://api.github.com/users/MTRichards/gists{/gist_id}","starred_url":"https://api.github.com/users/MTRichards/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MTRichards/subscriptions","organizations_url":"https://api.github.com/users/MTRichards/orgs","repos_url":"https://api.github.com/users/MTRichards/repos","events_url":"https://api.github.com/users/MTRichards/events{/privacy}","received_events_url":"https://api.github.com/users/MTRichards/received_events","type":"User","site_admin":false},"open_issues":703,"closed_issues":1243,"state":"open","created_at":"2014-06-20T19:52:03Z","updated_at":"2018-02-23T01:17:45Z","due_on":null,"closed_at":null},"comments":41,"created_at":"2014-10-14T22:15:23Z","updated_at":"2018-02-23T01:17:45Z","closed_at":"2018-02-23T01:17:45Z","author_association":"NONE","body":"Steps to reproduce\nJust upload files with Windows Client 1.6.3 Or even 1.7.0 alpha\n\nExpected behaviour\nUpload many files (at least 100, if smaller than 100bytes?) within the same minute\nActual behaviour\nOnly few files uploaded in a minute, Apache logs report that a PUT request takes 13-15 SECONDS to be served\n![cattura](https://cloud.githubusercontent.com/assets/6582956/4637397/11003a3e-53ec-11e4-9f56-b896947d130d.JPG)\n\nServer configuration\nOperating system: XUbuntu 14.04 in a HyperV machine, Windows Server 2012 R2 as Host, fixed vhdx HD, 3000 MB of ram expandable up to 8GB, Vm with 4 cores, Vm never uses more than 10% cpu.\n\nWeb server: Apache 2.4.7\nDatabase: MySQL 5.5\nPHP version: 5.5.9\nownCloud version: 7.0.2.1\nList of activated apps: standard\nThe content of config/config.php:\n'trusted_domains' => \n  array (\n    0 => 'cloud.mydomain.it',\n    1 => '192.168.0.20',\n  ),\n  'overwritehost' => 'cloud.mydomain.it',\n  'datadirectory' => '/mnt/owncloud',\n  'dbtype' => 'mysql',\n  'version' => '7.0.2.1',\n  'dbname' => 'owncloud',\n  'dbhost' => '127.0.0.1',\n  'dbtableprefix' => 'oc_',\n\nAre you using external storage, if yes which one: \\mnt\\owncloud is a cifs mount that is a shared directory of windows server on the virtual internal network. mysql saves db in vhd.\n\nAre you using encryption: no\nClient configuration\nBrowser: irrelevant, same effect on all tested browsers and WebDAV clients.\nOperating system: irrelevant, same effect on all tested browsers and WebDAV clients.\n\nPlease let me know if you need any further information. \n\nLogs\n!!! No reuse of etag for 'files/Altro/Software/Sviluppo/adt-bundle-windows/cygwin/usr/share/zoneinfo/posix/Indian' !!! cache: Array ( [fileid] => 181563 [storage] => home::lorenzo [path] => files/Altro/Software/Sviluppo/adt-bundle-windows/cygwin/usr/share/zoneinfo/posix/Indian [parent] => 180844 [name] => Indian [mimetype] => httpd/unix-directory [mimepart] => httpd [size] => 1011 [mtime] => 1413323929 [storage_mtime] => 1413323929 [encrypted] => [unencrypted_size] => 0 [etag] => 543d9c9cb7ba9 [permissions] => 31 ) data: Array ( [mimetype] => httpd/unix-directory [mtime] => 1413323933 [size] => -1 [etag] => 543d9c9d37ca4 [storage_mtime] => 1413323933 [permissions] => 31 [parent] => 180844 ) \n\nFrom Apache log:\n192.168.0.10 - lorenzo [15/Oct/2014:00:08:19 +0200] \"PUT /remote.php/webdav/Altro/Software/Sviluppo/adt-bundle-windows/cygwin/usr/share/zoneinfo/right/Africa/Dar_es_Salaam HTTP/1.1\" 201 869 \"-\" \"Mozilla/5.0 (Windows) mirall/1.6.3\" 14416017\n(last number is duration in microseconds - 10^-6)\n\nsome from mysql slow queries (>1 sec):\nTime: 141014 18:10:32\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.090075  Lock_time: 0.000054 Rows_sent: 0  Rows_examined: 1\nSET timestamp=1413303032;\nUPDATE `oc_preferences` SET `configvalue` = '1413303031' WHERE `userid` = 'lorenzo' AND `appid` = 'login' AND `configkey` = 'lastLogin';\nTime: 141014 18:17:09\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.119346  Lock_time: 0.000089 Rows_sent: 0  Rows_examined: 1\nSET timestamp=1413303429;\nUPDATE `oc_preferences` SET `configvalue` = '1413303428' WHERE `userid` = 'lorenzo' AND `appid` = 'login' AND `configkey` = 'lastLogin';\n[....]\nTime: 141014 18:18:47\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.113130  Lock_time: 0.000165 Rows_sent: 0  Rows_examined: 1\nSET timestamp=1413303527;\nUPDATE `oc_filecache` SET `etag`='543d4ce67feb3' WHERE `fileid` = '168663';\nTime: 141014 18:23:20\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.676195  Lock_time: 0.000099 Rows_sent: 0  Rows_examined: 1\nSET timestamp=1413303800;\nUPDATE `oc_filecache` SET `mtime` = '1413303794', `etag`='543d4df6734c9' WHERE `fileid` = '160433';\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.480039  Lock_time: 0.000073 Rows_sent: 0  Rows_examined: 1\nSET timestamp=1413303800;\nUPDATE `oc_filecache` SET `mtime` = '1413303794', `etag`='543d4df722423' WHERE `fileid` = '981';\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.472505  Lock_time: 0.000032 Rows_sent: 0  Rows_examined: 1\nSET timestamp=1413303800;\nUPDATE `oc_preferences` SET `configvalue` = '1413303799' WHERE `userid` = 'luciano' AND `appid` = 'login' AND `configkey` = 'lastLogin';\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.332344  Lock_time: 0.000065 Rows_sent: 0  Rows_examined: 0\nSET timestamp=1413303800;\nINSERT INTO `oc_jobs`(`class`, `argument`, `last_run`) VALUES('OC\\BackgroundJob\\Legacy\\QueuedJob', '{\\\"app\\\":\\\"search_lucene\\\",\\\"klass\\\":\\\"OCA\\\\Search_Lucene\\\\Hooks\\\",\\\"method\\\":\\\"doIndexFile\\\",\\\"parameters\\\":\\\"{\\\\\"path\\\\\":\\\\\"\\\\\\/Altro\\\\\\/Software\\\\\\/Sviluppo\\\\\\/adt-bundle-windows\\\\\\/cygwin\\\\\\/usr\\\\\\/share\\\\\\/terminfo\\\\\\/6f\\\\\\/otek4114\\\\\",\\\\\"user\\\\\":\\\\\"lorenzo\\\\\"}\\\"}', 0);\nUser@Host: oc_admin[oc_admin] @ localhost [127.0.0.1]\nQuery_time: 1.386712  Lock_time: 0.000029 Rows_sent: 0  Rows_examined: 1\nSET timestamp=1413303800;\nUPDATE `oc_preferences` SET `configvalue` = '1413303799' WHERE `userid` = 'lorenzo' AND `appid` = 'login' AND `configkey` = 'lastLogin';\n"}}
{"actor":{"display_login":"ownclouders"}}