From: Sergey Ivanov <seriv@parkheights.dyndns.org>
To: ALT Linux Sisyphus discussion list <sisyphus@lists.altlinux.org>
Subject: Re: [sisyphus] dspam-mysql vs MySQL server in Sisyphus
Date: Mon, 29 Jan 2007 18:39:04 -0500
Message-ID: <45BE8598.6000504@parkheights.dyndns.org> (raw)
In-Reply-To: <200701291816.10116.iadzhubey@rics.bwh.harvard.edu>
Ivan Adzhubey wrote:
> Приветствую!
>
> $ 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:
>> Привет всем.
>> Решил я попробовать dspam с mysql_storage.
>> Установил из текущего сизифа
>> # apt-get install dspam-mysql MySQL-server
>> со всем что требовалось по зависимостям
>> Затем решил провести проверку, не подвержен ли MySQL сервер багу,
>> препятствующему нормальной работе dspam'а:
>> ---
>> 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'),('5860192774298853742
>> '),('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','51746
>> 32569486238062','5860192774298853742'); +---------------------+
>>
>> | token |
>>
>> +---------------------+
>>
>> | 3232933621568372736 |
>> | 5860192774298853742 |
>> | 8029914733239132526 |
>>
>> +---------------------+
>> 3 rows in set (0.00 sec)
>> ---
>> Что не есть хорошо. По описаниям (см.
>>
>> http://dspam.nuclearelephant.com/dspam-users/0436.html) хороший MySQL
>> сервер должен вернуть пять записей.
>>
>> Значит ли это что у нас в Сизифе плохой MySQL сервер?
>> Или у dspam неправильные представления о том, как себя должен вести
>> MySQL сервер?
>
> 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','5174632569486238062','5860192774298853742');
> +---------------------+
> | token |
> +---------------------+
> | 3232933621568372736 |
> | 5174632569486238062 |
> | 5860192774298853742 |
> | 8787532532089676142 |
> | 8029914733239132526 |
> +---------------------+
> 5 rows in set (0.01 sec)
>
> --Ivan
>
Привет Иван.
У меня те же пакеты:
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
при этом uname -a
Linux alt64 2.6.18-ovz-smp-alt3 #1 SMP Tue Dec 5 22:41:47 MSK 2006
x86_64 GNU/Linux
Может быть у вас не x86_64?
--
Сергей
next prev parent reply other threads:[~2007-01-29 23:39 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2007-01-29 22:54 Sergey Ivanov
2007-01-29 23:16 ` Ivan Adzhubey
2007-01-29 23:39 ` Sergey Ivanov [this message]
2007-01-29 23:56 ` Ivan Adzhubey
2007-01-30 14:24 ` Sergey Ivanov
2007-01-30 17:40 ` Ivan Adzhubey
2007-01-30 18:35 ` Sergey Ivanov
2007-01-30 19:48 ` Ivan Adzhubey
2007-01-30 18:52 ` Sergey Ivanov
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=45BE8598.6000504@parkheights.dyndns.org \
--to=seriv@parkheights.dyndns.org \
--cc=sisyphus@lists.altlinux.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
ALT Linux Sisyphus discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \
sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru
public-inbox-index sisyphus
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.sisyphus
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git