From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-CGP-ClamAV-Result: CLEAN X-VirusScanner: CGPClamav by Niversoft From: Ivan Adzhubey Organization: BWH Genetics Division To: ALT Linux Sisyphus discussion list Date: Mon, 29 Jan 2007 18:16:09 -0500 User-Agent: KMail/1.9.5 References: <45BE7B3D.4040703@parkheights.dyndns.org> In-Reply-To: <45BE7B3D.4040703@parkheights.dyndns.org> MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200701291816.10116.iadzhubey@rics.bwh.harvard.edu> Subject: Re: [sisyphus] dspam-mysql vs MySQL server in Sisyphus X-BeenThere: sisyphus@lists.altlinux.org X-Mailman-Version: 2.1.9rc1 Precedence: list Reply-To: ALT Linux Sisyphus discussion list List-Id: ALT Linux Sisyphus discussion list List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 29 Jan 2007 23:16:24 -0000 Archived-At: List-Archive: List-Post: =F0=D2=C9=D7=C5=D4=D3=D4=D7=D5=C0! $ rpm -qa|grep MySQL|sort libMySQL-5.0.27-alt1.1 libMySQL-devel-5.0.27-alt1.1 MySQL-client-5.0.27-alt1.1 MySQL-server-5.0.27-alt1.1 MySQL-server-perl-5.0.27-alt1.1 On Monday 29 January 2007 17:54, Sergey Ivanov wrote: > =F0=D2=C9=D7=C5=D4 =D7=D3=C5=CD. > =F2=C5=DB=C9=CC =D1 =D0=CF=D0=D2=CF=C2=CF=D7=C1=D4=D8 dspam =D3 mysql_sto= rage. > =F5=D3=D4=C1=CE=CF=D7=C9=CC =C9=DA =D4=C5=CB=D5=DD=C5=C7=CF =D3=C9=DA=C9= =C6=C1 > # apt-get install dspam-mysql MySQL-server > =D3=CF =D7=D3=C5=CD =DE=D4=CF =D4=D2=C5=C2=CF=D7=C1=CC=CF=D3=D8 =D0=CF = =DA=C1=D7=C9=D3=C9=CD=CF=D3=D4=D1=CD > =FA=C1=D4=C5=CD =D2=C5=DB=C9=CC =D0=D2=CF=D7=C5=D3=D4=C9 =D0=D2=CF=D7=C5= =D2=CB=D5, =CE=C5 =D0=CF=C4=D7=C5=D2=D6=C5=CE =CC=C9 MySQL =D3=C5=D2=D7=C5= =D2 =C2=C1=C7=D5, > =D0=D2=C5=D0=D1=D4=D3=D4=D7=D5=C0=DD=C5=CD=D5 =CE=CF=D2=CD=C1=CC=D8=CE=CF= =CA =D2=C1=C2=CF=D4=C5 dspam'=C1: > --- > mysql> create table dspam_test (token bigint(20)); > Query OK, 0 rows affected (0.01 sec) mysql> create database dspam; Query OK, 1 row affected (0.03 sec) mysql> use dspam; Database changed mysql> create table dspam_test (token bigint(20)); Query OK, 0 rows affected (0.03 sec) > mysql> insert into dspam_test > values('3232933621568372736'),('5174632569486238062'),('58601927742988537= 42 >'),('8787532532089676142'),('8029914733239132526'); Query OK, 5 rows > affected (0.00 sec) > Records: 5 Duplicates: 0 Warnings: 0 mysql> insert into dspam_test values('3232933621568372736'), ('5174632569486238062'),('5860192774298853742'),('8787532532089676142'), ('8029914733239132526'); Query OK, 5 rows affected (0.00 sec) Records: 5 Duplicates: 0 Warnings: 0 > mysql> select token from dspam_test where token > in('3232933621568372736','8787532532089676142','8029914733239132526','517= 46 >32569486238062','5860192774298853742'); +---------------------+ > > | token | > > +---------------------+ > > | 3232933621568372736 | > | 5860192774298853742 | > | 8029914733239132526 | > > +---------------------+ > 3 rows in set (0.00 sec) > --- > =FE=D4=CF =CE=C5 =C5=D3=D4=D8 =C8=CF=D2=CF=DB=CF. =F0=CF =CF=D0=C9=D3=C1= =CE=C9=D1=CD (=D3=CD. > > http://dspam.nuclearelephant.com/dspam-users/0436.html) =C8=CF=D2=CF=DB= =C9=CA MySQL > =D3=C5=D2=D7=C5=D2 =C4=CF=CC=D6=C5=CE =D7=C5=D2=CE=D5=D4=D8 =D0=D1=D4=D8 = =DA=C1=D0=C9=D3=C5=CA. > > =FA=CE=C1=DE=C9=D4 =CC=C9 =DC=D4=CF =DE=D4=CF =D5 =CE=C1=D3 =D7 =F3=C9=DA= =C9=C6=C5 =D0=CC=CF=C8=CF=CA MySQL =D3=C5=D2=D7=C5=D2? > =E9=CC=C9 =D5 dspam =CE=C5=D0=D2=C1=D7=C9=CC=D8=CE=D9=C5 =D0=D2=C5=C4=D3= =D4=C1=D7=CC=C5=CE=C9=D1 =CF =D4=CF=CD, =CB=C1=CB =D3=C5=C2=D1 =C4=CF=CC=D6= =C5=CE =D7=C5=D3=D4=C9 > MySQL =D3=C5=D2=D7=C5=D2? mysql> select * from dspam_test; +---------------------+ | token | +---------------------+ | 3232933621568372736 | | 5174632569486238062 | | 5860192774298853742 | | 8787532532089676142 | | 8029914733239132526 | +---------------------+ 5 rows in set (0.00 sec) mysql> select token from dspam_test where token=20 in('3232933621568372736','8787532532089676142','8029914733239132526','51746= 32569486238062','5860192774298853742'); +---------------------+ | token | +---------------------+ | 3232933621568372736 | | 5174632569486238062 | | 5860192774298853742 | | 8787532532089676142 | | 8029914733239132526 | +---------------------+ 5 rows in set (0.01 sec) --Ivan THE INFORMATION TRANSMITTED IN THIS ELECTRONIC COMMUNICATION IS INTENDED ON= LY FOR THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY CONTAIN CONFIDE= NTIAL AND/OR PRIVILEGED MATERIAL. ANY REVIEW, RETRANSMISSION, DISSEMINATIO= N OR OTHER USE OF OR TAKING OF ANY ACTION IN RELIANCE UPON, THIS INFORMATIO= N BY PERSONS OR ENTITIES OTHER THAN THE INTENDED RECIPIENT IS PROHIBITED. = IF YOU RECEIVED THIS INFORMATION IN ERROR, PLEASE CONTACT THE SENDER AND TH= E PRIVACY OFFICER, AND PROPERLY DISPOSE OF THIS INFORMATION.