Hallo zusammen, seit nun fast 2 Wochen haben wir erhebliche Problem mit unserer Shopware-Instanz. Erhöhte MySQL Usage sorgt häufig für extrem langsame Seitenaufrufe (>30Sek.). Das System läuft grundsätzlich sehr schnell. Ich habe bereits alle ansatzweise relevanten Themen in diesem Forum diesbzgl. gelesen und auch darüber hinaus versucht herauszufinden, ob allgemeine Server Fehlkonfigurationen die Ursache sein könnten. Leider bin ich nicht wirklich weiter gekommen. Ich werde hier so detailliert wie möglich sämtliche relevanten Konfigurationen unseres Systems aufführen in der Hoffnung, dass einer von euch hier mal behilflich sein kann: Server Setup [list] [*] vServer, 4 GB Ram, 8 GB Dynamisch, Ubuntu[/*] [*] PHP 5.3.2, MySQL 5.1.67, Memory-Limit 128M, GD 2.0, libxml 2.7.6, curl 7.19.7, APC 3.3.3p1[/*][/list] Shopware [list] [*] Version: 4.0.6 (Rev. 7316)[/*] [*] Aktive Plugins: Log, Cron, CronStock, Api, RouterRewrite, Compare, Facebook, Seo, LastArticles, Google, AdvancedMenu, Statistics, Notification, TagCloud, InputFilter, Payment, RestAPI, Heidelpay Payment Standard, Paypal Payment, Heidelpay Actions Standard, SelfHealing.[/*] [*] MarketPlace Plugins: Variantenfilter Eindimensional[/*][/list] Die Spikes treten vermehrt bei intensiver Verwendung des Backends auf. Hier mal ein Auszug unsere MySQL Slow-Query-Log nur von heute Morgen: /usr/sbin/mysqld, Version: 5.1.67-0ubuntu0.10.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument # Time: 130315 12:00:33 # User@Host: database[database] @ localhost [] # Query\_time: 14.370024 Lock\_time: 0.000033 Rows\_sent: 0 Rows\_examined: 0 use tunnelpiercing\_dev; SET timestamp=1363345233; INSERT INTO `s_core_sessions` (`id`, `modified`, `data`, `expiry`) VALUES ('c8fad9a49ae630e992002668a539f1e830fef126', '1363345218', 'Shopware|a:3:{s:3:\"Bot\";N;s:10:\"sOutputNet\";b:0;s:17:\"sCategoryConfig11\";a:1:{s:17:\"sFilterProperties\";s:17:\"19|34|106|111|104\";}}', '1440'); # Time: 130315 12:00:57 # User@Host: database[database] @ localhost [] # Query\_time: 23.107288 Lock\_time: 0.000040 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363345257; INSERT INTO `s_core_sessions` (`id`, `modified`, `data`, `expiry`) VALUES ('7e1d0b98a190ce6e15f2b46c2442c3f1c430bdff', '1363345234', 'Shopware|a:3:{s:3:\"Bot\";N;s:10:\"sOutputNet\";b:0;s:17:\"sCategoryConfig11\";a:1:{s:17:\"sFilterProperties\";s:14:\"23|104|116|107\";}}', '1440'); # Time: 130315 12:01:24 # User@Host: database[database] @ localhost [] # Query\_time: 25.491175 Lock\_time: 0.000035 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363345284; INSERT INTO `s_core_sessions` (`id`, `modified`, `data`, `expiry`) VALUES ('9006355af85f12a1af9d9c74ada4d37918611d7b', '1363345258', 'Shopware|a:3:{s:3:\"Bot\";N;s:10:\"sOutputNet\";b:0;s:17:\"sCategoryConfig11\";a:1:{s:17:\"sFilterProperties\";s:17:\"19|34|106|111|103\";}}', '1440'); # Time: 130315 12:01:38 # User@Host: database[database] @ localhost [] # Query\_time: 12.606469 Lock\_time: 0.000027 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363345298; INSERT INTO `s_core_sessions` (`id`, `modified`, `data`, `expiry`) VALUES ('8df43bbfb96e99b747ffe79a5ae785892e5d161c', '1363345285', 'Shopware|a:3:{s:3:\"Bot\";N;s:10:\"sOutputNet\";b:0;s:17:\"sCategoryConfig11\";a:1:{s:17:\"sFilterProperties\";s:17:\"19|34|106|111|108\";}}', '1440'); # Time: 130315 12:01:46 # User@Host: admin[admin] @ localhost [] # Query\_time: 16.994819 Lock\_time: 0.000024 Rows\_sent: 0 Rows\_examined: 1 use psa; SET timestamp=1363345306; update sessions set click\_time=NOW() where sess\_id='eadf681063d3bb5363d5514ba154aaec'; # Time: 130315 12:01:54 # User@Host: database[database] @ localhost [] # Query\_time: 15.906975 Lock\_time: 0.000054 Rows\_sent: 0 Rows\_examined: 1 use tunnelpiercing\_dev; SET timestamp=1363345314; UPDATE `s_core_auth` SET `lastlogin` = '2013-03-15 12:01:38' WHERE (`username` = 'Daveman'); # Time: 130315 12:02:05 # User@Host: admin[admin] @ localhost [] # Query\_time: 18.655294 Lock\_time: 0.000064 Rows\_sent: 0 Rows\_examined: 1 use psa; SET timestamp=1363345325; UPDATE `sessions` SET `modified` = '1363345306', `data` = 'eadf681063d3bb5363d5514ba154aaec\_\_\_session\_messages|a:0:{}eadf681063d3bb5363d5514ba154aaec\_\_\_key\_check\_wrong|s:5:\"false\";eadf681063d3bb5363d5514ba154aaec\_\_\_show\_license|b:0;eadf681063d3bb5363d5514ba154aaec\_skin\_id|i:1;eadf681063d3bb5363d5514ba154aaec\_max\_button\_length|b:0;eadf681063d3bb5363d5514ba154aaec\_locale|s:5:\"en-US\";eadf681063d3bb5363d5514ba154aaec\_forgery\_protection\_token|s:32:\"010abd32ae562c82778038ebf1a0e9e5\";eadf681063d3bb5363d5514ba154aaec\_\_\_show\_left\_frame|s:4:\"true\";eadf681063d3bb5363d5514ba154aaec\_\_\_session\_context|s:6:\"health\";actionStatus|O:29:\"CommonPanel\_Session\_Namespace\":2:{s:8:\"messages\";a:0:{}s:8:\"liveHops\";i:1;}eadf681063d3bb5363d5514ba154aaec\_last\_shown\_panel|s:5:\"admin\";eadf681063d3bb5363d5514ba154aaec\_last\_page|s:34:\"/admin/health/index?context=health\";breadcrumbs|O:29:\"CommonPanel\_Session\_Namespace\":1:{s:4:\"last\";a:2:{i:0;a:2:{s:4:\"href\";s:5:\"/home\";s:5:\"title\";s:4:\"Home\";}i:1;a:2:{s:4:\"href\";s:7:\"/health\";s:5:\"title\";s:13:\"Server Health\";}}}', `lifetime` = '1800' WHERE (`sess_id` = 'eadf681063d3bb5363d5514ba154aaec'); # User@Host: admin[admin] @ localhost [] # Query\_time: 10.598258 Lock\_time: 0.000033 Rows\_sent: 0 Rows\_examined: 1 SET timestamp=1363345325; update sessions set click\_time=NOW() where sess\_id='eadf681063d3bb5363d5514ba154aaec'; # User@Host: database[database] @ localhost [] # Query\_time: 10.608605 Lock\_time: 0.000202 Rows\_sent: 19 Rows\_examined: 39 use tunnelpiercing\_dev; SET timestamp=1363345325; SELECT s0\_.id AS id0, s0\_.active AS active1, s0\_.name AS name2, s0\_.cols AS cols3, s0\_.rows AS rows4, s0\_.userID AS userID5, s0\_.cell\_height AS cell\_height6, s0\_.article\_height AS article\_height7, s0\_.container\_width AS container\_width8, s0\_.valid\_from AS valid\_from9, s0\_.is\_landingpage AS is\_landingpage10, s0\_.landingpage\_block AS landingpage\_block11, s0\_.landingpage\_teaser AS landingpage\_teaser12, s0\_.seo\_keywords AS seo\_keywords13, s0\_.seo\_description AS seo\_description14, s0\_.valid\_to AS valid\_to15, s0\_.create\_date AS create\_date16, s0\_.template AS template17, s0\_.modified AS modified18, s0\_.show\_listing AS show\_listing19, s1\_.id AS id20, s1\_.emotionID AS emotionID21, s1\_.componentID AS componentID22, s1\_.start\_row AS start\_row23, s1\_.start\_col AS start\_col24, s1\_.end\_row AS end\_row25, s1\_.end\_col AS end\_col26, s2\_.id AS id27, s2\_.name AS name28, s2\_.convert\_function AS convert\_function29, s2\_.description AS description30, s2\_.template AS template31, s2\_.cls AS cls32, s2\_.x\_type AS x\_type33, s2\_.pluginID AS pluginID34 FROM s\_emotion s0\_ LEFT JOIN s\_emotion\_element s1\_ ON s0\_.id = s1\_.emotionID LEFT JOIN s\_library\_component s2\_ ON s1\_.componentID = s2\_.id INNER JOIN s\_emotion\_categories s4\_ ON s0\_.id = s4\_.emotion\_id INNER JOIN s\_categories s3\_ ON s3\_.id = s4\_.category\_id WHERE s3\_.id = 3 AND ((s0\_.valid\_from \<= CURRENT\_TIMESTAMP OR s0\_.valid\_from IS NULL)) AND ((s0\_.valid\_to \>= CURRENT\_TIMESTAMP OR s0\_.valid\_to IS NULL)) AND s0\_.is\_landingpage = 0 AND s0\_.active = 1; # Time: 130315 12:03:54 # User@Host: database[database] @ localhost [] # Query\_time: 12.552226 Lock\_time: 0.000049 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363345434; INSERT INTO `s_core_sessions` (`id`, `modified`, `data`, `expiry`) VALUES ('e28f16a340ebd6e97e572bb889011790175c31dc', '1363345422', 'Shopware|a:3:{s:3:\"Bot\";N;s:10:\"sOutputNet\";b:0;s:17:\"sCategoryConfig11\";a:1:{s:17:\"sFilterProperties\";s:17:\"19|34|106|111|113\";}}', '1440'); # Time: 130315 12:04:39 # User@Host: database[database] @ localhost [] # Query\_time: 12.707245 Lock\_time: 0.000029 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363345479; INSERT INTO `s_core_sessions` (`id`, `modified`, `data`, `expiry`) VALUES ('91457f24fdd673a99ada989235e6e055cadb0199', '1363345466', 'Shopware|a:3:{s:3:\"Bot\";N;s:10:\"sOutputNet\";b:0;s:17:\"sCategoryConfig11\";a:1:{s:17:\"sFilterProperties\";s:14:\"25|108|112|111\";}}', '1440'); # Time: 130315 12:05:08 # User@Host: database[database] @ localhost [] # Query\_time: 25.111237 Lock\_time: 0.000031 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363345508; INSERT INTO `s_core_sessions` (`id`, `modified`, `data`, `expiry`) VALUES ('7bc2726165a2b72e4bc36f51b132465ff076222b', '1363345482', 'Shopware|a:3:{s:3:\"Bot\";N;s:10:\"sOutputNet\";b:0;s:17:\"sCategoryConfig11\";a:1:{s:17:\"sFilterProperties\";s:16:\"19|34|106|111|37\";}}', '1440'); # Time: 130315 12:28:25 # User@Host: database[database] @ localhost [] # Query\_time: 257.970899 Lock\_time: 0.000102 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; DELETE FROM s\_order\_basket WHERE sessionID='b8632d6047982201375ee06d7741b704ca33d7cb' AND modus=3; # User@Host: database[database] @ localhost [] # Query\_time: 255.727013 Lock\_time: 0.000116 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT s0\_.id AS id0 FROM s\_emarketing\_banners s0\_ WHERE (s0\_.valid\_from \<= '2013-03-15 12:24:09' OR (s0\_.valid\_from = NULL OR s0\_.valid\_from IS NULL)) AND (s0\_.valid\_to \>= '2013-03-15 12:24:09' OR (s0\_.valid\_to = NULL OR s0\_.valid\_to IS NULL)) AND s0\_.categoryID = 8; # User@Host: database[database] @ localhost [] # Query\_time: 203.970684 Lock\_time: 0.000057 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT `s_core_sessions`.\* FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = 'b7851ed0c9ac1f34e6efb53f6eb6bab3c87609d9'))); # User@Host: database[database] @ localhost [] # Query\_time: 133.774853 Lock\_time: 0.000115 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT `s_core_sessions`.\* FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = '05cc4f7ac27c2e30fe2756bb9017fbfe519c4b97'))); # User@Host: database[database] @ localhost [] # Query\_time: 100.061133 Lock\_time: 0.000110 Rows\_sent: 1 Rows\_examined: 1 SET timestamp=1363346905; SELECT `s_core_sessions`.\* FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = 'b89d98aa7fcb89119ce96fb145329ef1385fc070'))); # User@Host: database[database] @ localhost [] # Query\_time: 63.528444 Lock\_time: 0.000119 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT `s_core_sessions`.\* FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = '5ee30d572028e93de338e6c0b8c66617726f4b01'))); # User@Host: database[database] @ localhost [] # Query\_time: 60.452305 Lock\_time: 0.000113 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT `s_core_sessions`.\* FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = '083a3e6cc9bfec11fb1762e6fb4ca59639f1a508'))); # User@Host: database[database] @ localhost [] # Query\_time: 39.847014 Lock\_time: 0.000133 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT org\_path, main FROM s\_core\_rewrite\_urls WHERE path LIKE 'favicon.ico' AND subshopID ='1'; # User@Host: database[database] @ localhost [] # Query\_time: 37.281014 Lock\_time: 0.000119 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT `s_core_sessions`.\* FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = 'be5252b5a12dfa21b4fafbdb9c3e356ffb1679e5'))); # User@Host: database[database] @ localhost [] # Query\_time: 32.714818 Lock\_time: 0.000111 Rows\_sent: 1 Rows\_examined: 1 SET timestamp=1363346905; SELECT `s_core_sessions`.\* FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = 'b89d98aa7fcb89119ce96fb145329ef1385fc070'))); # User@Host: database[database] @ localhost [] # Query\_time: 24.099239 Lock\_time: 0.000125 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1363346905; SELECT org\_path, main FROM s\_core\_rewrite\_urls WHERE path LIKE 'favicon.ico' AND subshopID ='1'; # User@Host: admin[admin] @ localhost [] # Query\_time: 23.610699 Lock\_time: 0.000036 Rows\_sent: 1 Rows\_examined: 1 use psa; SET timestamp=1363346905; SELECT `sessions`.\* FROM `sessions` AS `sessions` WHERE (((`sessions`.`sess_id` = 'eadf681063d3bb5363d5514ba154aaec'))); # User@Host: database[database] @ localhost [] # Query\_time: 198.449538 Lock\_time: 0.000121 Rows\_sent: 1 Rows\_examined: 1 use tunnelpiercing\_dev; SET timestamp=1363346905; SELECT org\_path, main FROM s\_core\_rewrite\_urls WHERE path LIKE 'fake-piercings/fake-plug-stahl-kristall-look-141/' AND subshopID ='1'; # User@Host: database[database] @ localhost [] # Query\_time: 140.337182 Lock\_time: 0.000128 Rows\_sent: 1 Rows\_examined: 4 SET timestamp=1363346905; SELECT `s_core_auth`.\*, (CASE WHEN `lastlogin` = (CASE WHEN(`lastlogin`\>='2013-03-15 06:26:05' ) THEN `lastlogin` ELSE 0 END) THEN 1 ELSE 0 END) AS `zend_auth_credential_match` FROM `s_core_auth` WHERE (active=1) AND (lockeduntil \<= NOW()) AND (`sessionID` = '51431fb43bb5df489019b53962fd4d4fdc0033de'); # User@Host: admin[admin] @ localhost [] # Query\_time: 118.976661 Lock\_time: 0.000125 Rows\_sent: 0 Rows\_examined: 0 use psa; SET timestamp=1363346905; insert into log\_actions(date, ip\_address, user, action\_id, object\_id) values (NOW(), '127.0.0.1', '', '105', '0'); # User@Host: database[database] @ localhost [] # Query\_time: 114.169515 Lock\_time: 0.000142 Rows\_sent: 1 Rows\_examined: 4 use tunnelpiercing\_dev; SET timestamp=1363346905; SELECT `s_core_auth`.\*, (CASE WHEN `lastlogin` = (CASE WHEN(`lastlogin`\>='2013-03-15 06:26:31' ) THEN `lastlogin` ELSE 0 END) THEN 1 ELSE 0 END) AS `zend_auth_credential_match` FROM `s_core_auth` WHERE (active=1) AND (lockeduntil \<= NOW()) AND (`sessionID` = 'ec762ce7f32003af719a911b5a63c78ef9b6eaae'); # User@Host: database[database] @ localhost [] # Query\_time: 99.301970 Lock\_time: 0.000111 Rows\_sent: 1 Rows\_examined: 1 SET timestamp=1363346905; SELECT org\_path, main FROM s\_core\_rewrite\_urls WHERE path LIKE 'tunnel-piercings/tunnel-stahl-silber-abgerundet-7/' AND subshopID ='1'; # Time: 130315 12:28:26 # User@Host: database[database] @ localhost [] # Query\_time: 640.356633 Lock\_time: 0.000343 Rows\_sent: 0 Rows\_examined: 5385 SET timestamp=1363346906; SELECT fv.optionID AS id, COUNT(DISTINCT a.id) AS count, fo.id AS optionID, fo.name AS optionName, f.id AS groupID, f.name AS groupName, fv.value AS optionValue, fv.id AS valueID, st.objectdata AS optionNameTranslation, st2.objectdata AS groupNameTranslation, st3.objectdata AS valueTranslation FROM s\_categories c, s\_categories c2, s\_articles\_categories ac JOIN s\_filter\_articles fa ON fa.articleID=ac.articleID JOIN s\_filter\_values fv ON fv.id=fa.valueID JOIN s\_filter\_options fo ON fo.id=fv.optionID AND fo.filterable = 1 JOIN s\_articles a ON a.id=ac.articleID AND a.active =1 AND a.changetime \<= NOW() JOIN s\_filter f ON f.id=a.filtergroupID LEFT JOIN s\_filter\_relations fr ON f.id = fr.groupId AND fo.id = fr.optionId LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID=fa.articleID AND ag.customergroupID=1 LEFT JOIN s\_core\_translations AS st ON st.objecttype='propertyoption' AND st.objectkey=fv.optionID AND st.objectlanguage='' LEFT JOIN s\_core\_translations AS st2 ON st2.objecttype='propertygroup' AND st2.objectkey=f.id AND st2.objectlanguage='' LEFT JOIN s\_core\_translations AS st3 ON st3.objecttype='propertyvalue' AND st3.objectkey=fv.id AND st3.objectlanguage='' INNER JOIN s\_filter\_articles fv34 ON fv34.articleID = a.id AND fv34.valueID = 34 INNER JOIN s\_filter\_articles fv17 ON fv17.articleID = a.id AND fv17.valueID = 17 INNER JOIN s\_filter\_articles fv19 ON fv19.articleID = a.id AND fv19.valueID = 19 INNER JOIN s\_filter\_articles fv27 ON fv27.articleID = a.id AND fv27.valueID = 27 INNER JOIN s\_filter\_articles fv12 ON fv12.articleID = a.id AND fv12.valueID = 12 INNER JOIN s\_filter\_articles fv107 ON fv107.articleID = a.id AND fv107.valueID = 107 INNER JOIN s\_filter\_articles fv108 ON fv108.articleID = a.id AND fv108.valueID = 108 INNER JOIN s\_filter\_articles fv104 ON fv104.articleID = a.id AND fv104.valueID = 104 WHERE c.id=11 AND c2.active=1 AND c2.left \>= c.left AND c2.right \<= c.right AND ac.articleID=a.id AND ac.categoryID=c2.id AND ag.articleID IS NULL GROUP BY fv.id ORDER BY fr.position, fo.name ASC, IF(f.sortmode=1, TRIM(REPLACE(fv.value,',','.'))+0, 0), IF(f.sortmode=2, COUNT(\*) , 0) DESC, IF(f.sortmode=3, fv.position, 0), fv.value; top gibt in der Shell bei spikes folgendes aus: 3181 mysql 15 0 190m 38m 7676 S 99.9 0.9 15:05.15 mysqld 1 root 15 0 23332 1600 1288 S 0.0 0.0 0:02.85 init 1195 root 18 0 49284 2572 2024 S 0.0 0.1 0:00.00 sshd 1222 root 15 0 21096 1020 784 S 0.0 0.0 0:00.00 cron 1246 syslog 15 0 12468 796 608 S 0.0 0.0 0:00.05 syslogd 1257 bind 19 0 123m 13m 2264 S 0.0 0.3 0:00.00 named 1274 root 18 0 13896 696 552 S 0.0 0.0 0:00.00 couriertcpd 1283 root 18 0 4020 612 508 S 0.0 0.0 0:00.00 courierlogger 1285 root 18 0 13896 680 540 S 0.0 0.0 0:00.00 couriertcpd 1287 root 23 0 3888 412 332 S 0.0 0.0 0:00.00 courierlogger 1294 root 15 0 13896 692 552 S 0.0 0.0 0:00.00 couriertcpd 1296 root 18 0 4020 608 508 S 0.0 0.0 0:00.00 courierlogger 1304 root 25 0 13896 680 540 S 0.0 0.0 0:00.00 couriertcpd 1311 root 25 0 3888 412 332 S 0.0 0.0 0:00.00 courierlogger 1324 root 18 0 45860 7124 1380 S 0.0 0.2 0:00.02 python 1360 root 19 0 31400 1568 288 S 0.0 0.0 0:00.00 nginx 1368 nginx 15 0 31404 2664 832 S 0.0 0.1 0:00.56 nginx 1374 root 15 0 19544 976 760 S 0.0 0.0 0:00.00 xinetd 1409 root 15 0 106m 46m 2160 S 0.0 1.1 0:01.41 spamd 1413 popuser 18 0 106m 45m 976 S 0.0 1.1 0:00.00 spamd 1447 qmails 16 0 4076 508 396 S 0.0 0.0 0:00.01 qmail-send 1449 qmaill 18 0 4028 596 500 S 0.0 0.0 0:00.00 splogger 1450 root 16 0 4068 472 348 S 0.0 0.0 0:00.00 qmail-lspawn 1451 qmailr 15 0 4068 496 368 S 0.0 0.0 0:00.00 qmail-rspawn 1452 qmailq 18 0 4024 452 364 S 0.0 0.0 0:00.00 qmail-clean 1568 sw-cp-se 15 0 47564 3740 1668 S 0.0 0.1 0:00.39 sw-cp-serverd 1584 root 15 0 210m 29m 4828 S 0.0 0.7 0:00.34 sw-engine 1611 root 18 0 223m 2504 980 S 0.0 0.1 0:00.49 sw-collectd 1821 root 15 0 79512 3792 2904 R 0.0 0.1 0:00.12 sshd 1832 root 15 0 18020 2144 1520 S 0.0 0.1 0:00.03 bash 1876 popuser 15 0 11000 940 744 S 0.0 0.0 0:00.00 imapd 3851 popuser 15 0 11000 1116 876 S 0.0 0.0 0:00.03 imapd 3853 root 15 0 14452 2084 1620 S 0.0 0.0 0:00.01 couriertls 3882 popuser 16 0 11000 1028 804 S 0.0 0.0 0:00.01 imapd 3884 root 15 0 14452 2068 1620 S 0.0 0.0 0:00.00 couriertls 3886 popuser 15 0 11004 1108 848 S 0.0 0.0 0:00.02 imapd 3888 root 15 0 14452 2084 1620 S 0.0 0.0 0:00.00 couriertls 3890 popuser 15 0 11004 1064 848 S 0.0 0.0 0:00.00 imapd 3892 root 15 0 14452 2076 1620 S 0.0 0.0 0:00.00 couriertls 5367 qmaild 15 0 14192 1184 884 S 0.0 0.0 0:00.00 qmail-smtpd 5493 psaadm 18 0 190m 14m 10m S 0.0 0.4 0:00.02 sw-engine-cgi 5521 psaadm 17 0 204m 24m 5028 S 0.0 0.6 0:00.20 sw-engine-cgi 5523 psaadm 16 0 208m 27m 5132 S 0.0 0.7 0:00.27 sw-engine-cgi 5524 psaadm 18 0 190m 4768 124 S 0.0 0.1 0:00.00 sw-engine-cgi Ich bin mit meinen Latein am Ende und ziehe bereits andere performantere Shopsystem in Erwägung. Shopware gefällt uns grundsätzlich soweit eigentlich ganz gut, jedoch ist das bereits das 3. Performance-Issue das es innerhalb kürzester Zeit für uns zu lösen gilt. Falls mehr Informationen nötig sind, bitte gebt Bescheid. Grüße
Hallo, in dem Query Log tritt eine Filter Query deutlich hervor. Kennst du schon den Wiki Artikel http://wiki.shopware.de/Artikeleigensch … l_890.html? Darin ist beschrieben, dass die MySQL-Option “optimizer_search_depth” auf “0” sein sollte wenn mit umfangreiche Gruppen/Optionen gearbeitet wird. Vielleicht hilft dir das schon. Gruß Patrick
Hi, klar kannst du hier weiter posten. Würde mich auch freuen von dir zu lesen, wenn der Tipp geholfen hat. Gruß Patrick
Das System läuft grundsätzlich etwas stabiler, leider weiterhin spiked die MySQL Cpu Usage. Es hängt definitiv mit dem Backend zusammen. Sobald unser Produktadmin im Backend umhergeistert und Änderungen vornimmt, treten die Spikes vermehrt auf. Gibt es weitere Ratschläge?
Hi, also mit der Shopware 4.1 wird es eine starke Verbesserung der Performance geben. Kannst du uns eventuell noch weitere genauere Infos geben, was passiert wenn euer Produktadmin arbeitet? Hast du da auch irgendwelche slow queries? Gruß Patrick
Hi, ich werde das System jetzt so erstmal bis heute Abend/morgen Früh laufen lassen und dann die komplette slow-querys.log zur Verfügung stellen. Ein genaues Muster scheint nicht erkennbar zu sein, Produkte werden soweit kaum bearbeitet, hauptsächlich Statusänderungen zu Bestellungen werden vorgenommen. Ich behalte es im Auge, für gewöhnlich läuft alles erstmal wieder, nachdem mysql neugestartet wurde. Langfristig natürlich keine Lösung. Ist denn schon das Release von 4.1 absehbar? Unser System ist bereits live und optimal ist die mangelnde Erreichbarkeit natürlich nicht, auch hinsichtlich des Google-Rankings.
Guten Morgen, ein genaues Datum für die 4.1 kann ich dir nicht nennen. Über den aktuellen Stand der Entwicklung kannst du dich aber jederzeit auf unserer Roadmap informieren. Gruß Patrick
Gerade als es spannend wird, bricht der Thread ab 
Sind die mysql Spitzen weg? Läuft jetzt alles wieder schnell? Wenn ja, woran lag es?