From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Message-ID: <45BF5533.4000107@parkheights.dyndns.org> Date: Tue, 30 Jan 2007 09:24:51 -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> <45BE8598.6000504@parkheights.dyndns.org> <200701291856.19669.iadzhubey@rics.bwh.harvard.edu> In-Reply-To: <200701291856.19669.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: Tue, 30 Jan 2007 14:24:54 -0000 Archived-At: List-Archive: List-Post: Ivan Adzhubey wrote: > 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 mysq= l_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'),('586019277429= 8853 >>>> 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',= '517 >>> 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? >=20 > =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? >=20 > $ uname -a > Linux ika.bwh.harvard.edu 2.6.18-std-smp-alt3 #1 SMP Fri Dec 22 22:43:0= 4 MSK=20 > 2006 i686 GNU/Linux >=20 > --Ivan >=20 =FA=CE=C1=DE=C9=D4 =D5 =D7=C1=D3 =CB=C1=CB=C9=C5-=D4=CF =CF=DE=C5=CE=D8 =C8= =CF=D2=CF=DB=C9=C5 =CE=C1=D3=D4=D2=CF=CA=CB=C9 =D3=C5=D2=D7=C5=D2=C1 MySQ= L, =D4=C1=CB =DE=D4=CF =CF=CE =D0=CF =C4=C5=C6=CF=CC=D4=D5 =D3=CF=DA=C4=C1=A3=D4 =C2=CF=CC=C5=C5 =D0=D2= =C1=D7=C9=CC=D8=CE=D9=C5 =D4=C1=C2=CC=C9=C3=D9 =DE=C5=CD =D5 =CD=C5=CE=D1= . =F1 =D3=D0=C5=C3=C9=C1=CC=D8=CE=CF =D0=CF=D0=D2=CF=C2=CF=D7=C1=CC =D4=C5 =D6=C5 =D3=C1=CD=D9=C5 =DC=CB=D3=D0= =C5=D2=C9=CD=C5=CE=D4=D9 =D0=D2=CF=D7=A3=CC =D7 =D3=D7=C5=D6=C5=D3=C7=C5=CE= =C5=D2=C9=D2=CF=D7=C1=CE=CE=CF=CD =D7=C9=D2=D4=D5=C1=CC=D8=CE=CF=CD OpenVZ =CB=CF=CE=D4=C5=CA=CE=C5=D2=C5 =D3= =D3=C9=DA=C9=C6=CF=CD, =D4=C1=CB =DE=D4=CF =D5 =CD=C5=CE=D1 MySQL =D0=CF =D3=D2=C1=D7=CE=C5=CE=C9=C0 =D3 =F3=C9=DA=C9=C6=CF=CD =CE=C9=CB=C1=CB =CE= =C5 =C9=DA=CD=C5=CE=A3=CE =CE=C9 =D7 =CC=D5=DE=DB=D5=C0 =CE=C9 =D7 =C8=D5= =C4=DB=D5=C0 =D3=D4=CF=D2=CF=CE=D5. =FE=D4=CF =C5=DD=A3 =CD=CF=D6=C5=D4 =C2=D9=D4=D8? =F3=C2=CF=C9 =CF=C2=CF=D2= =D5=C4=CF=D7=C1=CE=C9=D1 - =D4=D2=D5=C4=CE=CF =D0=CF=D7=C5=D2=C9=D4=D8... =E9=CC=C9 MySQL =DC=D4=CF=D4 =D7=CF=CF=C2=DD=C5 =D2=C1=C2=CF=D4=C1=C5=D4 = =CE=C5=D0=D2=C5=C4=D3=CB=C1=DA=D5=C5=CD=CF? --=20 =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD, =F3=C5=D2=C7=C5=CA.