From: Garot Conklin Date: August 21 2012 4:13pm Subject: Re: Machine Learning List-Archive: http://lists.mysql.com/mysql/228034 Message-Id: <1345565627.8857.YahooMailNeo@web140503.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1767455036-215228966-1345565627=:8857" --1767455036-215228966-1345565627=:8857 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 1)Refer to it for =E2=80=98knowledge=E2=80=99 (for instance, of what the la= test=0Aversion of a command is)=0A=C2=A0=C2=A0=C2=A0 It would most likely e= nd up being "central" in this sense:=0A=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2= =A0 A distributed collection of systems; i.e. (possible defined in roles)= =0A=0A=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 DB's=0A=C2= =A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 FE's=0A=C2=A0=C2=A0= =C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 REPL's=0A=C2=A0=C2=A0=C2=A0 = =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 Cache's=0A=C2=A0=C2=A0=C2=A0 =C2=A0= =C2=A0=C2=A0 Each DB would have its own collection of remediation's that wo= uld then be indexed to populate a central db for trending/correlation etc..= .=0A=0A=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 The "Collective" itself would = function as a single conceptual implementation. A VIP for example might be = associated with a specific role, say Web FE's and remediate only/all of the= m, but only have some relative access to the core db of say the Network fro= m a Primary index perspective to make/draw associations/conclusions to issu= es at hand.=0A=0A=0A=0A2)Send their =E2=80=98knowledge=E2=80=99 (for instan= ce, of the latest command=0Aversions) to it for storage and distribution to= others=0A=C2=A0=C2=A0=C2=A0Rather than "latest command versions" I envisio= n this to be more encapsulated as "latest successful invocation of the comm= and string" and it inverse as well (to trend/metric-ize the failures thus l= ending to perpetual optimization).=0A=0AI like how this is fleshing out... = This is helping me to define what I am really trying to accomplish. Thanks = very much for everyone responding here, this is wonderful, please keep this= going...=0A=0A=C2=A0=0Agarotconklin@stripped=0A=0A=0A____________________= ____________=0A From: "webmaster@stripped" =0ATo:= 'Martin Gainty' ; garotconklin@stripped; mysql@lists= .mysql.com =0ASent: Tuesday, August 21, 2012 11:19 AM=0ASubject: RE: Machin= e Learning=0A =0AHi Garot,=0A=0A=0A=0AOk, the concept is getting clearer, b= ut let=E2=80=99s bring this down to earth a=0Alittle bit more. I love DB de= sign and problem-solving and am quite curious=0Aabout this.=0A=0A=0A=0AIs t= he idea that you have a central computer (not HAL J) somewhere so that=0Aot= her computers can:=0A=0A1)=C2=A0 =C2=A0 =C2=A0 Refer to it for =E2=80=98kno= wledge=E2=80=99 (for instance, of what the latest=0Aversion of a command is= )=0A=0A2)=C2=A0 =C2=A0 =C2=A0 Send their =E2=80=98knowledge=E2=80=99 (for i= nstance, of the latest command=0Aversions) to it for storage and distributi= on to others=0A=0A=0A=0AIf this is the model, then the knowledge base can b= uild up organically over=0Atime =E2=80=93 I think. Or is this too simplisti= c ?=0A=0A=0A=0AThanks,=0A=0AJustin=0A=0A=0A=0AFrom: Martin Gainty [mailto:m= gainty@stripped] =0ASent: 21 August 2012 00:25=0ATo: garotconklin@yahoo.= com; webmaster@stripped; mysql@stripped=0ASubject: RE: Machine Le= arning=0A=0A=0A=0AWhen I hear 'AI' I always imagine theres a HAL 9001 behin= d the scenes that=0Ais running the show constantly admonishing its creator = to "take another=0Astress pill"=0A=0ASounds like a fun project=0A=0AKeep us= apprised,=0AMartin Gainty =0A_____________________________________________= _ =0AVerzicht und Vertraulichkeitanmerkung/Note de d=C3=A9ni et de confiden= tialit=C3=A9=0A=0A=0ADiese Nachricht ist vertraulich. Sollten Sie nicht der= vorgesehene=0AEmpfaenger sein, so bitten wir hoeflich um eine Mitteilung. = Jede unbefugte=0AWeiterleitung oder Fertigung einer Kopie ist unzulaessig. = Diese Nachricht=0Adient lediglich dem Austausch von Informationen und entfa= ltet keine=0Arechtliche Bindungswirkung. Aufgrund der leichten Manipulierba= rkeit von=0AE-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.= =0A=0ACe message est confidentiel et peut =C3=AAtre privil=C3=A9gi=C3=A9. S= i vous n'=C3=AAtes pas le=0Adestinataire pr=C3=A9vu, nous te demandons avec= bont=C3=A9 que pour satisfaire=0Ainformez l'exp=C3=A9diteur. N'importe que= lle diffusion non autoris=C3=A9e ou la copie=0Ade ceci est interdite. Ce me= ssage sert =C3=A0 l'information seulement et n'aura=0Apas n'importe quel ef= fet l=C3=A9galement obligatoire. =C3=89tant donn=C3=A9 que les email=0Apeuv= ent facilement =C3=AAtre sujets =C3=A0 la manipulation, nous ne pouvons acc= epter=0Aaucune responsabilit=C3=A9 pour le contenu fourni.=0A=0A=0A=0A=0A= =0A=C2=A0 _____=C2=A0 =0A=0ADate: Mon, 20 Aug 2012 13:50:04 -0700=0AFrom: g= arotconklin@stripped=0ASubject: Re: Machine Learning=0ATo: webmaster@lisol= .co.uk; mgainty@stripped; mysql@stripped=0A=0AYa the idea is not = anything new, but must be apparently quit difficult or=0Anot a priority as = I have yet to find it already implemented anywhere... Far=0Abe it from me t= o not make some attempt here anyway...=0A=0A=0A=0AI am creating a fully aut= omated framework from which a distributed=0Ainfrastructure can be maintaine= d.=C2=A0 I have been writing automation=0Ascripts/code for some time now an= d the logical progression is to embark on a=0Afull concept of systems healt= h auto remediation.=C2=A0 I have numerous=0A"monitoring" solutions under my= control however none that properly (in my=0Aopinion) implements any real l= earning algorithms from which to draw even a=0Aminimalists view of automati= on.=C2=A0 I like mySQL therefor began thinking about=0Acreating the aspects= (lobes) of the "brain" as a relational database(s).=C2=A0 So=0Athis is onl= y one facet of what I am trying to do, however leveraging a full=0Acommand = set of shell utilities/commands/programs seemed to be a good=0Astarting poi= nt before I get into the "hard" stuff ! =0A=0A=0A=0A-Garot=0A=0A=0A=0Agarot= conklin@stripped=0A=0A=C2=A0 _____=C2=A0 =0A=0AFrom: "webmaster@stripped= k" =0ATo: 'Martin Gainty' ; gar= otconklin@stripped;=0Amysql@stripped =0ASent: Monday, August 20, 20= 12 3:55 PM=0ASubject: RE: Machine Learning=0A=0A=0AHi Garot,=0A=0A=0A=0AYou= 'll have to elaborate some more ... I understand you may want to protect=0A= the idea as well, so if you can narrow it down to some technical specifics= =0Athen it'll help.=0A=0A=0A=0AWhat is the objective of this system, for in= stance ?=0A=0A=0A=0AThanks,=0A=0AJustin=0A=0A=0A=0AFrom: Martin Gainty [mai= lto:mgainty@stripped] =0ASent: 20 August 2012 19:23=0ATo: garotconklin@y= ahoo.com; webmaster@stripped; mysql@stripped=0ASubject: RE: Machi= ne Learning=0A=0A=0A=0A=0A=0AFrom: garotconklin@stripped=0ASubject: Re: Ma= chine Learning=0ATo: webmaster@stripped; mgainty@stripped; mysql@list= s.mysql.com=0A=0A=0AMy initial thought was to propagate the db with everyth= ing and allow the=0Aalgorithm to then begin to determin trends/patterns=0AM= G>which trends or patterns will you be modelling?=0A=0Aand begin either an = indexing methodology=0AMG>which indexes are you considering: Unique index, = primary index or foreign=0Aindex?=0A=0Aadditional table/db creation process= or both to further optimize the calls=0Abeing made=0AMG>optimize based on = execution time or diskspace allocated, EliminatingFTS=0Aor some other crite= ria?=0AMG>https://dev.mysql.com/doc/refman/5.5/en/optimization.html=0A=0Aan= d build in some internal levels of redundancy.=0AMG>what about replication= =0AMG>http://dev.mysql.com/doc/refman/5.5/en/replication.html=0A=0AI am act= ually approaching this with some degree of biological conception in=0Athe m= ultipathing within our own brains however until I have something up and=0Ar= unning under some substantial load however I may not get a complete=0Apictu= re. =0A=0AThanks,=0A=0AGarot=0A=0A=0AInteresting=0AMartin=0A=0A=C2=A0 _____= =C2=A0 =0A=0AFrom: webmaster@stripped ; =0ATo: 'G= arot Conklin' ; 'Martin Gainty'=0A; ; =0ASubject: RE: Machine Learning =0ASent: Mo= n, Aug 20, 2012 7:13:25 AM =0A=0A=0AHi Garot,=0A=0AThis sounds an interesti= ng idea.=0A=0AAre you looking to store all known commands and their options= or are you=0Alooking for a 'formula' for calling any unix command ?=0A=0AT= he reason for my question is that, at the end of the day, a unix command is= =0Ajust a program that is run in the operating system. Each program comes w= ith=0Aits own options and acceptable inputs. I don't know if there is a rul= e or=0Aconvention for structuring these commands.=0A=0AAre you then looking= to build a system that 'knows' all commands and 'how=0Ato' call them ?=0A= =0AThanks,=0AJustin=0A=0A-----Original Message-----=0AFrom: Garot Conklin [= mailto:garotconklin@stripped] =0ASent: 20 August 2012 03:39=0ATo: Martin G= ainty; mysql@stripped=0ASubject: Re: Machine Learning=0A=0AThe initi= al goal is to provide a working framework from which to call all=0AUNIX she= ll command combinations as the underlying storage mechanism for a=0Amachine= learning algorithm.=C2=A0 I would like to build a completely self aware=0A= instantiation that will maintain itself on all levels... I postulate that= =0Athe first place to start would be in determining a method for maintainin= g=0Aall possible remediation combinations including the unknown to eventual= ly be=0Alearned from and populate new knowledge into the database.=C2=A0 Th= ank you for=0Athe reply,=0A=0AGarot --1767455036-215228966-1345565627=:8857--