From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Message-ID: <45BE8598.6000504@parkheights.dyndns.org> Date: Mon, 29 Jan 2007 18:39:04 -0500 From: Sergey Ivanov User-Agent: Thunderbird 1.5.0.9 (X11/20061222) MIME-Version: 1.0 To: ALT Linux Sisyphus discussion list References: <45BE7B3D.4040703@parkheights.dyndns.org> <200701291816.10116.iadzhubey@rics.bwh.harvard.edu> In-Reply-To: <200701291816.10116.iadzhubey@rics.bwh.harvard.edu> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: quoted-printable 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:39:16 -0000 Archived-At: List-Archive: List-Post: Ivan Adzhubey wrote: > =F0=D2=C9=D7=C5=D4=D3=D4=D7=D5=C0! >=20 > $ 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 >=20 > 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) >=20 > mysql> create database dspam; > Query OK, 1 row affected (0.03 sec) >=20 > mysql> use dspam; > Database changed > mysql> create table dspam_test (token bigint(20)); > Query OK, 0 rows affected (0.03 sec) >=20 >> mysql> insert into dspam_test >> values('3232933621568372736'),('5174632569486238062'),('58601927742988= 53742 >> '),('8787532532089676142'),('8029914733239132526'); Query OK, 5 rows >> affected (0.00 sec) >> Records: 5 Duplicates: 0 Warnings: 0 >=20 > 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 >=20 >> mysql> select token from dspam_test where token >> in('3232933621568372736','8787532532089676142','8029914733239132526','= 51746 >> 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? >=20 > mysql> select * from dspam_test; > +---------------------+ > | token | > +---------------------+ > | 3232933621568372736 | > | 5174632569486238062 | > | 5860192774298853742 | > | 8787532532089676142 | > | 8029914733239132526 | > +---------------------+ > 5 rows in set (0.00 sec) >=20 > mysql> select token from dspam_test where token=20 > in('3232933621568372736','8787532532089676142','8029914733239132526','5= 174632569486238062','5860192774298853742'); > +---------------------+ > | token | > +---------------------+ > | 3232933621568372736 | > | 5174632569486238062 | > | 5860192774298853742 | > | 8787532532089676142 | > | 8029914733239132526 | > +---------------------+ > 5 rows in set (0.01 sec) >=20 > --Ivan >=20 =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? --=20 =F3=C5=D2=C7=C5=CA