[ixpmanager] 6.4.0 Upgrade issue?

[Edrich de Lange]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20240528/91d27610/attachment.htm>