Gábor Váradi wrote:
> 2008-08-19 11:39 napon Gabor HALASZ <[EMAIL PROTECTED]> írta:
>> Gábor Váradi wrote:
>>> Mekkora volt a ~50k levél mérete a diszken és most mekkora az SQL
>>> adatbázis mérete a diszken?
>>>
>> Tudtam, hogy valami kiment a fejembol :)
>> Ez igen erdekes tapasztalas, nezek is butan:
>>
>> # du -sh /home/HalaszGabor/Maildir/.Linux\ Kezdo/cur/
>> 277.5M /home/HalaszGabor/Maildir/.Linux Kezdo/cur
>> # du -sh /home/mysql/dbmail
>> 293.0k /home/mysql/dbmail
>
> Nem arról volt szó, hogy magát a levelet is beleteszi az adatbázisba?
>
Szerintem benne is van, egyreszt latom a thunderbirdben, vagy aminek
hivjak eppen debianek (aliased ip-n log a dbmail, csak nem keveri az
imap szervereket), masreszt:
mysql> select count(*) from dbmail_messageblks;
+----------+
| count(*) |
+----------+
| 101574 |
+----------+
1 row in set (10.11 sec)
Most nincs kedvem atnyalaznia database relations nevu hosszu
olvasnivalot, igy:
mysql> desc dbmail_messageblks;
+-----------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-----------------+---------------------+------+-----+---------+----------------+
| messageblk_idnr | bigint(20) unsigned | NO | PRI | NULL |
auto_increment |
| physmessage_id | bigint(20) unsigned | NO | MUL | 0 |
|
| messageblk | longblob | NO | | |
|
| blocksize | bigint(20) unsigned | NO | | 0 |
|
| is_header | tinyint(3) unsigned | NO | | 0 |
|
+-----------------+---------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
Ezek utan talalomra:
mysql> select messageblk from dbmail_messageblks where
messageblk_idnr=12432;
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| messageblk
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2003. január 7. 15:58 datummal Mezei Zoltan irta:
> Nem a subject a gaz, a felado legyen _pontosan_ ugyanaz, mint amit
> megadtal a listszervernek.
Ez erdekes. En a linux-kezdo es a linux listara vilag eletemben
egesz mas cimrol irogattam, es irogatok maig, mint amire
regisztraltam, es amire kapom :-o Egyedul a linux-hw nem megy igy.
Udv!
--
Vastagh Norbert
Compatibil 2000 Kft.
e-mail: [EMAIL PROTECTED]
www.compatibil.hu
_______________________________________________________
linux-kezdo lista - [EMAIL PROTECTED]
http://mlf.linux.rulez.org/mailman/listinfo/linux-kezdo
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
(Bocs az erintettektol ;)
--
Gabor HALASZ <[EMAIL PROTECTED]>
_________________________________________________
linux lista - [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux
