MySQL Forums
Forum List  »  Newbie

Re: Lost Connection or Running too long
Posted by: Ognen Kostovski
Date: June 02, 2017 09:36AM

[table]
[tr]
[td]id[/td]
[td]select_type[/td]
[td]table[/td]
[td]partitions[/td]
[td]type[/td]
[td]possible_keys[/td]
[td]key[/td]
[td]key_len[/td]
[td]ref[/td]
[td]rows[/td]
[td]filtered[/td]
[td]Extra[/td]
[/tr]
[tr]
[td]1[/td]
[td]PRIMARY[/td]
[td]comfidi_cr_aggregati[/td]
[td]null[/td]
[td]ALL[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]4957025[/td]
[td]27.10[/td]
[td]Using where[/td]
[/tr]
[tr]
[td]2[/td]
[td]UNION[/td]
[td]comfidi_cr_aggregati[/td]
[td]null[/td]
[td]ALL[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]4957025[/td]
[td]19.00[/td]
[td]Using where; Using temporary: Using filesort[/td]
[/tr]
[tr]
[td]null[/td]
[td]UNION RESULT[/td]
[td]<union1.2>[/td]
[td]null[/td]
[td]ALL[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]Using temporary[/td]
[/tr]
[/table]

I was not able to find the my.cnf/ini file, please give me some instructions if you need it still. I searched in C:\WINDOWS\ directory but neither my.cnf/ini nor my.ini !

(REFERENCE TABLE) comfidi_cr_aggregati TABLE:

[table]
[tr]
[td]NR_CR[/td]
[td]PERIODO_RIF[/td]
[td]CATEGORIA[/td]
[td]ACCORDATO[/td]
[td]ACC_OPERATIVO[/td]
[td]UTILIZZATO[/td]
[td]SALDO_MEDIO[/td]
[td]VAL_GARANZIA[/td]
[td]IMPORTO_GAR[/td]
[td]VAL_INTRINSECO[/td]
[td]ALTRI_IMPORTI[/td]
[td]SCONFINAMENTO[/td]
[/tr]
[tr]
[td]10924921[/td]
[td]201301[/td]
[td]550600[/td]
[td]125000[/td]
[td]125000[/td]
[td]131662[/td]
[td]127467[/td]
[td]0[/td]
[td]0[/td]
[td]0[/td]
[td]0[/td]
[td]8067[/td]
[/tr]
[/table]

Options: ReplyQuote


Subject
Written By
Posted
Re: Lost Connection or Running too long
June 02, 2017 09:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.