Hello,
I am glad to joint the elastic stack community, to pars SQL logs I need to put together rows into one:
juin 26 13:30:05 sqlpc mysql-slow: SELECT fk.pib, fk.id, fk.idAccount, fk.idVad, fk.somevalue, fk.somevalue, fk.somevalue AS date, fk.somevalue, "no" AS somevalue
juin 26 13:30:05 sqlpc mysql-slow: FROM fkjuin 26 13:30:05 sqlpc mysql-slow: LEFT JOIN fkifhkj AS tfcd ON tfcd.lf = fk.id
juin 26 13:30:05 sqlpc mysql-slow: INNER JOIN somevalue ON somevalue = fk.id
juin 26 13:30:05 sqlpc mysql-slow: LEFT JOIN somevalue ON fk.id = somevalue
juin 26 13:30:05 sqlpc mysql-slow: LEFT JOIN somevalue on fk.id = somevalue
juin 26 13:30:05 sqlpc mysql-slow: WHERE (somevalue IS NULL) AND (somevalue = 'somevalue') AND (somevalue BETWEEN 'somevalue' AND 'somevalue') AND ((somevalue = 'somevalue'))
And also :
juin 26 01:06:35 pc-str END {
juin 26 01:06:35 pc-str print "processes.value " 0+processes;
juin 26 01:06:35 pc-str print "uninterruptible.value " 0+stat["D"];
juin 26 01:06:35 pc-str print "runnable.value " 0+stat["R"];
juin 26 01:06:35 pc-str print "sleeping.value " 0+stat["S"];
juin 26 01:06:35 pc-str print "idle.value " 0+stat["I"];
juin 26 01:06:35 pc-str print "stopped.value " 0+stat["T"];
juin 26 01:06:35 pc-str print "paging.value " 0+stat["W"];
juin 26 01:06:35 pc-str print "dead.value " 0+stat["X"];
juin 26 01:06:35 pc-str print "zombie.value " 0+stat["Z"];
juin 26 01:06:35 pc-str }
Can you help me to do this.
Best regards,