phpBB Italia chiude!
phpBB Italia ringrazia tutti gli utenti che hanno dato fiducia al nostro progetto per ben 9 anni, e che, grazie al grande lavoro fatto da tutto lo Staff (rigorosamente a titolo gratuito), hanno portato il portale a diventare il principale punto di riferimento italiano alla piattaforma phpBB.

Purtroppo, causa motivi personali, non ho più modo di gestirlo e portarlo avanti. Il forum viene ora posto in uno stato di sola lettura, nonché un archivio storico per permettere a chiunque di fruire di tutte le discussioni trattate.

Il nuovo portale di assistenza per l'Italia di phpBB diventa phpBB-Store.it, cui ringrazio per aver deciso di portare avanti questo grande progetto.

Grazie ancora,
Carlo - Amministratore di phpBB Italia

Query che superano i valori consentiti, come mai?

Supporto per phpBB 3.0.x.
Rispondi
Polv89
Utente
Utente
Messaggi: 80
Iscritto il: 20/09/2012, 18:25
Sesso: Maschio
Versione: 3.0.11
PHP: 5.3.17
Database: mysql 5.1.61

Query che superano i valori consentiti, come mai?

Messaggio da Polv89 » 14/05/2014, 18:30

Qualcuno può darmi una mano nel risolvere questo problema?
Il forum non è neanche frequentatissimo...

Codice: Seleziona tutto

il servizio di hosting è stato sospeso per la violazione delle policy QoS pubbliche e presenti all'indirizzo: https://www.netsons.com/knowledgebase.php?action=displayarticle&id=1

Nella fattispecie alcune sue query superano di gran lunga i valori consentiti. Le riporto una delle query in questione:

