Mailing List Archive: DBMail: users

some old questions.

Index | Next | Previous | View Threaded

fxp at corp

Dec 23, 2008, 6:59 AM

Post #1 of 4 (1081 views)
Permalink

some old questions.

Hi, my dear-dear all!
I have a "little" server, but mysql db already more than 10Gb.
Server has only 1Gb RAM, the questions is:
how to make my db smaller ? i think it`s just users who abondon my
server and just recieving spam. How to find their usernames ?
and i hope you have any suggestions about using mysqldump on InnoDB that
takes 10Gb+ space.

--
С уважением,
Юртайкин Андрей
системный администратор,
ЗАО "ИСКРАТЕЛЕКОМ"
тел.: 8(495) 926-68-63 доб. 070
fxp [at] corp, http://www.iskratelecom.ru

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

ml at kiewel-online

Dec 24, 2008, 12:58 PM

Post #2 of 4 (976 views)
Permalink

Re: some old questions. [In reply to]

Андрей Юртайкин wrote:
> Hi, my dear-dear all!
> I have a "little" server, but mysql db already more than 10Gb.
> Server has only 1Gb RAM, the questions is:

Same old answer:
Did you ever run dbmail-util for cleaning up the db?

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

michael.monnerie at is

Dec 24, 2008, 3:54 PM

Post #3 of 4 (974 views)
Permalink

Re: some old questions. [In reply to]

On Dienstag 23 Dezember 2008 Андрей Юртайкин wrote:
> i think it`s just users who abondon my
> server and just recieving spam. How to find their usernames ?

If you mean they still exist, make this:
select * from dbmail_users order by curmail_size;
Then you see which users use which space.

If you deleted the users already:
dbmail-util -ay

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4

Attachments:

signature.asc (0.19 KB)

mysql.jorge at decimal

Dec 25, 2008, 3:53 AM

Post #4 of 4 (967 views)
Permalink

RE: some old questions. [In reply to]

> If you mean they still exist, make this:
> select * from dbmail_users order by curmail_size; Then you see which
> users use which space.

The best way to see that a user abandon the account is by the login date.

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads