You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2017-06-15 23:29:42

bugless
Member
Registered: 2010-01-24
Posts: 37

Small issue with operating system tab

Actually 2 questions.

First, I upgraded from 0.90.5 to 9.1.3, and when adding a new item I noticed the operating system field has become an apart tab, just like the documents tab for example. I already read this was introduced since 9.1.
But this also meant I cannot create a new item and add its operating system at same time anymore. If I make changes in operating system tab then click save, it kind of updates/creates a template without creating the new item at all. I have to first fill the new item basic fields, add it, then come back and fill the rest of the tabs. Is this intended behavior?

Second, is the sql database meant to grow at a ridiculous exponential rate? Using MariaDB on Centos 7. I have circa 150 items total, each with a document, a jpg pic less than 150 Kb size. Back when I had just 50 items with their respective jpgs I made a mysqldump backup and size was just a couple of Mb. Starting at some point, adding one or 2 items made database grow one or two Mb bigger! And so on.
Back when having few items adding one single item with its respective document made database grow not much; now a single item addition can make it grow couple of Mb.
Right now circa 150 items, ~80 Mb size!?

Though I have been constantly upgrading glpi versions. I remember first one was 0.84.x, then passed through 0.90.1, then 0.90.5 and finally 9.1.3...

Thanks beforehand.

Offline

#2 2017-06-19 12:59:00

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: Small issue with operating system tab

For your first issue: https://github.com/glpi-project/glpi/issues/2322

For the second one, it's depends of the item. If your item is a computer and if you used FusionInventory agent, you have lot a event in the history


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#3 2017-06-19 17:34:34

bugless
Member
Registered: 2010-01-24
Posts: 37

Re: Small issue with operating system tab

So first issue was actually a bug all the time? Oh no...

Regarding second issue, no, I don't use FusionInventory. I add all items manually in the same way, by just filling the due fields and adding a document after that -a jpg file ~150 Kb size max-. Still I cannot understand how sql database seems to grow at a highly exponential rate rather than just at a linear rate...

Offline

#4 2017-07-18 18:55:26

bugless
Member
Registered: 2010-01-24
Posts: 37

Re: Small issue with operating system tab

bump

Offline

#5 2017-08-02 14:22:12

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: Small issue with operating system tab

First point solved in 9.1.5 version.
For second, jpg are not in the database but in files directory.
Is your glpi_logs very important?


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#6 2017-08-09 17:35:18

bugless
Member
Registered: 2010-01-24
Posts: 37

Re: Small issue with operating system tab

I perfectly know JPGs are inside the files directory and not in the database itself, which makes even less sense to my problem.
What does glpi_logs have to do at all with all of it? Logs should be just misserable plain text files anyways...

Second point has not been solved yet. How does sql database seem to grow at a highly exponential rate rather than just at a linear rate?
Please help

Offline

#7 2017-08-09 20:18:47

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: Small issue with operating system tab

i have a base with 336 entities, more than 30 000 computers and 60 000 users and my database doesn't grow as you said.
I don't understand why.


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

Board footer

Powered by FluxBB