From: Garot Conklin Date: August 20 2012 7:39pm Subject: Re: Machine Learning List-Archive: http://lists.mysql.com/mysql/228022 Message-Id: <1345491592.67491.YahooMailNeo@web140506.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1594581660-688563694-1345491592=:67491" --1594581660-688563694-1345491592=:67491 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable MG>which trends or patterns will you be modelling?=A0 ALL (interesting answ= er if you allow yourself to consider that there really are no restrictions = aside from those we would impose here)=0A=0AMG>which indexes are you consid= ering: Unique index, primary index or foreign index?Primary for speed howev= er unique may be more useful to keep the unwanted redundancy to a minimum.= =0A=0A=0AMG>optimize based on execution time or diskspace allocated, Elimin= atingFTS or some other criteria? As diskspace is somewhat less concerning t= hese days, I would like to focus on execution time.=0A=0A=0AMG>what about r= eplication -Yes, however I wanted an internal form of redundancy as well as= distributed.=0A=0A=0A=0Agarotconklin@stripped=0A=0A=0A___________________= _____________=0A From: Martin Gainty =0ATo: garotconkl= in@stripped; webmaster@stripped; "mysql@stripped" =0ASent: Monday, August 20, 2012 2:23 PM=0ASubject: RE: Machine L= earning=0A =0A=0A=0AFrom: garotconklin@stripped=0ASubject: Re: Machine Lea= rning=0ATo: webmaster@stripped; mgainty@stripped; mysql@stripped= om=0A=0AMy initial thought was to propagate the db with everything and allo= w the algorithm to then begin to determin trends/patterns=0AMG>which trends= or patterns will you be modelling?=0A=0Aand begin either an indexing metho= dology=0AMG>which indexes are you considering: Unique index, primary index = or foreign index?=0A=0Aadditional table/db creation process or both to furt= her optimize the calls being made=0AMG>optimize based on execution time or = diskspace allocated, EliminatingFTS or some other criteria?=0AMG>https://de= v.mysql.com/doc/refman/5.5/en/optimization.html=0A=0Aand build in some inte= rnal levels of redundancy.=0AMG>what about replication=0AMG>http://dev.mysq= l.com/doc/refman/5.5/en/replication.html=0A=0AI am actually approaching thi= s with some degree of biological conception in the multipathing within our = own brains however until I have something up and running under some substan= tial load however I may not get a complete picture.=A0 =0A=0AThanks,=0A=0AG= arot=A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0AInteresting=0AMartin=0A=0A=A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 From:=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 webmaster@stripped ;=A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 To:=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 'Garot C= onklin' ; 'Martin Gainty' ;=A0= ;=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =0A=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Subject:=0A=A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 RE: Machine Learning=A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 Sent:=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Mon, Aug 20= , 2012 7:13:25 AM=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =0A=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=0A=A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Hi 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.=A0 I would like to build a completely self aware=0Ains= tantiation that will maintain itself on all levels... I postulate that=0Ath= e first place to start would be in determining a method for maintaining=0Aa= ll possible remediation combinations including the unknown to eventually be= =0Alearned from and populate new knowledge into the database.=A0 Thank you = for=0Athe reply,=0A=0AGarot --1594581660-688563694-1345491592=:67491--