# User@Host: ********[*********] @ localhost [127.0.0.1]
# Query_time: 13.639507 Lock_time: 0.001257 Rows_sent: 0 Rows_examined: 0
use ***************;
SET timestamp=1396339658;
DELETE FROM ********_search_wordmatch
WHERE word_id IN ('1', '4', '6', '8', '9', '10', '18', '19', '21', '22', '28', '30', '44', '46', '56', '59', '60', '62', '64', '70', '71', '74', '75', '81', '82', '83', '90', '91', '93', '98', '99', '103', '107', '108', '111', '117', '118', '122', '123', '133', '138', '143', '145', '146', '152', '159', '163', '183', '184', '191', '195', '203', '205', '215', '220', '244', '246', '249', '257', '259', '265', '273', '274', '280', '282', '317', '322', '327', '346', '356', '364', '365', '370', '376', '384', '395', '397', '412', '417', '418', '419', '423', '424', '428', '434', '436', '437', '442', '444', '449', '450', '452', '453', '455', '456', '460', '462', '464', '466', '467', '468', '469', '471', '474', '480', '483', '484', '489', '500', '502', '503', '506', '511', '514', '515', '516', '518', '520', '521', '526', '527', '530', '532', '533', '536', '537', '539', '543', '551', '553', '555', '561', '563', '564', '565', '567', '576', '578', '579', '582', '583', '584', '585', '587', '588', '589', '595', '597', '601', '608', '609', '610', '611', '612', '613', '615', '616', '621', '624', '627', '632', '633', '635', '641', '643', '644', '647', '649', '651', '653', '654', '656', '661', '664', '665', '667', '668', '670', '672', '673', '677', '678', '679', '680', '687', '688', '689', '691', '693', '694', '697', '699', '701', '705', '708', '711', '717', '718', '722', '725', '729', '731', '732', '733', '739', '741', '745', '746', '748', '757', '762', '763', '766', '769', '770', '773', '777', '779', '786', '818', '822', '827', '829', '841', '848', '850', '860', '861', '870', '873', '934', '955', '985', '986', '987', '988', '989', '992', '993', '994', '997', '998', '1004', '1007', '1010', '1014', '1015', '1018', '1021', '1022', '1023', '1026', '1028', '1029', '1031', '1034', '1051', '1056', '1063', '1069', '1071', '1073', '1074', '1076', '1077', '1078', '1082', '1084', '1085', '1098', '1108', '1110', '1111', '1113', '1119', '1121', '1125', '1126', '1127', '1128', '1131', '1135', '1138', '1140', '1141', '1145', '1148', '1151', '1153', '1161', '1164', '1168', '1175', '1176', '1177', '1182', '1185', '1186', '1187', '1190', '1191', '1192', '1198', '1200', '1201', '1202', '1205', '1207', '1208', '1210', '1211', '1215', '1216', '1217', '1218', '1220', '1221', '1222', '1223', '1224', '1225', '1228', '1230', '1231', '1234', '1237', '1240', '1243', '1245', '1250', '1251', '1252', '1258', '1259', '1260', '1263', '1264', '1266', '1267', '1270', '1272', '1275', '1278', '1279', '1282', '1286', '1287', '1289', '1291', '1293', '1297', '1303', '1304', '1306', '1309', '1310', '1311', '1312', '1313', '1314', '1326', '1327', '1329', '1330', '1331', '1332', '1333', '1335', '1338', '1339', '1341', '1343', '1345', '1347', '1348', '1356', '1359', '1362', '1365', '1368', '1369', '1382', '1384', '1386', '1389', '1391', '1394', '1397', '1400', '1401', '1404', '1405', '1413', '1416', '1423', '1424', '1427', '1428', '1429', '1430', '1432', '1433', '1437', '1438', '1439', '1440', '1441', '1442', '1445', '1450', '1451', '1453', '1454', '1459', '1460', '1464', '1468', '1469', '1473', '1474', '1478', '1482', '1494', '1496', '1501', '1502', '1503', '1506', '1508', '1509', '1510', '1512', '1523', '1524', '1526', '1527', '1529', '1533', '1535', '1538', '1542', '1544', '1546', '1548', '1549', '1553', '1554', '1555', '1557', '1565', '1567', '1568', '1569', '1572', '1573', '1578', '1589', '1591', '1592', '1602', '1606', '1607', '1612', '1614', '1615', '1622', '1642', '1645', '1647', '1651', '1659', '1662', '1666', '1669', '1670', '1678', '1681', '1689', '1690', '1691', '1692', '1694', '1702', '1703', '1704', '1719', '1720', '1726', '1727', '1735', '1740', '1747', '1752', '1765', '1766', '1769', '1770', '1774', '1777', '1778', '1781', '1795', '1817', '1841', '1852', '1853', '1856', '1909', '1915', '1930', '1941', '1945', '1949', '1964', '1965', '1966', '1971', '1979', '1980', '1990', '2003', '2017', '2021', '2034', '2035', '2036', '2037', '2038', '2043', '2047', '2048', '2066', '2067', '2082', '2086', '2095', '2099', '2106', '2111', '2129', '2156', '2163', '2166', '2186', '2195', '2196', '2198', '2199', '2200', '2208', '2211', '2214', '2220', '2223', '2236', '2265', '2274', '2341', '2343', '2352', '2384', '2419', '2420', '2435', '2438', '2447', '2448', '2449', '2451', '2456', '2471', '2483', '2485', '2490', '2491', '2493', '2497', '2504', '2505', '2508', '2509', '2513', '2515', '2519', '2530', '2534', '2536', '2539', '2544', '2548', '2549', '2551', '2606', '2616', '2633', '2639', '2648', '2651', '2678', '2718', '2723', '2725', '2770', '2793', '2805', '2823', '2824', '2854', '2888', '2891', '2927', '2967', '2977', '3051', '3053', '3082', '3097', '3215', '3232', '3233', '3243', '3265', '3266', '3267', '3268', '3270', '3273', '3276', '3319', '3330', '3331', '3332', '3349', '3371', '3377', '3380', '3385', '3402', '3408', '3410', '3421', '3423', '3426', '3436', '3442', '3450', '3451', '3452', '3453', '3459', '3464', '3470', '3472', '3475', '3500', '3502', '3525', '3527', '3534', '3545', '3591', '3605', '3633', '3655', '3677', '3685', '3690', '3692', '3708', '3727', '3729', '3731', '3747', '3757', '3759', '3791', '3817', '3820', '3831', '3927', '3940', '3963', '3964', '3971', '3981', '3985', '3988', '3989', '3995', '3997', '4006', '4011', '4022', '4024', '4026', '4027', '4028', '4034', '4044', '4051', '4052', '4068', '4096', '4099', '4123', '4135', '4142', '4148', '4150', '4153', '4156', '4160', '4168', '4170', '4173', '4174', '4186', '4199', '4203', '4222', '4321', '4322', '4330', '4333', '4342', '4381', '4423', '4424', '4444', '4449', '4450', '4452', '4457', '4458', '4460', '4462', '4472', '4477', '4479', '4482', '4500', '4503', '4557', '4587', '4608', '4618', '4629', '4662', '4664', '4665', '4666', '4670', '4671', '4677', '4679', '4681', '4683', '4684', '4686', '4688', '4689', '4691', '4696', '4701', '4704', '4705', '4707', '4713', '4730', '4734', '4736', '4737', '4741', '4761', '4762', '4763', '4767', '4771', '4775', '4776', '4854', '4871', '5054', '5057', '5062', '5063', '5065', '5085', '5116', '5198', '5293', '5430', '5434', '5436', '5437', '5441', '5500', '5519', '5583', '5592', '5601', '5611', '5641', '5643', '5708', '5719', '5805', '5818', '5862', '5863', '5866', '5868', '5869', '5927', '5951', '5954', '6148', '6306', '6311', '6313', '6314', '6338', '6357', '6358', '6426', '6429', '6447', '6497', '6521', '6570', '6587', '6625', '6627', '6636', '6676', '6677', '6702', '6708', '6712', '6715', '6780', '6793', '6795', '6796', '6838', '6846', '6848', '6853', '6885', '6887', '6903', '7157', '7164', '7166', '7178', '7184', '7209', '7225', '7233', '7276', '7316', '7322', '7438', '7447', '7488', '7490', '7495', '7500', '7508', '7513', '7516', '7518', '7528', '7530', '7535', '7651', '7695', '7711', '7714', '7797', '7840', '7841', '7869', '7881', '7902', '7923', '7992', '8005', '8034', '8045', '8056', '8058', '8074', '8082', '8088', '8099', '8119', '8127', '8128', '8131', '8154', '8208', '8211', '8214', '8221', '8236', '8251', '8255', '8256', '8270', '8282', '8337', '8356', '8409', '8411', '8413', '8418', '8421', '8441', '8442', '8443', '8444', '8447', '8449', '8452', '8467', '8468', '8472', '8475', '8478', '8492', '8504', '8507', '8535', '8550', '8581', '8585', '8587', '8613', '8635', '8660', '8661', '8662', '8704', '8705', '8707', '8711', '8720', '8721', '8722', '8724', '8725', '8727', '8729', '8730', '8731', '8739', '8746', '8749', '8752', '8753', '8756', '8797', '8869', '8872', '8876', '8878', '8880', '8883', '8885', '8887', '8889', '8900', '8901', '8904', '8907', '8913', '8914', '8915', '8917', '8930', '8945', '8946', '8947', '8956', '8960', '8963', '8966', '8972', '8979', '8991', '9001', '9003', '9007', '9008', '9016', '9021', '9025', '9030', '9034', '9038', '9051', '9055', '9057', '10262', '10263', '9080', '9168', '9289', '9318', '9432', '9452', '10415', '10366', '10359', '9921', '9949', '9950', '9951', '10421', '10513', '10516', '10518', '10519', '10526', '10530', '10531', '10532', '10535', '10536', '10538', '10540', '10543', '10545', '10549', '10552', '10554', '10555', '10558', '10561', '10568', '10580', '10581', '10587', '10589', '10600', '10606', '10609', '10613', '10614', '10621', '10623', '10624', '10625', '10626', '10631', '10633', '10636', '10637', '10638', '10640', '10644', '10648', '10661', '10662', '10668', '10693', '10696', '10697', '10698', '10702', '10703', '10704', '10707', '10708', '10709', '10713', '10716', '10720', '10722', '10724', '10727', '10728', '10735', '10736', '10737', '10740', '10743', '10762', '10766', '10768', '10769', '10770', '10776', '10781', '10782', '10785', '10789', '10801', '10802', '10805', '10807', '10811', '10813', '10814', '10816', '10817', '10824', '10831', '10832', '10842', '10859', '10861', '10885', '10886', '10888', '10890', '10892', '10894', '10898', '10926', '10931', '10933', '10940', '10948', '10963', '10967', '10980', '10984', '11004', '11005', '11008', '11010', '11014', '11018', '11020', '11024', '11025', '11026', '11027', '11031', '11038', '11045', '11046', '11047', '11053', '11055', '11057', '11060', '11061', '11066', '11069', '11071', '11074', '11556', '11543', '11546', '11547', '11548', '11550', '11552', '11553', '11525', '11526', '11528', '11530', '11531', '11536', '11538', '11539', '11089', '11092', '11106', '11108', '11116', '11118', '11119', '11122', '11125', '11126', '11128', '11134', '11135', '11144', '11150', '11151', '11157', '11158', '11169', '11190', '11198', '11199', '11202', '11203', '11278', '11281', '11282', '11287', '11291', '11295', '11303', '11565', '11521', '11567', '11569', '11571', '11523', '11514', '11517', '11322', '11325', '11326', '11328', '11329', '11332', '11335', '11340', '11349', '11381', '11383', '11386', '11406', '11409', '11411', '11418', '11430', '11434', '11436', '11559', '11563', '11466', '11498', '11499', '11586', '11587', '11600', '12370', '11705', '11722', '11723', '11724', '11726', '11729', '11730', '11733', '11737', '11739', '11740', '11742', '11753', '11754', '11755', '11758', '11759', '11766', '11771', '11772', '11773', '11774', '11779', '11789', '11794', '11798', '11799', '11803', '11804', '11805', '11806', '11807', '11808', '11815', '11816', '11817', '11828', '11835', '11851', '14071', '11895', '11913', '11921', '11941', '11949', '11958', '11959', '11961', '11963', '11966', '11969', '11971', '11979', '11982', '11983', '11984', '11989', '11990', '11991', '11995', '11996', '11997', '12001', '12002', '12023', '12025', '12029', '12030', '12031', '12033', '12035', '12048', '12045', '12063', '12070', '12079', '12080', '12086', '12090', '12092', '12113', '12121', '12129', '12130', '12131', '12133', '12135', '12159', '12163', '12170', '12186', '12484', '12199', '12200', '12203', '12204', '12208', '12211', '12215', '12221', '12223', '12230', '12231', '12241', '12243', '12244', '12246', '12251', '12258', '12260', '12262', '12265', '12269', '12271', '12279', '12280', '12289', '12292', '12294', '12300', '12469', '12347', '12348', '12397', '12400', '12421', '12422', '12423', '12431', '12457', '12535', '12536', '12560', '12564', '12565', '12566', '12568', '12571', '12575', '12583', '12589', '12591', '12597', '12601', '12602', '12603', '12604', '12611', '12612', '12616', '12625', '12626', '12629', '12642', '12646', '12647', '12660', '12663', '12666', '12668', '12669', '12673', '12680', '12685', '12687', '12698', '12700', '12707', '12714', '12717', '12720', '12732', '12733', '12737', '12738', '12739', '12747', '12749', '12750', '12757', '12802', '12818', '12834', '12884', '12913', '12915', '12918', '12919', '12963', '12969', '12970', '12975', '12977', '12983', '12986', '12997', '13004', '13043', '13044', '13049', '13053', '13054', '13057', '13062', '13063', '13064', '13066', '13067', '13069', '13074', '13093', '13098', '13102', '13103', '13107', '13112', '13113', '13115', '13127', '13131', '13139', '13140', '13144', '13149', '13150', '13166', '13159', '13165', '13167', '13160', '13177', '13178', '13181', '13186', '13188', '13191', '13193', '13196', '13197', '13199', '13206', '13212', '13217', '13218', '13225', '13228', '13241', '13247', '13253', '13257', '13320', '13325', '13337', '13378', '13385', '13454', '13457', '13472', '13487', '13537', '13571', '13576', '13591', '13609', '13610', '13616', '13623', '13631', '13633', '13636', '13656', '13659', '13660', '13671', '13681', '13692', '13700', '13719', '13754', '13856', '13858', '13866', '13871', '13875', '13878', '13891', '13934', '13933', '13935', '13936', '13941', '13943', '13944', '13952', '13953', '13954', '13961', '13963', '13969', '13973', '13975', '13978', '14045', '14040', '14015', '14024', '14048', '14073', '14079', '14084', '14341', '14383', '14394', '15340', '14531', '14575', '14623', '14682', '14745', '14885', '14953', '14977', '14986', '15157', '15160', '15165', '15169', '15173', '15223', '15238', '15248', '15299', '15349', '15360', '15395', '15444', '15445', '15452', '15565', '15627', '15938', '15937', '15661', '15664', '15692', '15739', '15768', '15889', '15899', '15950', '15996', '15999', '16002', '16005', '16006', '16008', '16009', '16075', '16238', '16240', '16244', '16442', '16470', '16481', '16496', '16506', '16507', '16574', '16576', '16621', '16623', '16684', '16734', '16792', '16801', '16804', '16816', '16867', '16872', '16978', '17023', '18622', '17194', '17200', '17209', '17226', '17245', '17248', '17263', '17298', '17334', '17385', '17428', '17581', '17653', '17666', '17693', '17818', '17857', '17866', '17883', ':

Avatar utente
Barrnet
Leader Moderatori
Leader Moderatori
Messaggi: 3124
Iscritto il: 04/07/2010, 23:31
Sesso: Maschio
Versione: 3.0.10
Server: UNIX/Linux
PHP: 5.3.10
Database: MySQL 5.1.61-community-log
Contatta:

Re: Query che superano i valori consentiti, come mai?

Messaggio da Barrnet » 14/05/2014, 22:12

Il forum ha mod?
su quale fascia di hosting è hostato?

Polv89
Utente
Utente
Messaggi: 80
Iscritto il: 20/09/2012, 18:25
Sesso: Maschio
Versione: 3.0.11
PHP: 5.3.17
Database: mysql 5.1.61

Re: R: Query che superano i valori consentiti, come mai?

Messaggio da Polv89 » 15/05/2014, 17:35

Barrnet ha scritto:Il forum ha mod?
su quale fascia di hosting è hostato?
Si, ha delle mod...
Ha l'hosting fast di netsons

Avatar utente
Barrnet
Leader Moderatori
Leader Moderatori
Messaggi: 3124
Iscritto il: 04/07/2010, 23:31
Sesso: Maschio
Versione: 3.0.10
Server: UNIX/Linux
PHP: 5.3.10
Database: MySQL 5.1.61-community-log
Contatta:

Re: Query che superano i valori consentiti, come mai?

Messaggio da Barrnet » 15/05/2014, 21:35

Quant'è il carico di utenza e di visite?
Quali mod sono installate?

Polv89
Utente
Utente
Messaggi: 80
Iscritto il: 20/09/2012, 18:25
Sesso: Maschio
Versione: 3.0.11
PHP: 5.3.17
Database: mysql 5.1.61

Re: R: Query che superano i valori consentiti, come mai?

Messaggio da Polv89 » 16/05/2014, 16:46

Sinceramente il forum era fermo quindi per questo mi è sembrato strano... Gli utenti sono un centinaio o poco più ma poco attivi come dicevo
Provo a ricordare :Ho tapatalk, la mod per il menù in alto , il seo (http://www.nexusarena.it/forum)

Inviato dal mio Nexus 5 (by Nexusarena.it)

Avatar utente
Barrnet
Leader Moderatori
Leader Moderatori
Messaggi: 3124
Iscritto il: 04/07/2010, 23:31
Sesso: Maschio
Versione: 3.0.10
Server: UNIX/Linux
PHP: 5.3.10
Database: MySQL 5.1.61-community-log
Contatta:

Re: Query che superano i valori consentiti, come mai?

Messaggio da Barrnet » 16/05/2014, 23:22

Ok, abilita il debug di phpBB decommentando le ultime due righe del file config.php, nel footer ti apparirà un link per vedere tutte le query ed il loro tempo di esecuzione, riportale qui.

Rispondi

Torna a “[3.0.x] Forum di Supporto”

Chi c’è in linea

Visitano il forum: Nessuno e 83 ospiti