{"action":"created","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/7440","labels_url":"https://api.github.com/repos/piwik/piwik/issues/7440/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/7440/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/7440/events","html_url":"https://github.com/piwik/piwik/issues/7440","id":62035958,"number":7440,"title":"Still bad performance with 2.12.b5","user":{"login":"sdosg","id":3863288,"avatar_url":"https://avatars.githubusercontent.com/u/3863288?v=3","gravatar_id":"","url":"https://api.github.com/users/sdosg","html_url":"https://github.com/sdosg","followers_url":"https://api.github.com/users/sdosg/followers","following_url":"https://api.github.com/users/sdosg/following{/other_user}","gists_url":"https://api.github.com/users/sdosg/gists{/gist_id}","starred_url":"https://api.github.com/users/sdosg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sdosg/subscriptions","organizations_url":"https://api.github.com/users/sdosg/orgs","repos_url":"https://api.github.com/users/sdosg/repos","events_url":"https://api.github.com/users/sdosg/events{/privacy}","received_events_url":"https://api.github.com/users/sdosg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-03-16T10:22:40Z","updated_at":"2015-03-17T03:07:49Z","closed_at":null,"body":"After upgrading to 2.12.b5 i have still big performance issues. \r\n\r\n2.9.2: 740 req/s\r\n2.11.2: 370 req/s\r\n2.12.b5: 400 req/s\r\n\r\nI can still see high cpu consumption by the php fcgi processes (~ 20-25% cpu p. process under load, with 2.9.2 it was ~10-15%).\r\n\r\nsee [Issue 7416](https://github.com/piwik/piwik/issues/7416)"},"comment":{"url":"https://api.github.com/repos/piwik/piwik/issues/comments/82065081","html_url":"https://github.com/piwik/piwik/issues/7440#issuecomment-82065081","issue_url":"https://api.github.com/repos/piwik/piwik/issues/7440","id":82065081,"user":{"login":"GreenReaper","id":383043,"avatar_url":"https://avatars.githubusercontent.com/u/383043?v=3","gravatar_id":"","url":"https://api.github.com/users/GreenReaper","html_url":"https://github.com/GreenReaper","followers_url":"https://api.github.com/users/GreenReaper/followers","following_url":"https://api.github.com/users/GreenReaper/following{/other_user}","gists_url":"https://api.github.com/users/GreenReaper/gists{/gist_id}","starred_url":"https://api.github.com/users/GreenReaper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GreenReaper/subscriptions","organizations_url":"https://api.github.com/users/GreenReaper/orgs","repos_url":"https://api.github.com/users/GreenReaper/repos","events_url":"https://api.github.com/users/GreenReaper/events{/privacy}","received_events_url":"https://api.github.com/users/GreenReaper/received_events","type":"User","site_admin":false},"created_at":"2015-03-17T03:07:49Z","updated_at":"2015-03-17T03:07:49Z","body":"I tried it and it made no difference for me, at least in the number of temporary tables; maybe it would improve things for the original poster, or be a general improvement, though?\r\n\r\nI'm not facing the specific performance issues which sdosg reports; I just noticed temp disk tables where before there were none and I'm trying to eliminate them. (Our two issues may not be related. I should probably not have hopped onto his bug last time, sorry!)\r\n\r\nUnfortunately I'm not on [Solaris/OS X](http://www.arubin.org/blog/2009/10/02/using-dtrace-to-find-queries-creating-disk-temporary-tables/) or able to use [MySQL 5.6](http://www.arubin.org/blog/2011/05/01/using-mysql-5-6-to-find-queries-creating-disk-temporary-tables/) easily on Debian, or it might be easier to trace these tables down."}}