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:56:19 -0500 User-Agent: KMail/1.9.5 References: <45BE7B3D.4040703@parkheights.dyndns.org> <200701291816.10116.iadzhubey@rics.bwh.harvard.edu> <45BE8598.6000504@parkheights.dyndns.org> In-Reply-To: <45BE8598.6000504@parkheights.dyndns.org> MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200701291856.19669.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:56:35 -0000 Archived-At: List-Archive: List-Post: On Monday 29 January 2007 18:39, Sergey Ivanov wrote: > Ivan Adzhubey wrote: > > =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_= storage. > >> =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'),('58601927742988= 53 > >>742 '),('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','= 51 > >>746 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 > > in('3232933621568372736','8787532532089676142','8029914733239132526','5= 17 > >4632569486238062','5860192774298853742'); +---------------------+ > > > > | token | > > > > +---------------------+ > > > > | 3232933621568372736 | > > | 5174632569486238062 | > > | 5860192774298853742 | > > | 8787532532089676142 | > > | 8029914733239132526 | > > > > +---------------------+ > > 5 rows in set (0.01 sec) > > > > --Ivan > > =F0=D2=C9=D7=C5=D4 =E9=D7=C1=CE. > =F5 =CD=C5=CE=D1 =D4=C5 =D6=C5 =D0=C1=CB=C5=D4=D9: > 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 > > =D0=D2=C9 =DC=D4=CF=CD uname -a > Linux alt64 2.6.18-ovz-smp-alt3 #1 SMP Tue Dec 5 22:41:47 MSK 2006 > x86_64 GNU/Linux > =ED=CF=D6=C5=D4 =C2=D9=D4=D8 =D5 =D7=C1=D3 =CE=C5 x86_64? =EE=C5=D4, =C1 =CB=C1=CB=CF=C5 =DC=D4=CF =CD=CF=D6=C5=D4 =C9=CD=C5=D4=D8 = =DA=CE=C1=DE=C5=CE=C9=C5? $ uname -a Linux ika.bwh.harvard.edu 2.6.18-std-smp-alt3 #1 SMP Fri Dec 22 22:43:04 MS= K=20 2006 i686 GNU/Linux --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.