How to get size of queues

Moderator: crythias

Post Reply
klsoft
Znuny newbie
Posts: 30
Joined: 25 Jan 2017, 13:59
Znuny Version: 6.0.6
Real Name: Karol
Company: Core Networks

How to get size of queues

Post by klsoft »

Hi. This is simple question, basicly for someone who knows where in database are proper information.

I need to get list of queues with summarized sizes of them.

postmaster 5GB
some other one 10GB,

etc.

Simple sql query will be enough, but do someone know what to get from DB ?
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: How to get size of queues

Post by root »

Hi,

Size could be everything. DO you talkt about numbers of tickets, numbers of articles, sizes of attachments, ...?

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
klsoft
Znuny newbie
Posts: 30
Joined: 25 Jan 2017, 13:59
Znuny Version: 6.0.6
Real Name: Karol
Company: Core Networks

Re: How to get size of queues

Post by klsoft »

Size of attachments /Space on Disk

basicly I think it's content_size from article_data_mime_attachment table.

But calculated for every queue.
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: How to get size of queues

Post by root »

Hi,

Do you have the attachments in the database or in the filesystem?

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
klsoft
Znuny newbie
Posts: 30
Joined: 25 Jan 2017, 13:59
Znuny Version: 6.0.6
Real Name: Karol
Company: Core Networks

Re: How to get size of queues

Post by klsoft »

in DB
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: How to get size of queues

Post by root »

Hi,

to get a rought idea of the size try this:

Code: Select all

SELECT
    table_name,
    round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE table_schema = "otrs"
    AND table_name = "article_data_mime_attachment"
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Post Reply