[ixpmanager] 6.4.0 Upgrade issue?

[Edrich de Lange]

Ok, so after truncating it, within a couple of hours the table is back 
to 1G and the Sql has slowed down.

Leaving it off for now, but I suspect Nishal is going to throw a shoe at 
me since he uses it a bit.

Most of the errors in there are all the driver errors, and generates one 
for seemingly every time someone access something.

Kind regards

Edd

On 28 May 2024, at 9:20, Edrich de Lange via ixpmanager wrote:

> The table was just over a gig.
>
> Ive reenabled telescope , and its not maxing mysql yet, but will look 
> after a while
>
> It looks like it was running multiple updates on the same table, and 
> that slowed things down the whole time.
>
> And I suspect the DB is growing rapidly due to the driver error from 
> the php 8.1 vs 8
>
> Kind regards
>
> Edd
>
> On 27 May 2024, at 17:18, Barry O'Donovan (INEX) wrote:
>
>> Hi Ed,
>>
>> we haven't seen any performance issues in development or production. 
>> Your snippet below shows a lot happening with Telescope
>>
>> What does this SQL command show you:
>>
>> SELECT   TABLE_NAME AS `Table`,
>>       ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size 
>> (MB)`
>>     FROM   information_schema.TABLES
>>     WHERE
>>         TABLE_SCHEMA = "ixpmanager" AND TABLE_NAME LIKE 'telescope%'
>>   ORDER BY   (DATA_LENGTH + INDEX_LENGTH) DESC;
>>
>> changing "ixpmanager" to your database name as appropriate.
>>
>>
>> Once you've done that, and if big, you can also run the following in 
>> the database to clear it out:
>>
>> SET FOREIGN_KEY_CHECKS = 0;
>> TRUNCATE TABLE telescope_entries_tags;
>> TRUNCATE TABLE telescope_entries;
>> TRUNCATE TABLE telescope_monitoring;
>> SET FOREIGN_KEY_CHECKS = 1;
>>
>>
>> Also try adding the following to your .env:
>>
>> TELESCOPE_ENABLED=false
>>
>>> After digging around some more, there seems to be a lot of errors in 
>>> the logs, and any command we run seems to generate the below error
>>>
>>> PHP Warning: Undefined array key "driver" in
>>
>>> @portal:/srv/ixpmanager# php -v
>>> PHP 8.1.28 (cli) (built: May 23 2024 12:32:40) (NTS)
>>
>> Yeah, those errors are because you're running IXP Manager v6 which is 
>> targeted at PHP 8.0 on an 8.1 version. It's fine and they are only 
>> warnings.
>>
>>  - Barry

> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> Unsubscribe or change options here: 
> https://www.inex.ie/mailman/listinfo/ixpmanager
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20240528/9011ae0e/attachment.htm>