Datenbank abgeschaltet

[drive]

Hallo, heute wurde unsere 1und1 Datenbank abgeschaltet, mit folgender Begründung, die uns per E-Mail erreichte:




wir mussten den Zugang zu oa. Datenbank sperren, da diese hauptverantwortlich für Lastprobleme auf einem unserer Datenbankserver war. Auf unsere Nachricht vom 14.10 haben Sie bisher nicht reagiert.

Falls Sie Ihre Anwendungen in unveränderter Form weiterbenutzen möchten, sollten Sie auf einen dedizierten Server wechseln. Eine Übersicht zu unseren Angeboten finden Sie auf unserer Seite http://1und1.de unter der Rubrik "Produkte" -> "Server" -> "Homepage-Server".

Es handelte sich um Abfragen folgender Form, welche in ihrer grossen Anzahl problematisch sind:

INSERT INTO con_system_prop (idsystemprop, value, type, name) VALUES ('0', 'category', 'plugin', 'frontendlogic-pluginorder') UPDATE con_stat SET visited = visited + 1 WHERE idcatart = '128' AND idclient = '1' AND idlang = '1'
UPDATE con_stat SET visited = visited + 1 WHERE idcatart = '414' AND idclient = '2' AND idlang = '3'
UPDATE con_stat SET visited = visited + 1 WHERE idcatart = '128' AND idclient = '1' AND idlang = '1'
update con_phplib_active_sessions set
val='c2lkXzFfMTokdGhpcy0+aW4gPSAnMCc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGl
zLT5wdFsnYXV0aCddID0gJzEnOyAkdGhpcy0+cHRbJ2NmZ0NsaWVudCddID0gJzEnOyAkdGh
pcy0+cHRbJ2VycnNpdGVfaWRjYXQnXSA9ICcxJzsgJHRoaXMtPnB0WydlcnJzaXRlX2lkYXJ
0J10gPSAnMSc7ICR0aGlzLT5wdFsnZW5jb2RpbmcnXSA9ICcxJzsgJHRoaXMtPnB0WydsYW5
nJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2xpZW50J10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10
gPSBuZXcgQ29udGVuaWRvX0Zyb250ZW5kX0NoYWxsZW5nZV9DcnlwdF9BdXRoOyAkR0xPQkF
MU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWl
kJ10gPSAnbm9ib2R5JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICR
HTE9CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1s
nYXV0aCddLT5hdXRoWyd1bmFtZSddID0gJ25vYm9keSc7ICRHTE9CQUxTWydhdXRoJ10tPmF
1dGhbJ3JlZnJlc2gnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddID0
gYXJyYXkoKTsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWydzZXQnXSA9ICdzZXQnOyAkR0xPQkF
MU1snY2ZnQ2xpZW50J11bJzEnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVs
nMSddWydwYXRoJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsncGF
0aCddWydmcm9udGVuZCddID0gJy9ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9jbXM
vJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICd
odHRwOi8vd3d3LnNjaHVsZXBsdXNlc3Nlbi5kZS9jbXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWV
udCddWycxJ11bJ2ltYWdlcyddID0gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2N
tcy9pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3VwbG9hZCddID0gJ3V
wbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnaHRtbHBhdGgnXSA9IGFycmF
5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydodG1scGF0aCddWydmcm9udGVuZCd
dID0gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2Ntcy8nOyAkR0xPQkFMU1snY2Z
nQ2xpZW50J11bJzEnXVsndXBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11
bJzEnXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3M
vY21zL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2h0bWx
wYXRoJ10gPSAnaHR0cDovL3d3dy5zY2h1bGVwbHVzZXNzZW4uZGUvY21zL3VwbG9hZC8nOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2Zyb250ZW5kcGF0aCddID0gJ3V
wbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ10gPSBhcnJheSgpOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2V
zLzgvZDExODg0NTg1My9odGRvY3MvY21zL2Nzcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11
bJzEnXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydqcyd
dWydwYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU4NTMvaHRkb2NzL2Ntcy9qcy8nOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndHBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1s
nY2ZnQ2xpZW50J11bJzEnXVsndHBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg
0NTg1My9odGRvY3MvY21zL3RlbXBsYXRlcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzI
nXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMiddWydwYXRoJ10gPSBhcnJ
heSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsncGF0aCddWydmcm9udGVuZCddID0
gJy9ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9maXRraWQvJzsgJEdMT0JBTFNbJ2N
mZ0NsaWVudCddWycyJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICdodHRwOi8vd3d3LmZpdGt
pZC1ha3Rpb24uZGUvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycyJ11bJ2ltYWdlcyddID0
gJ2h0dHA6Ly93d3cuZml0a2lkLWFrdGlvbi5kZS9pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0N
saWVudCddWycyJ11bJ3VwbG9hZCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW5
0J11bJzInXVsnaHRtbHBhdGgnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVs
nMiddWydodG1scGF0aCddWydmcm9udGVuZCddID0gJ2h0dHA6Ly93d3cuZml0a2lkLWFrdGl
vbi5kZS8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ10gPSBhcnJheSgpOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2V
zLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2x
pZW50J11bJzInXVsndXBsJ11bJ2h0bWxwYXRoJ10gPSAnaHR0cDovL3d3dy5maXRraWQtYWt
0aW9uLmRlL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ2Z
yb250ZW5kcGF0aCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVs
nY3NzJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnY3NzJ11bJ3B
hdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL2Nzcy8nOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWyd
jZmdDbGllbnQnXVsnMiddWydqcyddWydwYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU
4NTMvaHRkb2NzL2ZpdGtpZC9qcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHB
sJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHBsJ11bJ3BhdGg
nXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL3RlbXBsYXRlcy8
nOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGNhdCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2VycnN
pdGVfaWRjYXQnXVsnMSddID0gJzQ5JzsgJEdMT0JBTFNbJ2VycnNpdGVfaWRjYXQnXVsnMid
dID0gJzEwMCc7ICRHTE9CQUxTWydlcnJzaXRlX2lkYXJ0J10gPSBhcnJheSgpOyAkR0xPQkF
MU1snZXJyc2l0ZV9pZGFydCddWycxJ10gPSAnNTEnOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGF
ydCddWycyJ10gPSAnMzE4JzsgJEdMT0JBTFNbJ2VuY29kaW5nJ10gPSBhcnJheSgpOyAkR0x
PQkFMU1snZW5jb2RpbmcnXVsnMSddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snZW5jb2R
pbmcnXVsnMyddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snbGFuZyddID0gJzEnOyAkR0x
PQkFMU1snY2xpZW50J10gPSAnMSc7IA==', changed='20081118120314' where sid='60c00fd416ecd76793ce8d50eb5d7b6f' and name='sid_1_1'
insert into con_phplib_active_sessions ( sid, name, val, changed ) values ('60c00fd416ecd76793ce8d50eb5d7b6f', 'sid_1_1',
'c2lkXzFfMTokdGhpcy0+aW4gPSAnMCc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5
wdFsnYXV0aCddID0gJzEnOyAkdGhpcy0+cHRbJ2NmZ0NsaWVudCddID0gJzEnOyAkdGhpcy0
+cHRbJ2VycnNpdGVfaWRjYXQnXSA9ICcxJzsgJHRoaXMtPnB0WydlcnJzaXRlX2lkYXJ0J10
gPSAnMSc7ICR0aGlzLT5wdFsnZW5jb2RpbmcnXSA9ICcxJzsgJHRoaXMtPnB0WydsYW5nJ10
gPSAnMSc7ICR0aGlzLT5wdFsnY2xpZW50J10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSB
uZXcgQ29udGVuaWRvX0Zyb250ZW5kX0NoYWxsZW5nZV9DcnlwdF9BdXRoOyAkR0xPQkFMU1s
nYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10
gPSAnbm9ib2R5JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICRHTE9
CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snYXV
0aCddLT5hdXRoWyd1bmFtZSddID0gJ25vYm9keSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGh
bJ3JlZnJlc2gnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddID0gYXJ
yYXkoKTsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWydzZXQnXSA9ICdzZXQnOyAkR0xPQkFMU1s
nY2ZnQ2xpZW50J11bJzEnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSd
dWydwYXRoJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsncGF0aCd
dWydmcm9udGVuZCddID0gJy9ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9jbXMvJzs
gJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICdodHR
wOi8vd3d3LnNjaHVsZXBsdXNlc3Nlbi5kZS9jbXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCd
dWycxJ11bJ2ltYWdlcyddID0gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2Ntcy9
pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3VwbG9hZCddID0gJ3VwbG9
hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnaHRtbHBhdGgnXSA9IGFycmF5KCk
7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydodG1scGF0aCddWydmcm9udGVuZCddID0
gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2Ntcy8nOyAkR0xPQkFMU1snY2ZnQ2x
pZW50J11bJzEnXVsndXBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzE
nXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvY21
zL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2h0bWxwYXR
oJ10gPSAnaHR0cDovL3d3dy5zY2h1bGVwbHVzZXNzZW4uZGUvY21zL3VwbG9hZC8nOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2Zyb250ZW5kcGF0aCddID0gJ3VwbG9
hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ10gPSBhcnJheSgpOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzg
vZDExODg0NTg1My9odGRvY3MvY21zL2Nzcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzE
nXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydqcyddWyd
wYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU4NTMvaHRkb2NzL2Ntcy9qcy8nOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndHBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2Z
nQ2xpZW50J11bJzEnXVsndHBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg
1My9odGRvY3MvY21zL3RlbXBsYXRlcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXSA
9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMiddWydwYXRoJ10gPSBhcnJheSg
pOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsncGF0aCddWydmcm9udGVuZCddID0gJy9
ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9maXRraWQvJzsgJEdMT0JBTFNbJ2NmZ0N
saWVudCddWycyJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICdodHRwOi8vd3d3LmZpdGtpZC1
ha3Rpb24uZGUvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycyJ11bJ2ltYWdlcyddID0gJ2h
0dHA6Ly93d3cuZml0a2lkLWFrdGlvbi5kZS9pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWV
udCddWycyJ11bJ3VwbG9hZCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11
bJzInXVsnaHRtbHBhdGgnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMid
dWydodG1scGF0aCddWydmcm9udGVuZCddID0gJ2h0dHA6Ly93d3cuZml0a2lkLWFrdGlvbi5
kZS8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ10gPSBhcnJheSgpOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzg
vZDExODg0NTg1My9odGRvY3MvZml0a2lkL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW5
0J11bJzInXVsndXBsJ11bJ2h0bWxwYXRoJ10gPSAnaHR0cDovL3d3dy5maXRraWQtYWt0aW9
uLmRlL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ2Zyb25
0ZW5kcGF0aCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnY3N
zJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnY3NzJ11bJ3BhdGg
nXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL2Nzcy8nOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmd
DbGllbnQnXVsnMiddWydqcyddWydwYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU4NTM
vaHRkb2NzL2ZpdGtpZC9qcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHBsJ10
gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHBsJ11bJ3BhdGgnXSA
9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL3RlbXBsYXRlcy8nOyA
kR0xPQkFMU1snZXJyc2l0ZV9pZGNhdCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2VycnNpdGV
faWRjYXQnXVsnMSddID0gJzQ5JzsgJEdMT0JBTFNbJ2VycnNpdGVfaWRjYXQnXVsnMiddID0
gJzEwMCc7ICRHTE9CQUxTWydlcnJzaXRlX2lkYXJ0J10gPSBhcnJheSgpOyAkR0xPQkFMU1s
nZXJyc2l0ZV9pZGFydCddWycxJ10gPSAnNTEnOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGFydCd
dWycyJ10gPSAnMzE4JzsgJEdMT0JBTFNbJ2VuY29kaW5nJ10gPSBhcnJheSgpOyAkR0xPQkF
MU1snZW5jb2RpbmcnXVsnMSddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snZW5jb2Rpbmc
nXVsnMyddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snbGFuZyddID0gJzEnOyAkR0xPQkF
MU1snY2xpZW50J10gPSAnMSc7IA==', '20081118120314') UPDATE con_stat SET visited = visited + 1 WHERE idcatart = '49' AND idclient = '1' AND idlang = '1'
update con_phplib_active_sessions set
val='c2lkXzFfMTokdGhpcy0+aW4gPSAnMCc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGl
zLT5wdFsnYXV0aCddID0gJzEnOyAkdGhpcy0+cHRbJ2NmZ0NsaWVudCddID0gJzEnOyAkdGh
pcy0+cHRbJ2VycnNpdGVfaWRjYXQnXSA9ICcxJzsgJHRoaXMtPnB0WydlcnJzaXRlX2lkYXJ
0J10gPSAnMSc7ICR0aGlzLT5wdFsnZW5jb2RpbmcnXSA9ICcxJzsgJHRoaXMtPnB0WydsYW5
nJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2xpZW50J10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10
gPSBuZXcgQ29udGVuaWRvX0Zyb250ZW5kX0NoYWxsZW5nZV9DcnlwdF9BdXRoOyAkR0xPQkF
MU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWl
kJ10gPSAnbm9ib2R5JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICR
HTE9CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1s
nYXV0aCddLT5hdXRoWyd1bmFtZSddID0gJ25vYm9keSc7ICRHTE9CQUxTWydhdXRoJ10tPmF
1dGhbJ3JlZnJlc2gnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddID0
gYXJyYXkoKTsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWydzZXQnXSA9ICdzZXQnOyAkR0xPQkF
MU1snY2ZnQ2xpZW50J11bJzEnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVs
nMSddWydwYXRoJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsncGF
0aCddWydmcm9udGVuZCddID0gJy9ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9jbXM
vJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICd
odHRwOi8vd3d3LnNjaHVsZXBsdXNlc3Nlbi5kZS9jbXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWV
udCddWycxJ11bJ2ltYWdlcyddID0gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2N
tcy9pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3VwbG9hZCddID0gJ3V
wbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnaHRtbHBhdGgnXSA9IGFycmF
5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydodG1scGF0aCddWydmcm9udGVuZCd
dID0gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2Ntcy8nOyAkR0xPQkFMU1snY2Z
nQ2xpZW50J11bJzEnXVsndXBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11
bJzEnXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3M
vY21zL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2h0bWx
wYXRoJ10gPSAnaHR0cDovL3d3dy5zY2h1bGVwbHVzZXNzZW4uZGUvY21zL3VwbG9hZC8nOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2Zyb250ZW5kcGF0aCddID0gJ3V
wbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ10gPSBhcnJheSgpOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2V
zLzgvZDExODg0NTg1My9odGRvY3MvY21zL2Nzcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11
bJzEnXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydqcyd
dWydwYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU4NTMvaHRkb2NzL2Ntcy9qcy8nOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndHBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1s
nY2ZnQ2xpZW50J11bJzEnXVsndHBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg
0NTg1My9odGRvY3MvY21zL3RlbXBsYXRlcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzI
nXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMiddWydwYXRoJ10gPSBhcnJ
heSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsncGF0aCddWydmcm9udGVuZCddID0
gJy9ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9maXRraWQvJzsgJEdMT0JBTFNbJ2N
mZ0NsaWVudCddWycyJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICdodHRwOi8vd3d3LmZpdGt
pZC1ha3Rpb24uZGUvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycyJ11bJ2ltYWdlcyddID0
gJ2h0dHA6Ly93d3cuZml0a2lkLWFrdGlvbi5kZS9pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0N
saWVudCddWycyJ11bJ3VwbG9hZCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW5
0J11bJzInXVsnaHRtbHBhdGgnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVs
nMiddWydodG1scGF0aCddWydmcm9udGVuZCddID0gJ2h0dHA6Ly93d3cuZml0a2lkLWFrdGl
vbi5kZS8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ10gPSBhcnJheSgpOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2V
zLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2x
pZW50J11bJzInXVsndXBsJ11bJ2h0bWxwYXRoJ10gPSAnaHR0cDovL3d3dy5maXRraWQtYWt
0aW9uLmRlL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ2Z
yb250ZW5kcGF0aCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVs
nY3NzJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnY3NzJ11bJ3B
hdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL2Nzcy8nOyA
kR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWyd
jZmdDbGllbnQnXVsnMiddWydqcyddWydwYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU
4NTMvaHRkb2NzL2ZpdGtpZC9qcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHB
sJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHBsJ11bJ3BhdGg
nXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL3RlbXBsYXRlcy8
nOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGNhdCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2VycnN
pdGVfaWRjYXQnXVsnMSddID0gJzQ5JzsgJEdMT0JBTFNbJ2VycnNpdGVfaWRjYXQnXVsnMid
dID0gJzEwMCc7ICRHTE9CQUxTWydlcnJzaXRlX2lkYXJ0J10gPSBhcnJheSgpOyAkR0xPQkF
MU1snZXJyc2l0ZV9pZGFydCddWycxJ10gPSAnNTEnOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGF
ydCddWycyJ10gPSAnMzE4JzsgJEdMT0JBTFNbJ2VuY29kaW5nJ10gPSBhcnJheSgpOyAkR0x
PQkFMU1snZW5jb2RpbmcnXVsnMSddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snZW5jb2R
pbmcnXVsnMyddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snbGFuZyddID0gJzEnOyAkR0x
PQkFMU1snY2xpZW50J10gPSAnMSc7IA==', changed='20081118120320' where sid='6b0d9ebcad95a269cdef37f39a380829' and name='sid_1_1'
insert into con_phplib_active_sessions ( sid, name, val, changed ) values ('6b0d9ebcad95a269cdef37f39a380829', 'sid_1_1',
'c2lkXzFfMTokdGhpcy0+aW4gPSAnMCc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5
wdFsnYXV0aCddID0gJzEnOyAkdGhpcy0+cHRbJ2NmZ0NsaWVudCddID0gJzEnOyAkdGhpcy0
+cHRbJ2VycnNpdGVfaWRjYXQnXSA9ICcxJzsgJHRoaXMtPnB0WydlcnJzaXRlX2lkYXJ0J10
gPSAnMSc7ICR0aGlzLT5wdFsnZW5jb2RpbmcnXSA9ICcxJzsgJHRoaXMtPnB0WydsYW5nJ10
gPSAnMSc7ICR0aGlzLT5wdFsnY2xpZW50J10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSB
uZXcgQ29udGVuaWRvX0Zyb250ZW5kX0NoYWxsZW5nZV9DcnlwdF9BdXRoOyAkR0xPQkFMU1s
nYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10
gPSAnbm9ib2R5JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICRHTE9
CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snYXV
0aCddLT5hdXRoWyd1bmFtZSddID0gJ25vYm9keSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGh
bJ3JlZnJlc2gnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddID0gYXJ
yYXkoKTsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWydzZXQnXSA9ICdzZXQnOyAkR0xPQkFMU1s
nY2ZnQ2xpZW50J11bJzEnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSd
dWydwYXRoJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsncGF0aCd
dWydmcm9udGVuZCddID0gJy9ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9jbXMvJzs
gJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICdodHR
wOi8vd3d3LnNjaHVsZXBsdXNlc3Nlbi5kZS9jbXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCd
dWycxJ11bJ2ltYWdlcyddID0gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2Ntcy9
pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3VwbG9hZCddID0gJ3VwbG9
hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnaHRtbHBhdGgnXSA9IGFycmF5KCk
7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydodG1scGF0aCddWydmcm9udGVuZCddID0
gJ2h0dHA6Ly93d3cuc2NodWxlcGx1c2Vzc2VuLmRlL2Ntcy8nOyAkR0xPQkFMU1snY2ZnQ2x
pZW50J11bJzEnXVsndXBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzE
nXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvY21
zL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2h0bWxwYXR
oJ10gPSAnaHR0cDovL3d3dy5zY2h1bGVwbHVzZXNzZW4uZGUvY21zL3VwbG9hZC8nOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2Zyb250ZW5kcGF0aCddID0gJ3VwbG9
hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ10gPSBhcnJheSgpOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzg
vZDExODg0NTg1My9odGRvY3MvY21zL2Nzcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzE
nXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydqcyddWyd
wYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU4NTMvaHRkb2NzL2Ntcy9qcy8nOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndHBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2Z
nQ2xpZW50J11bJzEnXVsndHBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg
1My9odGRvY3MvY21zL3RlbXBsYXRlcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXSA
9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMiddWydwYXRoJ10gPSBhcnJheSg
pOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsncGF0aCddWydmcm9udGVuZCddID0gJy9
ob21lcGFnZXMvOC9kMTE4ODQ1ODUzL2h0ZG9jcy9maXRraWQvJzsgJEdMT0JBTFNbJ2NmZ0N
saWVudCddWycyJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICdodHRwOi8vd3d3LmZpdGtpZC1
ha3Rpb24uZGUvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycyJ11bJ2ltYWdlcyddID0gJ2h
0dHA6Ly93d3cuZml0a2lkLWFrdGlvbi5kZS9pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWV
udCddWycyJ11bJ3VwbG9hZCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11
bJzInXVsnaHRtbHBhdGgnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMid
dWydodG1scGF0aCddWydmcm9udGVuZCddID0gJ2h0dHA6Ly93d3cuZml0a2lkLWFrdGlvbi5
kZS8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ10gPSBhcnJheSgpOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzg
vZDExODg0NTg1My9odGRvY3MvZml0a2lkL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW5
0J11bJzInXVsndXBsJ11bJ2h0bWxwYXRoJ10gPSAnaHR0cDovL3d3dy5maXRraWQtYWt0aW9
uLmRlL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndXBsJ11bJ2Zyb25
0ZW5kcGF0aCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnY3N
zJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnY3NzJ11bJ3BhdGg
nXSA9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL2Nzcy8nOyAkR0x
PQkFMU1snY2ZnQ2xpZW50J11bJzInXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmd
DbGllbnQnXVsnMiddWydqcyddWydwYXRoJ10gPSAnL2hvbWVwYWdlcy84L2QxMTg4NDU4NTM
vaHRkb2NzL2ZpdGtpZC9qcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHBsJ10
gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzInXVsndHBsJ11bJ3BhdGgnXSA
9ICcvaG9tZXBhZ2VzLzgvZDExODg0NTg1My9odGRvY3MvZml0a2lkL3RlbXBsYXRlcy8nOyA
kR0xPQkFMU1snZXJyc2l0ZV9pZGNhdCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2VycnNpdGV
faWRjYXQnXVsnMSddID0gJzQ5JzsgJEdMT0JBTFNbJ2VycnNpdGVfaWRjYXQnXVsnMiddID0
gJzEwMCc7ICRHTE9CQUxTWydlcnJzaXRlX2lkYXJ0J10gPSBhcnJheSgpOyAkR0xPQkFMU1s
nZXJyc2l0ZV9pZGFydCddWycxJ10gPSAnNTEnOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGFydCd
dWycyJ10gPSAnMzE4JzsgJEdMT0JBTFNbJ2VuY29kaW5nJ10gPSBhcnJheSgpOyAkR0xPQkF
MU1snZW5jb2RpbmcnXVsnMSddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snZW5jb2Rpbmc
nXVsnMyddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snbGFuZyddID0gJzEnOyAkR0xPQkF
MU1snY2xpZW50J10gPSAnMSc7IA==', '20081118120320') UPDATE con_stat SET visited = visited + 1 WHERE idcatart = '154' AND idclient = '1' AND idlang = '1'



Hat jemand eine Idee, was diese Datenbankbelastung verursachen könnte?


Ausserdem erzeugt unsere Pseudo-Cron.txt allein am 17.11, also gestern über 3.300 Aufrufe folgender Dateien:


Mon, 17 Nov 2008 23:55:05 +0100 Running */5 * * * * send_reminder.php
Mon, 17 Nov 2008 23:55:05 +0100 Last run: Mon, 17 Nov 2008 23:50:00 +0100
Mon, 17 Nov 2008 23:55:05 +0100 Last scheduled: Mon, 17 Nov 2008 23:55:00 +0100
Mon, 17 Nov 2008 23:55:05 +0100 Completed */5 * * * * send_reminder.php
Mon, 17 Nov 2008 23:56:01 +0100 Running */2 * * * * move_articles.php
Mon, 17 Nov 2008 23:56:01 +0100 Last run: Mon, 17 Nov 2008 23:54:00 +0100
Mon, 17 Nov 2008 23:56:01 +0100 Last scheduled: Mon, 17 Nov 2008 23:56:00 +0100
Mon, 17 Nov 2008 23:56:01 +0100 Completed */2 * * * * move_articles.php
Mon, 17 Nov 2008 23:56:01 +0100 Running */2 * * * * session_cleanup.php
Mon, 17 Nov 2008 23:56:01 +0100 Last run: Mon, 17 Nov 2008 23:54:00 +0100
Mon, 17 Nov 2008 23:56:01 +0100 Last scheduled: Mon, 17 Nov 2008 23:56:00 +0100
Mon, 17 Nov 2008 23:56:01 +0100 Completed */2 * * * * session_cleanup.php
Mon, 17 Nov 2008 23:58:11 +0100 Running */2 * * * * move_articles.php
Mon, 17 Nov 2008 23:58:11 +0100 Last run: Mon, 17 Nov 2008 23:56:00 +0100
Mon, 17 Nov 2008 23:58:11 +0100 Last scheduled: Mon, 17 Nov 2008 23:58:00 +0100
Mon, 17 Nov 2008 23:58:11 +0100 Completed */2 * * * * move_articles.php
Mon, 17 Nov 2008 23:58:11 +0100 Running */2 * * * * session_cleanup.php
Mon, 17 Nov 2008 23:58:11 +0100 Last run: Mon, 17 Nov 2008 23:56:00 +0100
Mon, 17 Nov 2008 23:58:11 +0100 Last scheduled: Mon, 17 Nov 2008 23:58:00 +0100
Mon, 17 Nov 2008 23:58:11 +0100 Completed */2 * * * * session_cleanup.php


Ist das normal?
Vielen Dank für eure Antworten.

[Dodger77]

Das ist ein bekanntes Problem:

http://forum.contenido.org/viewtopic.ph ... ht=session

Das ließe sich wahrscheinlich durch ein Upgrade auf die 4.8.8 und Umstellung auf Dateien als Sessioncontainer (gibt es erst seit 4.8.x) lösen. Dafür muss man einfach in "contenido/includes/" eine Datei mit dem Namen "config.local.php" anlegen mit folgendem Inhalt:

Code: Alles auswählen

<?php

/* Session data storage container (PHPLIB)
 * ----------------------------------
 *
 * Different session data storage containers are available.
 * file	= session data will be stored in a file on the file system
 * sql	= session data will be stored in a database table - as it is
 */

/* default container is sql */
$cfg["session_container"] = 'file';

?>

Wenn die genannte Datei bereits besteht, kann man diese einfach um die Anweisung erweitern.