• N
    User •

    Soluzione a 'Lost connection to mysql server during query'

    Vi riporto di seguito lecaratteristiche del mio VPS tiscali:
    -Operating system Ubuntu Linux 10.04
    -Webmin version 1.600
    -Kernel and CPU Linux2.6.18-194.26.1.el5.028stab079.2 on i686
    -Processor information Quad-Core AMDOpteron(tm) Processor 8356, 2 cores
    -CPU load averages 0.51 (1 min) 0.60 (5mins) 0.56 (15 mins)
    -CPU usage 2% user, 1% kernel, 0% IO,97% idle
    -Real memory 2 GB total, 241.89 MB used
    -Local disk space 28.61 GB total, 17.12GB used

    Stamattina ho verificato se ci fosserodei problemi strani tracciati nei log. Riporto di seguito quantotrovato in ognuno.

    In ?Mysql-err.log? ho trovato?ripetutamente?(in ogni minuto) tracciati i seguenti errori:
    121101 10:26:01 [Note] Plugin'FEDERATED' is disabled.
    121101 10:26:01 [Note] Plugin 'InnoDB'is disabled.
    121101 10:26:01 [Note] Event Scheduler:Loaded 0 events
    121101 10:26:01 [Note]/usr/sbin/mysqld: ready for connections.
    Version: '5.1.41-3ubuntu12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
    121101 10:26:01 [ERROR]/usr/sbin/mysqld: Table './shoponmyweb/disponib' is marked as crashedand should be repaired
    121101 10:26:01 [Warning] Checkingtable: './shoponmyweb/disponib'

    In ?Mysql-slow-query.log? hotrovato ?ripetutamente? tracciate le seguenti segnalazioni:
    /usr/sbin/mysqld, Version:5.1.41-3ubuntu12.6-log ((Ubuntu)). started with:
    Tcp port: 3306 Unix socket:/var/run/mysqld/mysqld.sock
    Time Id Command Argument

    In ?syslog? ho trovato?ripetutamente?(in ogni minuto) tracciati i seguenti errori:
    Nov 1 10:20:03 vps1490/etc/mysql/debian-start[19599]: Upgrading MySQL tables if necessary.
    Nov 1 10:20:03 vps1490/etc/mysql/debian-start[19624]: /usr/bin/mysql_upgrade: the'--basedir' option is always ignored
    Nov 1 10:20:03 vps1490/etc/mysql/debian-start[19624]: Looking for 'mysql' as:/usr/bin/mysql
    Nov 1 10:20:03 vps1490/etc/mysql/debian-start[19624]: Looking for 'mysqlcheck' as:/usr/bin/mysqlcheck
    Nov 1 10:20:03 vps1490/etc/mysql/debian-start[19624]: This installation of MySQL is alreadyupgraded to 5.1.41, use --force if you still need to runmysql_upgrade
    Nov 1 10:20:03 vps1490/etc/mysql/debian-start[19647]: Checking for insecure root accounts.
    Nov 1 10:20:04 vps1490/etc/mysql/debian-start[19664]: Triggering myisam-recover for allMyISAM tables

    Nello script php che gestisce le queryda inviare al db ho previsto la scrittura su file di tutte le queryche crashano con i seguenti errori:
    -Lost connection to mysql server duringquery
    -Mysql has gone away

    Nonostante l'ottimizzazione delle queryfatta tenendo sottocontrollo il file delle slow-query, arrivando agestire anche i campi fulltext, in questo file mi ritrovoripetutamente query crashate per i 2 suddetti errori. Riporto diseguito degli esempi:
    2012-11-13 9:25:01 - Lost connection toMySQL server during query
    selecta.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTabledsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTabledsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1),pk_catego c force index (i_codice_1) where 1=1 and a.marca =b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzoin('CS0001','CS0002','CS0018','CS0003','CS0017','CS0004','CS0019','CS0005','CS0006','CS0008','CS0007','CS0016','CS0010','CS0011','CS0009','CS0012','1','3','5','2','CS0013','CS0014','PM0041','CS0015','PM0680','DP0001','DP0002','DP0003','DP0004','DP0005','DP0007','DP0008','DP0009','DP0010','DP0011','DP0013','DP0014','DP0015','DP0016','PM0772','PM0928','PM0071','PM0467','PM0232','PM0429','PM0482','PM0570','PM0571','PM0664','PM0665','PM0166','PM0224','PM0771','PM0178','PM0276','PM0369','PM0517','PM0526','PM0528','PM0546','PM0556','PM0598','PM0629','PM0843','PM0863','PM0866','PM0896','PM0561','PM0967','PM0094','PM0121','PM0231','PM0239','PM0286','PM0532','PM0421','PM0029','PM0034','PM0036','PM0364','PM0587','PM0031','PM0038','PM0635','PM0636','PM0810','PM0840','PM0151','PM0153','PM0544','PM0628','PM0716','PM0886','PM0328','PM0431','PM0432','PM0538','PM0549','PM0611','PM0612','PM0618','PM0795','PM0798','PM0868','PM0919','PM0345','PM0370','PM0379','PM0382','PM0410','PM0766','PM0792','PM0847','PM0384','PM0508','PM0428','PM0572','PM0768','PM0841','PM0860','PM0959','PM0449','PM0709','PM0476','PM0622','PM0708','PM0478','PM0724','PM0790','PM0932','PM0955','PM0975','PM0978','PM0496','PM0864','PM0878','PM0592','PM0005','PM0707','PM0710','PM0205','PM0329','PM0706','PM0213','PM0888','PM0596','PM0674','PM0799','PM0781','PM0466','PM0920','PM0148','PM0395','PM0397','PM0398','PM0455','PM0520','PM0522','PM0876','PM0976','PM0892','PM0958','PM0901','PM0925','PM0998','PM1010','PM1012','PM0413','PM0784','PM0911','PM0651','PM0668','PM0922','PM0783','PM0913','PM0823','PM0969','PM0685','PM0567','PM0568','PM0569','PM0746','PM0723','PM0737','PM0921','PM0320','PM0389','PM0392','PM0393','PM0427','PM0516','PM0524','PM0606','PM0671','PM0675','PM0785','PM0786','PM0391','PM0614','PM0705','PM0796','PM0817','PM0818','PM0819','PM0820','PM0821','PM0880','PM0894','PM0645','PM0663','PM0693','PM0055','PM0812','PM0052','PM0057','PM0091','PM0095','PM0268','PM0333','PM0893','PM0113','PM0219','PM0518','PM0648','PM0728','PM0833','PM0852','PM0917','PM0962','PM0297','PM0315','PM0322','PM0731','PM0767','PM0856','PM0882','PM0923','PM1008','PM0350','PM0380','PM0762','PM0765','PM0941','PM0465','PM1004','PM1011','PM0470','PM0487','PM0513','PM0525','PM0553','PM0581','PM0610','PM0649','PM0726','PM0763','PM0802','PM0853','PM0854','PM0904','PM0965','PM0988','PM0999','PM0486','PM0758','PM0855','PM0877','PM0931','PM0935','PM0952','PM0993','PM0195','PM0196','PM0211','PM0247','PM0269','PM0271','PM0314','PM0323','PM0354','PM0357','PM0260','PM0270','PM0317','PM0325','PM0358','PM0373','PM0235','PM0381','PM0539','PM0540','PM0542','PM0623','PM0624','PM0729','PM0881','PM0356','PM0653','PM0654','PM0800','PM0447','PM0638','PM0451','PM0543','PM0550','PM0575','PM0548','PM0579','PM0580','PM0578','PM0828','PM0406','PM0068','PM0161','PM0197','PM0198','PM0199','PM0240','PM0279','PM0342','PM0351','PM0353','PM0363','PM0474','PM0658','PM0774','PM0910','PM0131','PM0142','PM0207','PM0226','PM0227','PM0228','PM0229','PM0283','PM0285','PM0290','PM0298','PM0299','PM0306','PM0307','PM0385','PM0646','PM0698','PM0699','PM0703','PM0972','PM0973','PM0362','PM0732','PM0626','PM0791','PM0670','PM0776','PM0735','PM0788','PM0744','PM0971','PM0761','PM0915','PM0060','PM0497','PM0278','PM0838','PM0715','PM0787','PM0809','PM0824','PM0829','PM0832','PM0916','PM0930','PM0826','PM0617','PM0804','PM0805','PM0970','PM0661','PM0673','PM0681','PM0682','PM0803','PM0087','PM0831','PM0689','PM0691','PM0918','PM0702','PM0713','PM0808','PM0871','PM0080','PM0141','PM0149','PM0537','PM0545','PM0144','PM0529','PM0630','PM0631','PM0632','PM0633','PM0634','PM0815','PM0842','PM0846','PM0865','PM0889','PM0248','PM0417','PM0221','PM0236','PM0415','PM0582','PM0584','PM0801','PM0419','PM0678','PM0679','PM0376','PM0748','PM0844','PM0425','PM0459','PM0530','PM0576','PM0851','PM0751','PM0759','PM0021','PM0024','PM0035','PM0256','PM0372','PM0590','PM0026','PM0179','PM0241','PM0261','PM0266','PM0273','PM0295','PM0033','PM0264','PM0265','PM0044','PM0075','PM0120','PM0125','PM0132','PM0242','PM0084','PM0098','PM0170','PM0138','PM0218','PM0243','PM0272','PM0347','PM0365','PM0160','PM0627','PM0797','PM0201','PM0289','PM0072','PM0073','PM0074','PM0102','PM0133','PM0146','PM0223','PM0437','PM0551','PM0945','PM1007','PM0014','PM0037','PM0049','PM0056','PM0023','PM0321','PM0326','PM0371','PM0409','PM0426','PM0483','PM0498','PM0509','PM0586','PM0657','PM0717','PM0727','PM0850','PM0898','PM0907','PM0040','PM0316','PM0462','PM0479','PM0484','PM0505','PM0506','PM0531','PM0599','PM0656','PM0070','PM0103','PM0107','PM0110','PM0111','PM0117','PM0140','PM0145','PM0154','PM0192','PM0457','PM0574','PM0655','PM0123','PM0443','PM0641','PM0849','PM0869','PM0906','PM0135','PM0189','PM0695','PM0948','PM0312','PM0535','PM0589','PM0602','PM0694','PM0733','PM0773','PM0946','PM0338','PM0442','PM0555','PM0583','PM0621','PM0368','PM0440','PM0491','PM0619','PM0895','PM0990','PM0991','PM0460','PM0468','PM0480','PM0481','PM0511','PM0512','PM0757','PM0848','PM0858','PM0608','PM0912','PM0640','PM0642','PM0672','PM0676','PM0686','PM0887','PM0933','PM0934','PM0947','PM0964','PM0779','PM0859','PM0984','PM0987','PM0940','PM0953','PM0944','PM1003','PM0885','PM0564','PM0255','PM0834','PM0835','PM0879','PM0929','PM0942','PM0697','PM0830','PM0116','PM0119','PM0184','PM0216','PM0510','PM0769','PM0186','PM0360','PM0560','PM0711','PM0129','PM0288','PM0181','PM0245','PM0262','PM0011','PM0155','PM0222','PM0257','PM0558','PM0077','PM0152','PM0282','PM0402','PM0403','PM0536','PM0643','PM0700','PM0902','PM0903','PM0974','PM0082','PM0104','PM0252','PM0258','PM0263','PM0401','PM0712','PM0980','PM0995','PM0106','PM0169','PM0400','PM0954','PM0109','PM0136','PM0139','PM0187','PM0214','PM0585','PM0718','PM0770','PM0775','PM0926','PM0158','PM0225','PM0905','PM0174','PM0206','PM0301','PM0303','PM0313','PM0346','PM0554','PM0747','PM0836','PM0862','PM0897','PM0176','PM0215','PM0753','PM0899','PM0183','PM0217','PM0230','PM0284','PM0291','PM0300','PM0302','PM0305','PM0334','PM0339','PM0725','PM0857','PM0453','PM0811','PM0816','PM0861','PM0490','PM0839','PM0515','PM0950','PM0494','PM0613','PM0704','PM0977','PM0008','PM0012','PM0015','PM0016','PM0018','PM0399','PM0989','PM0423','PM0433','PM0434','PM0438','PM0444','PM0541','PM0552','PM0557','PM0659','PM0741','PM0777','PM0436','PM0755','PM0756','PM0789','PM0872','PM0890','PM0986','PM1002','PM0501','PM0742','PM0745','PM0503','PM0504','PM0720','PM0721','PM0736','PM0738','PM0739','PM0740','PM0845','PM0090','PM0092','PM0096','PM0097','PM0190','PM0304','PM0601','PM0873','PM0408','PM0456','PM0473','PM0600','PM0605','PM0534','PM0604','PM0065','PM0249','PM0267','PM0281','PM0324','PM0461','PM0981','PM0203','PM0210','PM0441','PM0647','PM0730','PM0794','PM0874','PM0960','PM0101','PM0124','PM0156','PM0167','PM0168','PM0171','PM0172','PM0191','PM0666','PM0749','PM0837','PM0209','PM0332','PM0341','PM0352','PM0366','PM0377','PM0378','PM0386','PM0559','PM0609','PM0238','PM0331','PM0335','PM0336','PM0340','PM0343','PM0348','PM0387','PM0388','PM0620','PM0251','PM0280','PM0294','PM0308','PM0309','PM0310','PM0463','PM0793','PM0806','PM0293','PM0330','PM0908','PM0963','PM0472','PM0507','PM0523','PM0719','PM0957','PM0961','PM1000','PM0764','PM1006','PM0985','PM1005','PM0752','PM0814','PM0982','PM0924','PM0951','PM0968','PM0966','PM0927','PM0979','PM0994','PM0996','PM0938') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice anda.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 andMATCH (a.modello,a.des_lung,a.codice) AGAINST ('tristar tostapane br1005 porta toast vasetto marmellata 30 801 50' IN BOOLEAN MODE) order by a.prz_ven_de1,a.modello,b.dsrTable LIMIT 0,15

    2012-11-13 9:28:02 - Lost connection toMySQL server during query
    select count(*) totrec from disponib a,marca b force index (PRIMARY,i_tipmez_1), pk_catego c force index(i_codice_1) where 1=1 and a.marca = b.codice and a.tipo_mezzo =b.tipo_mezzo and a.tipo_mezzoin('CS0001','CS0002','CS0018','CS0003','CS0017','CS0004','CS0019','CS0005','CS0006','CS0008','CS0007','CS0016','CS0010','CS0011','CS0009','CS0012','1','3','5','2','CS0013','CS0014','PM0041','CS0015','PM0680','DP0001','DP0002','DP0003','DP0004','DP0005','DP0007','DP0008','DP0009','DP0010','DP0011','DP0013','DP0014','DP0015','DP0016','PM0772','PM0928','PM0071','PM0467','PM0232','PM0429','PM0482','PM0570','PM0571','PM0664','PM0665','PM0166','PM0224','PM0771','PM0178','PM0276','PM0369','PM0517','PM0526','PM0528','PM0546','PM0556','PM0598','PM0629','PM0843','PM0863','PM0866','PM0896','PM0561','PM0967','PM0094','PM0121','PM0231','PM0239','PM0286','PM0532','PM0421','PM0029','PM0034','PM0036','PM0364','PM0587','PM0031','PM0038','PM0635','PM0636','PM0810','PM0840','PM0151','PM0153','PM0544','PM0628','PM0716','PM0886','PM0328','PM0431','PM0432','PM0538','PM0549','PM0611','PM0612','PM0618','PM0795','PM0798','PM0868','PM0919','PM0345','PM0370','PM0379','PM0382','PM0410','PM0766','PM0792','PM0847','PM0384','PM0508','PM0428','PM0572','PM0768','PM0841','PM0860','PM0959','PM0449','PM0709','PM0476','PM0622','PM0708','PM0478','PM0724','PM0790','PM0932','PM0955','PM0975','PM0978','PM0496','PM0864','PM0878','PM0592','PM0005','PM0707','PM0710','PM0205','PM0329','PM0706','PM0213','PM0888','PM0596','PM0674','PM0799','PM0781','PM0466','PM0920','PM0148','PM0395','PM0397','PM0398','PM0455','PM0520','PM0522','PM0876','PM0976','PM0892','PM0958','PM0901','PM0925','PM0998','PM1010','PM1012','PM0413','PM0784','PM0911','PM0651','PM0668','PM0922','PM0783','PM0913','PM0823','PM0969','PM0685','PM0567','PM0568','PM0569','PM0746','PM0723','PM0737','PM0921','PM0320','PM0389','PM0392','PM0393','PM0427','PM0516','PM0524','PM0606','PM0671','PM0675','PM0785','PM0786','PM0391','PM0614','PM0705','PM0796','PM0817','PM0818','PM0819','PM0820','PM0821','PM0880','PM0894','PM0645','PM0663','PM0693','PM0055','PM0812','PM0052','PM0057','PM0091','PM0095','PM0268','PM0333','PM0893','PM0113','PM0219','PM0518','PM0648','PM0728','PM0833','PM0852','PM0917','PM0962','PM0297','PM0315','PM0322','PM0731','PM0767','PM0856','PM0882','PM0923','PM1008','PM0350','PM0380','PM0762','PM0765','PM0941','PM0465','PM1004','PM1011','PM0470','PM0487','PM0513','PM0525','PM0553','PM0581','PM0610','PM0649','PM0726','PM0763','PM0802','PM0853','PM0854','PM0904','PM0965','PM0988','PM0999','PM0486','PM0758','PM0855','PM0877','PM0931','PM0935','PM0952','PM0993','PM0195','PM0196','PM0211','PM0247','PM0269','PM0271','PM0314','PM0323','PM0354','PM0357','PM0260','PM0270','PM0317','PM0325','PM0358','PM0373','PM0235','PM0381','PM0539','PM0540','PM0542','PM0623','PM0624','PM0729','PM0881','PM0356','PM0653','PM0654','PM0800','PM0447','PM0638','PM0451','PM0543','PM0550','PM0575','PM0548','PM0579','PM0580','PM0578','PM0828','PM0406','PM0068','PM0161','PM0197','PM0198','PM0199','PM0240','PM0279','PM0342','PM0351','PM0353','PM0363','PM0474','PM0658','PM0774','PM0910','PM0131','PM0142','PM0207','PM0226','PM0227','PM0228','PM0229','PM0283','PM0285','PM0290','PM0298','PM0299','PM0306','PM0307','PM0385','PM0646','PM0698','PM0699','PM0703','PM0972','PM0973','PM0362','PM0732','PM0626','PM0791','PM0670','PM0776','PM0735','PM0788','PM0744','PM0971','PM0761','PM0915','PM0060','PM0497','PM0278','PM0838','PM0715','PM0787','PM0809','PM0824','PM0829','PM0832','PM0916','PM0930','PM0826','PM0617','PM0804','PM0805','PM0970','PM0661','PM0673','PM0681','PM0682','PM0803','PM0087','PM0831','PM0689','PM0691','PM0918','PM0702','PM0713','PM0808','PM0871','PM0080','PM0141','PM0149','PM0537','PM0545','PM0144','PM0529','PM0630','PM0631','PM0632','PM0633','PM0634','PM0815','PM0842','PM0846','PM0865','PM0889','PM0248','PM0417','PM0221','PM0236','PM0415','PM0582','PM0584','PM0801','PM0419','PM0678','PM0679','PM0376','PM0748','PM0844','PM0425','PM0459','PM0530','PM0576','PM0851','PM0751','PM0759','PM0021','PM0024','PM0035','PM0256','PM0372','PM0590','PM0026','PM0179','PM0241','PM0261','PM0266','PM0273','PM0295','PM0033','PM0264','PM0265','PM0044','PM0075','PM0120','PM0125','PM0132','PM0242','PM0084','PM0098','PM0170','PM0138','PM0218','PM0243','PM0272','PM0347','PM0365','PM0160','PM0627','PM0797','PM0201','PM0289','PM0072','PM0073','PM0074','PM0102','PM0133','PM0146','PM0223','PM0437','PM0551','PM0945','PM1007','PM0014','PM0037','PM0049','PM0056','PM0023','PM0321','PM0326','PM0371','PM0409','PM0426','PM0483','PM0498','PM0509','PM0586','PM0657','PM0717','PM0727','PM0850','PM0898','PM0907','PM0040','PM0316','PM0462','PM0479','PM0484','PM0505','PM0506','PM0531','PM0599','PM0656','PM0070','PM0103','PM0107','PM0110','PM0111','PM0117','PM0140','PM0145','PM0154','PM0192','PM0457','PM0574','PM0655','PM0123','PM0443','PM0641','PM0849','PM0869','PM0906','PM0135','PM0189','PM0695','PM0948','PM0312','PM0535','PM0589','PM0602','PM0694','PM0733','PM0773','PM0946','PM0338','PM0442','PM0555','PM0583','PM0621','PM0368','PM0440','PM0491','PM0619','PM0895','PM0990','PM0991','PM0460','PM0468','PM0480','PM0481','PM0511','PM0512','PM0757','PM0848','PM0858','PM0608','PM0912','PM0640','PM0642','PM0672','PM0676','PM0686','PM0887','PM0933','PM0934','PM0947','PM0964','PM0779','PM0859','PM0984','PM0987','PM0940','PM0953','PM0944','PM1003','PM0885','PM0564','PM0255','PM0834','PM0835','PM0879','PM0929','PM0942','PM0697','PM0830','PM0116','PM0119','PM0184','PM0216','PM0510','PM0769','PM0186','PM0360','PM0560','PM0711','PM0129','PM0288','PM0181','PM0245','PM0262','PM0011','PM0155','PM0222','PM0257','PM0558','PM0077','PM0152','PM0282','PM0402','PM0403','PM0536','PM0643','PM0700','PM0902','PM0903','PM0974','PM0082','PM0104','PM0252','PM0258','PM0263','PM0401','PM0712','PM0980','PM0995','PM0106','PM0169','PM0400','PM0954','PM0109','PM0136','PM0139','PM0187','PM0214','PM0585','PM0718','PM0770','PM0775','PM0926','PM0158','PM0225','PM0905','PM0174','PM0206','PM0301','PM0303','PM0313','PM0346','PM0554','PM0747','PM0836','PM0862','PM0897','PM0176','PM0215','PM0753','PM0899','PM0183','PM0217','PM0230','PM0284','PM0291','PM0300','PM0302','PM0305','PM0334','PM0339','PM0725','PM0857','PM0453','PM0811','PM0816','PM0861','PM0490','PM0839','PM0515','PM0950','PM0494','PM0613','PM0704','PM0977','PM0008','PM0012','PM0015','PM0016','PM0018','PM0399','PM0989','PM0423','PM0433','PM0434','PM0438','PM0444','PM0541','PM0552','PM0557','PM0659','PM0741','PM0777','PM0436','PM0755','PM0756','PM0789','PM0872','PM0890','PM0986','PM1002','PM0501','PM0742','PM0745','PM0503','PM0504','PM0720','PM0721','PM0736','PM0738','PM0739','PM0740','PM0845','PM0090','PM0092','PM0096','PM0097','PM0190','PM0304','PM0601','PM0873','PM0408','PM0456','PM0473','PM0600','PM0605','PM0534','PM0604','PM0065','PM0249','PM0267','PM0281','PM0324','PM0461','PM0981','PM0203','PM0210','PM0441','PM0647','PM0730','PM0794','PM0874','PM0960','PM0101','PM0124','PM0156','PM0167','PM0168','PM0171','PM0172','PM0191','PM0666','PM0749','PM0837','PM0209','PM0332','PM0341','PM0352','PM0366','PM0377','PM0378','PM0386','PM0559','PM0609','PM0238','PM0331','PM0335','PM0336','PM0340','PM0343','PM0348','PM0387','PM0388','PM0620','PM0251','PM0280','PM0294','PM0308','PM0309','PM0310','PM0463','PM0793','PM0806','PM0293','PM0330','PM0908','PM0963','PM0472','PM0507','PM0523','PM0719','PM0957','PM0961','PM1000','PM0764','PM1006','PM0985','PM1005','PM0752','PM0814','PM0982','PM0924','PM0951','PM0968','PM0966','PM0927','PM0979','PM0994','PM0996','PM0938') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice anda.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 andMATCH (a.modello,a.des_lung,a.codice) AGAINST ('continentalsportcontact 225 50 r17 94w cerchione striscia ao' IN BOOLEAN MODE)

    2012-11-13 9:30:02 - Lost connection toMySQL server during query
    selecta.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTabledsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTabledsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1),pk_catego c force index (i_codice_1) where 1=1 and a.marca =b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('1') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice anda.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 andMATCH (a.modello,a.des_lung,a.codice) AGAINST ('avon zz3 245 40 r1791y bordino gomma protezione cerchio fianco pnuovo matico sava' INBOOLEAN MODE) order by a.prz_ven_de1,a.modello,b.dsrTable LIMIT6585,15

    2012-11-13 9:30:02 - MySQL server hasgone away
    select trim(cod_rag_prop),trim(tipo_artic), trim(cod_prop), trim(des_prop), trim(def_val) fromana_prop where tipo_artic = '1' order by tipo_artic, cod_rag_prop,cod_prop, def_val

    2012-11-13 9:32:01 - Lost connection toMySQL server during query
    selecta.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTabledsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTabledsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1),pk_catego c force index (i_codice_1) where 1=1 and a.marca =b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('1') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice anda.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 andMATCH (a.modello,a.des_lung,a.codice) AGAINST ('cp cp2 cp505 cp507cp519 205 60 r18 r30 re rw 12v 2v regala regali regalo atlas cleardunlop dot2009 viking dot 2009 pneumant gt radial 2004' IN BOOLEANMODE) order by a.prz_ven_de1,a.modello,b.dsrTable LIMIT 0,15

    2012-11-13 9:37:01 - Lost connection toMySQL server during query
    selecta.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTabledsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTabledsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1),pk_catego c force index (i_codice_1) where 1=1 and a.marca =b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('1') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice anda.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 andMATCH (a.modello,a.des_lung,a.codice) AGAINST ('245 40 r18vredestein' IN BOOLEAN MODE) order bya.prz_ven_de1,a.modello,b.dsrTable LIMIT 0,15

    Il problema è che queste querycrashate non me le ritrovo in alcun file di log di mysql! Inoltre ilsito lo vedo girare sempre regolarmente, non so quindi se in quesicasi il sito crasha a video.

    Per ovviare al problema leggevo di aggiungere la seguente riga ?mysqld:127.0.0.1? al file ?/etc/hosts.allow? e la seguente riga?skip-name-resolve? al file ?my.cnf.?. Quest'ultimo settaggiomi ha permesso di non perdere ripetutamente la connessione al db dalmio client remoto. Mentre per i suddetti errori loggati non ho ancoratrovato alcuna soluzione.

    Come faccio a capire cos'è che vasistemato?

    Attendo consigli.

    Grazie.

    0
  • P
    Moderatore •

    Quel tipo di errore è estremamente generico e di difficile diagnosi. Bisogna capire che innanzitutto non è un errore del server dbms, bensì del client. Questo è il motivo per cui non lo si trova in nessun file di log.

    Le cause più comuni sono: perdita della connessione, il server viene killato prima che possa rispondere alla query, mysql annulla delle connessioni per i motivi più svariati ( una race condition, query che dura troppo a lungo, ecc... ). In ogni caso è un problema dovuto al 90% a chi effettua la query ( e guardando le dimensioni di quelle query non rimangono molti dubbi ).

    Considera che mysql non è un dbms al livello di oracle e soci e bisogna accettare dei compromessi ( soprattutto se si usa il motore myisam ).

    0
  • N
    User •

    ma quindi come mi consigli di intervenire?
    ci sono parametri del file my.cnf che potrei settare per ovviare al problema?

    0
  • P
    Moderatore •

    Ovviamente no. Essendo un problema client-side, bisogna intervenire sull'applicazione che fa le query. Se sono troppe bisogna diminuirle, se c'è troppo "traffico" di query bisogna cercare di abbassarlo. Se si sono raggiunti i limiti di myisam bisogna passare ad un engine più performante ( o ad un dbms più capace ).

    Se cerchi su google trovi una valanga di guide su come ottimizzare mysql, ma parliamo pur sempre di placebo e soluzioni temporanee. In certi casi possono funzionare, ma in casi in cui si sono superati i limiti del dbms è impossibile risolvere con un "cerotto".

    Non voglio dire che non si può ottimizzare, ma c'è gente che ci perde mesi dietro e per ottenere risultati ottenibili di default installando un postgresql. Il gioco vale la candela?

    Se fossi in te comincerei col controllare il grado di concorrenza a cui è sottoposto il dbms, cioè se e quando capita che ci sono molte connessioni simultanee da parte del/i client. La concorrenza e le query troppo pesanti sono i due motivi più diffusi che generano quel tipo di errore.

    0
Effettua l'accesso per rispondere